Add Concurrency page; cross-link from setup, config, internals, and FAQ
New Reference page documenting the write-serialization model (SQLite's single-writer
lock plus Microsoft.Data.Sqlite's CommandTimeout-bounded retry) and the best practices:
no app lock, short transactions, CommandTimeout for in-memory, busy_timeout for file.
Adds a sidebar entry and pointers from Getting-Started, DI-and-Configuration,
Storage-Architecture, and the FAQ.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Document in-memory setup; correct normalization and concurrency for the lock removal
- Add an in-memory setup section: connection string (Mode=Memory, named, Cache=Shared)
plus the busy_timeout pragma, with a note that the pragma is inert for in-memory
(shared-cache conflicts bypass the busy handler; Microsoft.Data.Sqlite's command-timeout
retry serializes writers) and is the contention knob for file-backed stores.
- Correct connection-string normalization: ForeignKeys is defaulted when unset; Mode and
Pooling are preserved, so Mode=Memory is honored rather than rewritten to a file.
- Storage-Architecture: the in-memory store holds no application-level lock.
- Recipe: mirror the current normalization in the per-test ClearPool builder.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Wiki refresh: new pages, accuracy fixes, sentence-case headings
- Add Tutorial, FAQ, DI-and-Configuration, and four Recipe pages
- Refresh Home, Getting-Started, and reference pages
- Fix API-parity, options arity, WAL behavior, and builder-surface
accuracy across DI, Getting-Started, Storage-Architecture, FAQ,
Recipe-Xunit-Per-Test-Isolation, Recipe-Aspnet-Integration-Test-Fixture,
API-Parity, and Tutorial
- Normalize headings to sentence case across reference pages
- Add .gitignore to exclude .findings/ review scratch
Co-Authored-By: Claude Opus 4.7 (1M context) <noreply@anthropic.com>
Add complete wiki documentation (12 pages)
Full API documentation for library consumers covering table operations,
item CRUD, query/scan, batch operations, transactions, secondary indexes,
TTL, tags/admin, export/import, storage architecture, and API parity matrix.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>