News

Release announcements, upcoming features, and project updates.

Upcoming
Upcoming Q2 2026

User-Defined Functions & Window Functions

Planned for mid-2026, these features will expand SQL capabilities significantly:

  • User-defined functions — Register C# functions callable from SQL, plus native plugin extensions
  • Window functions — ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG() for analytical queries
  • DEFAULT & CHECK constraints — Default column expressions and expression-based table constraints
Upcoming Q2 2026

Remote Host Consolidation & Security

Merging REST/HTTP into CSharpDB.Daemon for a single unified server host, plus built-in security:

  • Unified daemon — REST, gRPC, and future transports from one process with a shared warm Database instance
  • Authentication & authorization — API keys, protected admin endpoints, and role-based access
  • TLS/mTLS support — Secure connections for production deployments
Future 2026+

On the Research Radar

Long-term research items being explored for future versions:

  • At-rest encryption — Encrypt database and WAL files with passphrase-based key management
  • Multi-writer support — Concurrent write transactions with conflict detection
  • Replication & change feed — Stream committed changes for read replicas or event-driven architectures
  • WebAssembly sandboxed UDFs — Execute untrusted functions in a WASM sandbox via Wasmtime
Recent Releases
Release March 2026

v2.8.0 — Batch-First SQL Row Transport

The SQL execution engine now uses a batch-first row transport foundation. This is a significant internal architecture change that enables more efficient query processing:

  • Batch-capable result boundaries across scans, joins, and aggregates
  • Foundation for future vectorized query execution
  • Reduced per-row overhead for large result sets
Release March 2026

Full-Text Search

CSharpDB now includes built-in full-text search capabilities:

  • Inverted index with tokenization and stemming
  • Relevance ranking via MATCH() in SQL
  • CREATE FULLTEXT INDEX syntax for easy setup
Release February 2026

Foreign Key Constraints

v1 foreign key support has landed with column-level REFERENCES and optional ON DELETE CASCADE:

  • Single-column, column-level REFERENCES syntax
  • ON DELETE CASCADE for automatic child row cleanup
  • Metadata and tooling surfaces across direct, HTTP, gRPC, CLI, and Admin
  • Retrofit migration for older databases
Release January 2026

Subqueries, Set Operations & Visual Query Designer

Major SQL feature additions and tooling improvements:

  • Scalar subqueries, IN/EXISTS (including correlated) subqueries
  • UNION, INTERSECT, EXCEPT set operations
  • Visual query builder in Admin UI with drag-and-drop source canvas, join editing, and SQL preview
  • Collation support (BINARY, NOCASE, NOCASE_AI, ICU:<locale>)
Release Q4 2025

Ecosystem Expansion

Major tooling and ecosystem additions that shipped in late 2025:

  • Dedicated gRPC daemon — Full gRPC coverage for SQL, schema, procedures, collections, and maintenance
  • Hybrid storage mode — Hot tables in memory with durable checkpoint to disk
  • Client backup & restore — First-class operations across all access methods
  • Background WAL checkpointing — Incremental auto-checkpointing off the commit path
  • MCP server — AI assistant integration for database operations
  • NativeAOT C library — Cross-language FFI for JavaScript, Python, and more