Roadmap

Deduplicate SELECT output with DISTINCT. Multi-column indexes for broader query coverage.

Use indexes for <, >, <=, >=, BETWEEN — not just equality lookups.

Cache parsed ASTs and query plans to avoid re-parsing identical SQL statements.

Open a database fully in memory, load from disk, and save committed snapshots back to disk.

Nested scalar, array-element, nested array-object, Guid, temporal, and ordered text path indexes.

Merge underflowed pages on delete to reclaim space via borrow/merge with interior collapse.

Maintenance report, REINDEX, VACUUM/compact, fragmentation analysis, and database size report.

CSharpDB.Daemon host with full gRPC coverage for SQL, schema, procedures, collections, and maintenance.

Incremental/sliced auto-checkpointing to move work off the triggering commit path.

Lazy-resident durable storage with on-demand page loading and gRPC tunable file-cache.

ANALYZE command with persisted row counts, column NDV/min/max, and initial stats-guided index selection.

BackupAsync / RestoreAsync as first-class operations across direct, HTTP, gRPC, CLI, and Admin.

Validate/apply maintenance workflow that rewrites existing child tables with persisted FK metadata across direct, HTTP, gRPC, CLI, and Admin.

Visual banded-report designer with grouping, sorting, expressions, aggregate functions, page settings, and printable preview.

Broader built-in scalar function registry, user-registered C# functions, and native plugin extensions.

ROW_NUMBER(), RANK(), DENSE_RANK(), LEAD(), LAG() for analytical queries.

Default expressions in column definitions and arbitrary expression-based constraints per column or table.

v1 support for single-column, column-level REFERENCES with optional ON DELETE CASCADE, plus metadata/tooling surfaces.

Fold REST/HTTP into CSharpDB.Daemon so one server host serves REST, gRPC, and future transports from a shared warm Database instance.

Built-in authentication, authorization, API keys, protected admin endpoints, and TLS/mTLS deployment support.

Package CSharpDB.Daemon as a persistent background service across systemd, Windows Service, and launchd.

dotnet tool, self-contained binaries, Docker, Homebrew, winget, and install scripts.

DbConnection.GetSchema() now exposes standard metadata collections for tooling and ORM schema discovery.

BINARY, NOCASE, NOCASE_AI, and ICU:<locale> collation now work across SQL and collection indexes; dedicated ordered SQL text index optimization remains future work.

Scalar subqueries, IN/EXISTS (including correlated), UNION, INTERSECT, EXCEPT across SELECT results.

Admin query builder with source canvas, join editing, design grid, SQL preview, and saved layouts.

Inverted index support with tokenization, stemming, and relevance ranking.

No-reflection, trim-safe typed collection API backed by generated codecs and index bindings.

Internal row-batch transport serves as the batch-first SQL execution foundation across batch-capable result boundaries, scans, joins, and generic aggregates.

Compress cell content within pages to reduce I/O and storage footprint.

Encrypt database and WAL files with passphrase-based key management and explicit migration paths.

Statistics-driven join ordering and index selection with advanced histograms and adaptive re-optimization.

Group multiple page writes into fewer system calls. Buffer committed WAL writes across transactions.

Allow concurrent write transactions with conflict detection and retry.

Stream committed changes for read replicas or event-driven architectures.

Execute untrusted user-submitted functions in a WASM sandbox with resource limits via Wasmtime.