NewHeap.Platform.AspNet.Proxy.Sqlite
1.1.0
dotnet add package NewHeap.Platform.AspNet.Proxy.Sqlite --version 1.1.0
NuGet\Install-Package NewHeap.Platform.AspNet.Proxy.Sqlite -Version 1.1.0
<PackageReference Include="NewHeap.Platform.AspNet.Proxy.Sqlite" Version="1.1.0" />
<PackageVersion Include="NewHeap.Platform.AspNet.Proxy.Sqlite" Version="1.1.0" />
<PackageReference Include="NewHeap.Platform.AspNet.Proxy.Sqlite" />
paket add NewHeap.Platform.AspNet.Proxy.Sqlite --version 1.1.0
#r "nuget: NewHeap.Platform.AspNet.Proxy.Sqlite, 1.1.0"
#:package NewHeap.Platform.AspNet.Proxy.Sqlite@1.1.0
#addin nuget:?package=NewHeap.Platform.AspNet.Proxy.Sqlite&version=1.1.0
#tool nuget:?package=NewHeap.Platform.AspNet.Proxy.Sqlite&version=1.1.0
NewHeap ASP.NET Proxy SQLite
Store redirects, rewrites, login activity and API change audits in a local SQLite database. No separate database server is required.
Install the proxy · Configuration · Usage reference
Storage configuration
AddNewHeapProxy creates the database and loads saved rules at startup.
Configure Sqlite:DatabasePath and Sqlite:BusyTimeout under NewHeapProxy;
see the configuration table for defaults. Restart after changing settings.
| Requirement | What to do |
|---|---|
| Location | Use writable, persistent local storage outside the webroot. Network and in-memory databases are unsupported. |
| Relative paths | Paths are relative to the application's content root. |
| Containers | Mount persistent local storage for the database directory. |
| Ownership | Run one proxy instance per database file. Stop it before opening an offline store. |
| Live changes | Use the administration panel or configuration service. Direct database edits and multiple writers are unsupported. |
Backups and upgrades
- Back up after a clean shutdown, or use SQLite's backup API while running.
- Do not copy only the main database while the proxy is running; recent changes may be in the write-ahead log.
- Back up before upgrading. Database upgrades preserve rules and login activity, but older proxy versions may not reopen the upgraded file.
Startup problems
Schema 4 adds the append-only NhProxyChangeAudit table. API saves insert the
authenticated actor, UTC time, engine, revisions and normalized before/after
configuration in the same transaction as the snapshot update. An audit insert
failure rolls back the save. Activation retry records intent before execution.
Read the audit through the authenticated GET /newheap-proxy/api/audit endpoint;
records are retained without automatic expiration and survive restarts. Existing
configuration and login-audit data are preserved during the upgrade. Older binaries
cannot reopen schema 4; restoring a pre-upgrade backup is required for a downgrade.
| Problem | Action |
|---|---|
| Database cannot be opened | Check the directory, file permissions and available storage. |
| Another instance owns the database | Stop that instance or use a separate database file. |
A .lock file remains after shutdown |
Its presence alone does not mean the database is in use. Never delete it to bypass a running instance. |
| Invalid or incompatible database | Check application diagnostics and restore a compatible backup if needed. Startup fails instead of resetting stored rules. |
Seed rules offline
See Seed a redirect before starting the host for an example that retains existing rules and checks save failures.
| 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
- Microsoft.Data.Sqlite (>= 10.0.11)
- NewHeap.Platform.AspNet.Proxy (>= 1.1.0)
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.