Shiny.DocumentDb v3 — One API, Four Databases
What started as a simple SQLite document store now runs on four database engines. Shiny.DocumentDb v3 introduces a provider abstraction that lets you swap between SQLite, MySQL, SQL Server, and PostgreSQL while keeping your entire data layer — queries, projections, indexes, transactions — completely identical.
What you’ll learn
- How the
IDatabaseProviderinterface enables backend-agnostic document storage - How the fluent query builder translates LINQ expressions into the correct SQL dialect per provider (
json_extract,JSON_VALUE,jsonboperators, etc.) - Per-provider DI extension methods for quick registration
- Why multiple database support matters: server-side caches, team standardization, prototyping-to-production transitions
- Migration steps from
Shiny.SqliteDocumentDbv2 to the new package structure - Everything that carries forward: streaming, JSON indexes, table-per-type, diffing, batch insert, AOT support