SyntaxCircus.Cmsify.Infrastructure.Sqlite
0.8.9
See the version list below for details.
dotnet add package SyntaxCircus.Cmsify.Infrastructure.Sqlite --version 0.8.9
NuGet\Install-Package SyntaxCircus.Cmsify.Infrastructure.Sqlite -Version 0.8.9
<PackageReference Include="SyntaxCircus.Cmsify.Infrastructure.Sqlite" Version="0.8.9" />
<PackageVersion Include="SyntaxCircus.Cmsify.Infrastructure.Sqlite" Version="0.8.9" />
<PackageReference Include="SyntaxCircus.Cmsify.Infrastructure.Sqlite" />
paket add SyntaxCircus.Cmsify.Infrastructure.Sqlite --version 0.8.9
#r "nuget: SyntaxCircus.Cmsify.Infrastructure.Sqlite, 0.8.9"
#:package SyntaxCircus.Cmsify.Infrastructure.Sqlite@0.8.9
#addin nuget:?package=SyntaxCircus.Cmsify.Infrastructure.Sqlite&version=0.8.9
#tool nuget:?package=SyntaxCircus.Cmsify.Infrastructure.Sqlite&version=0.8.9
Cmsify SQLite infrastructure
Optional SQLite registration for embedded .NET 10 hosts, licensed under AGPL-3.0-or-later.
See the embedded SQLite guide for an executable host example, explicit initialization, deployment constraints, backup rollback and abandoned-lock recovery. This package is released in lockstep with Core and Infrastructure. Local candidate checks do not establish publication or full SQLite qualification; generic JSON queries, complete workers, production backup/blob recovery and supported-version upgrades remain separate gates.
Local candidate 0.8.9-query.1 adds provider-specific ordinary/resolved content
queries through the registered Cmsify.Core.ContentQueries.IListContentRequestHandler.
It qualifies actual snapshot all-tag membership, measured native LIKE semantics,
fixed host clock/AsOf, paging and denial in a package-only host. Released 0.8.8 lacks
this public contract; generic JSON LINQ translation remains a separate open gap.
Reference SyntaxCircus.Cmsify.Infrastructure.Sqlite and import
Cmsify.Infrastructure.Sqlite.Extensions. Register with
services.AddCmsifySqliteInfrastructure(configuration) or pass the common
CmsifyInfrastructureOptions to select workers and host audit identity.
The default remains all six workers and HTTP actor audit, matching PostgreSQL.
Set ConnectionStrings:Cmsify to Data Source=/local/persistent/cmsify.db.
Only local persistent file data sources are supported. Memory and URI data sources
are rejected. Foreign keys are enabled; explicit Foreign Keys=False is rejected.
The default timeout is 30 seconds; an explicit caller timeout is preserved.
Registration and context resolution do not create a database, run migrations,
seed data or change journal mode. Identical registration is a no-op; provider,
configuration or common-option conflicts fail before changing registrations.
SQLite migration is schema-only and will not provision a workspace or administrator.
Explicit initialization with the existing IDbSeeder is a separate operator step.
Run host.MigrateCmsifyDatabaseAsync() as a controlled deployment step before
workers or traffic. The package owns __CmsifyMigrationsHistory; its columns are
migration_id and product_version under the provider-neutral snake-case convention.
SQLite retains its native EF migration history service and locking. PostgreSQL's
history naming and service remain unchanged.
Migration rejects unmanaged CMS tables, malformed or unknown/gapped CMS history, and tables missing from the last applied migration's model. Host tables and host migration histories are retained. These ownership and table-presence checks are not an exhaustive schema integrity audit. Schema/history are read in one transaction; the transaction ends before EF acquires its migration lock and re-reads history. Concurrent migrators must run identical application versions. Controlled deployment must prohibit simultaneous different-version migrators and external schema edits.
Design-time commands must select this project as both project and startup project:
dotnet ef migrations list --project src/Cmsify.Infrastructure.Sqlite --startup-project src/Cmsify.Infrastructure.Sqlite --context CmsifyDbContext.
The factory defaults to the development-only cmsify.design-time.db file. Pass an
explicit connection string after -- to select a different local development file.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net10.0 is compatible. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.0-windows was computed. |
-
net10.0
- AWSSDK.S3 (>= 4.0.102.2)
- BCrypt.Net-Next (>= 4.2.0)
- EFCore.NamingConventions (>= 10.0.1)
- FluentValidation (>= 12.1.1)
- Microsoft.AspNetCore.Http.Abstractions (>= 2.3.13)
- Microsoft.EntityFrameworkCore (>= 10.0.11)
- Microsoft.EntityFrameworkCore.Relational (>= 10.0.11)
- Microsoft.EntityFrameworkCore.Sqlite (>= 10.0.11)
- Microsoft.Extensions.Caching.Abstractions (>= 10.0.12)
- Microsoft.Extensions.Caching.Memory (>= 10.0.11)
- Microsoft.Extensions.DependencyInjection.Abstractions (>= 10.0.12)
- Microsoft.Extensions.Hosting.Abstractions (>= 10.0.12)
- Microsoft.Extensions.Http (>= 10.0.12)
- Microsoft.Extensions.Options (>= 10.0.12)
- Npgsql.EntityFrameworkCore.PostgreSQL (>= 10.0.3)
- SyntaxCircus.Cmsify.Infrastructure (>= 0.8.9)
- SyntaxCircus.Common (>= 0.1.3)
- SyntaxCircus.EntityFrameworkCore.Postgres (>= 0.1.3)
- SyntaxCircus.Storage (>= 0.2.1)
- UUIDNext (>= 4.2.4)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.