Documentation

Core Concepts

DbType, DbValue, TableSchema, IndexSchema — the foundational types that power the database.

SQL Reference

DDL, DML, JOINs, aggregates, CTEs, subqueries, views, triggers, stored procedures, and built-in functions.

Collection API

Typed Collection<T> with JSON serialization, nested path indexing, array-element queries, and range scans.

Full-Text Search

Built-in FTS with Unicode tokenization, term-intersection queries, and automatic index maintenance.

ETL Pipelines

Built-in pipeline runtime with CSV/JSON connectors, transforms, validation, dry-run, and run history.

Database Modes

File-based, in-memory, and hybrid (lazy-resident) — how each mode works and when to use it.

Storage Engine

B+tree operations, paging, transactions, WAL, checkpointing, serialization, and diagnostics.

Architecture Deep Dive

Pager, WAL, B+tree, SchemaCatalog — how the storage engine components collaborate.

Samples & Tutorials

End-to-end examples: in-memory cache in ASP.NET, storage tutorials, graph databases, and more.

Tools & Ecosystem

CLI REPL, Admin UI, REST API, gRPC daemon, Client SDK, ADO.NET provider, MCP server, and VS Code extension.

Admin UI Guide

CSharpDB Studio — browse data, write SQL, manage schemas, design pipelines, and inspect storage.

Reports

Visual report designer with banded layouts, grouping, sorting, expressions, aggregates, and printable preview.

Tutorials

Hands-on walkthroughs — storage engine internals, B+trees, WAL, indexing, serialization, and file storage.

CLI Reference

Interactive REPL, meta-commands, SQL introspection, transaction management, and storage inspector commands.

REST API

HTTP endpoints for tables, rows, indexes, views, triggers, SQL execution, and stored procedures.

MCP Server

Connect AI assistants — Claude, Cursor, VS Code, LM Studio — to CSharpDB via Model Context Protocol.

Internals & Contributing

Project structure, query flow walkthrough, adding SQL statements, testing strategy, and concurrency model.

FAQ

Common questions about setup, SQL, schema, the CLI, Admin UI, and development workflow.

Storage Inspector

Read-only diagnostics — database file, WAL, page, and index integrity checks with JSON output.

Collection Indexing

Document indexes — scalar, nested object, array-element paths with equality and range queries.

Storage Engine Reference

Low-level API walkthrough — IStorageDevice, Pager, B+tree, WAL, SlottedPage, indexing, and schema catalog.

Collation Support

Case-insensitive and locale-aware sorting plan — NOCASE, ICU, COLLATE clause for queries and indexes.

Migrations

CSharpDB.Core to CSharpDB.Primitives — namespace, project reference, and package migration guide.