Solitons.SQLite 2.0.0-alpha.81

Solitons.SQLite

Leaf-provider package in the Solitons family — SQLite implementations of Solitons.Core abstractions, with a focus on local-swap scenarios for cloud services and lightweight, file-shippable telemetry.

Install:

dotnet add package Solitons.SQLite

This pulls Solitons.Core and Microsoft.Data.Sqlite transitively.

What is in the box

Solitons.SQLite.SqliteSecretsRepository

Local secrets store backed by a SQLite file. Factory methods for file- or connection-string-based construction. Scope-based segregation. Implements Solitons.Security.ISecretsRepository, so production code can target the abstraction and switch to a cloud-backed repository (Solitons.Azure.AzureKeyVaultSecretsRepository and similar) without changes.

Solitons.SQLite.Diagnostics.SqliteAsyncLogger

A Solitons.Diagnostics.IAsyncLogger implementation that writes to a SQLite database file. Batches records via BufferedAsyncLogger; one transaction per batch. Designed for the "microservice writes locally, a sidecar ships the file later" pattern — the DB file is portable, queryable from any SQLite client, and pairs with SqliteLogStore for reads and maintenance.

Solitons.SQLite.Diagnostics.SqliteLogStore

The read / maintenance / rollup side of the logger:

• Kafka-like offset reads. ReadBatch(afterOffset, limit) returns entries with monotonically increasing, never-reused offsets. A shipper records the last processed offset via SetBookmark and resumes with GetBookmark after restart.
• Retention. DeleteOlderThan, DeleteUntilOffset, KeepOnlyLast.
• Rollups. RollupByCallSite and RollupByLevel — or query the v_call_site_rollup / v_level_rollup views directly from any SQLite client.
• Maintenance. Checkpoint (flush WAL) and Vacuum (reclaim file space).

See Diagnostics/README.md for the full logger documentation, including the end-to-end ADLS Gen 2 + Databricks shipping recipe.

Solitons.SQLite.Migrations.SqliteMigrationManager

A sealed migration runner that takes a provider implementing ISqliteMigrationProvider and applies its scripts in order, recording state in a per-provider table named after the provider's [Guid] identity (migration_scripts_<guid_N>). Single required method on the provider: GetScripts(). Factory primitives Create(filePath) and Create(filePath, provider) give you a uniform construction surface across the SQLite leaves — no inheritance ladders to follow.

The day-one consumers in this package (SqliteAsyncLogger, SqliteLogStore, SqliteSecretsRepository) all dogfood the migration framework. The charter is at src/Solitons.SQLite/Migrations/CHARTER.md.

Provider-side identity is enforced at compile time by Roslyn analyzers SOL200 / SOL201 / SOL202 (bundled into Solitons.Core).

Distribution

Solitons.SQLite is a leaf provider: one canonical technology dependency (Microsoft.Data.Sqlite), one Core dependency, no inter-leaf coupling. Adjuncts compose through standard NuGet dependencies — installing Solitons.SQLite alongside Solitons.Azure (the meta-provider that aggregates SQLite for Azure-hosted apps) delivers exactly one copy of each DLL.

Status

• Targets net10.0.
• 2.0 alpha track; package version stamped per CI run from Directory.Build.props.
• Single-author project.

See also

• Solitons.Core — the abstractions this package implements.
• Solitons.Azure — the meta-provider that aggregates Solitons.SQLite for Azure-hosted apps.
• Repository: https://github.com/vvka-141/Solitons

License

MPL-2.0.