Healthie.NET.Relational
4.1.2
Prefix Reserved
dotnet add package Healthie.NET.Relational --version 4.1.2
NuGet\Install-Package Healthie.NET.Relational -Version 4.1.2
<PackageReference Include="Healthie.NET.Relational" Version="4.1.2" />
<PackageVersion Include="Healthie.NET.Relational" Version="4.1.2" />
<PackageReference Include="Healthie.NET.Relational" />
paket add Healthie.NET.Relational --version 4.1.2
#r "nuget: Healthie.NET.Relational, 4.1.2"
#:package Healthie.NET.Relational@4.1.2
#addin nuget:?package=Healthie.NET.Relational&version=4.1.2
#tool nuget:?package=Healthie.NET.Relational&version=4.1.2

Healthie.NET.Relational
▶ Live demo — board.healthie-dotnet.dev — a read-only Healthie.NET dashboard watching real status pages (Anthropic, OpenAI, GitHub, Cloudflare, and more), built from these packages. Full documentation at healthie-dotnet.dev.
Relational IStateProvider implementation for Healthie.NET. Persists pulse checker state to any database with an ADO.NET driver — bring your own, or install one of the ready-made wrappers.
Installation
dotnet add package Healthie.NET.Relational
Most people want one of these instead, which supply the driver and the dialect for you:
| Package | Engine |
|---|---|
| Healthie.NET.Postgres | PostgreSQL, including Databricks Lakebase |
| Healthie.NET.SqlServer | SQL Server, Azure SQL |
| Healthie.NET.Sqlite | SQLite |
Usage
Reach for this package directly when your database is not one of the three above. Supply a connection factory and a dialect:
using Healthie.StateProviding.Relational;
using MySqlConnector;
builder.Services
.AddHealthie(typeof(Program).Assembly)
.AddHealthieRelational(
() => new MySqlConnection(connectionString),
new RelationalDialect(
"MySQL",
"CREATE TABLE IF NOT EXISTS {0} (" +
"name VARCHAR(191) NOT NULL PRIMARY KEY, state_type TEXT NULL, value LONGTEXT NOT NULL)",
"INSERT INTO {0} (name, state_type, value) VALUES (@name, @state_type, @value) " +
"ON DUPLICATE KEY UPDATE state_type = VALUES(state_type), value = VALUES(value)"));
A dialect needs two statements: one that creates the table only if it is missing, because it runs on every start; and one that inserts or replaces a single row. Reading is identical on every engine, so it is not part of the dialect.
State is stored as JSON in one table keyed by checker name, so the schema does not change when the state model does.
Table name
Defaults to healthie_pulse_state, and may be schema-qualified. It is validated as a plain identifier before it reaches the SQL, because no database allows an identifier to be parameterised — anything else is refused rather than interpolated.
| Product | Versions Compatible and additional computed target framework versions. |
|---|---|
| .NET | net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. net9.0 was computed. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.0-windows was computed. 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
- Healthie.NET.Abstractions (>= 4.1.2)
-
net8.0
- Healthie.NET.Abstractions (>= 4.1.2)
NuGet packages (3)
Showing the top 3 NuGet packages that depend on Healthie.NET.Relational:
| Package | Downloads |
|---|---|
|
Healthie.NET.Sqlite
SQLite state provider for Healthie.NET -- durable pulse checker state with no server to stand up. |
|
|
Healthie.NET.SqlServer
SQL Server state provider for Healthie.NET -- persists pulse checker state to SQL Server or Azure SQL. |
|
|
Healthie.NET.Postgres
PostgreSQL state provider for Healthie.NET -- persists pulse checker state to PostgreSQL, including Databricks Lakebase and any other PostgreSQL-compatible service. |
GitHub repositories
This package is not used by any popular GitHub repositories.
### Fixed
- The dashboard event-log and about dialogs now move focus inside, keep keyboard focus contained,
close with Escape, and restore focus to the control that opened them.
- Dashboard checker rows now expose selection as a real button alongside their action buttons,
removing nested interactive controls while preserving whole-row pointer selection.
- A dashboard state-provider failure now shows a recoverable unavailable state with a retry action
instead of looking like an empty installation with no registered checkers.
- The Blazor sample now keeps the dashboard stylesheet in its static host head, preventing an
unstyled flash while the interactive head reconnects on a slow network.
- HTTP checker display names and result messages now omit URI user information, query strings, and
fragments, server-controlled reason phrases, and transport exception details, preventing embedded
credentials and tokens from reaching stored history, alerts, logs, or the dashboard while requests
still use the complete configured URI.
- Alert-history persistence now loads durable history before its first post-restart write and
coalesces changes raised during a slow state-provider write into one latest-state follow-up. This
preserves earlier alerts without duplicating the new one and avoids an unbounded queue of tasks
and redundant full-history writes during alert bursts.
- The Web API sample maps its unauthenticated management API and mutation-enabled MCP endpoint only
in Development, so deploying the sample with a production environment no longer exposes those
local demonstration surfaces. Liveness and readiness probes remain available.
- History clearing and startup trimming now use optimistic concurrency, so they no longer overwrite
a check result or setting changed by another replica between the read and write.
- Leader election now serializes schedule changes with leadership transitions and reconciles every
registered checker's persisted active state and schedule through a bulk read on lease renewal. A
pause or cadence change made through another replica now reaches the leader, a fresh leader
removes inactive durable jobs left by the previous process, and reconciliation runs with bounded
concurrency while an independent lease heartbeat prevents slow scheduler calls from expiring an
otherwise healthy leader. Partial and cancelled transitions remain tracked until cleanup succeeds,
and shutdown does not release the lease over work it could not stop.
- CosmosDB multi-state reads now use `ReadManyItemsAsync`, avoiding one sequential network round
trip per checker during dashboard loads and leader renewal.
- The in-memory lease provider now returns exactly one winner when replicas contend concurrently.
- Coravel, Hangfire, Temporal, and the leader-election decorator now validate schedules before they
are persisted. Cronos expressions requiring an absent jitter seed are reported as validation
failures instead of escaping as server errors. The built-in timer also rejects periods outside
`PeriodicTimer`'s supported range before replacing a working schedule.
- Temporal now preserves Healthie.NET's six-field, leading-seconds cron meaning by translating it
to Temporal's seven-field seconds form. It rejects Cronos-only relative-day and descending-range
expressions whose Temporal meaning differs, and fixed periods outside Temporal's supported range,
before an existing schedule is removed.
- Uptime recording now starts a new observation segment on the first fresh result after a process
restart, even when its health matches persisted state. Time while no process was observing the
checker remains unknown, and a transition that finds the bounded queue full is retried by the next
fresh result.
Full changelog: https://github.com/ivanvyd/Healthie.NET/blob/v4.1.2/CHANGELOG.md