Persistence Providers

Persistence:Provider selects SQLite (default) or PostgreSQL; writes and reads use separate EF Core contexts

Persistence Providers Persistence:Provider selects SQLite (default) or PostgreSQL; writes and reads use separate EF Core contexts Production: Postgres Local dev: Sqlite (default) Configuration · Persistence:Provider · Architecture component · Sqlite | Postgres Configuration Persistence:Provider Sqlite | Postgres Fleans silos · Api / Web / Mcp · Architecture component Fleans silos Api / Web / Mcp Command context · FleanCommandDbContext · Architecture component · events + projection Command context FleanCommandDbContext events + projection Query context · FleanQueryDbContext · Architecture component · NoTracking Query context FleanQueryDbContext NoTracking PostgreSQL primary · ConnectionStrings:fleans · Production: Postgres · MigrateAsync PostgreSQL primary ConnectionStrings:fleans MigrateAsync PostgreSQL replica · ConnectionStrings:fleans-query · Production: Postgres · optional PostgreSQL replica ConnectionStrings:fleans-query optional SQLite file · fleans-dev.db · Local dev: Sqlite (default) · EnsureCreated SQLite file fleans-dev.db EnsureCreated selects provider writes reads if set Sqlite Sqlite Legend Backend Database External

Architecture diagram • Built with Archify • Create yours ↗ • Hover to trace • R route • Click to focus • +/− zoom • M radar • T theme • E export