Cardano Updates

  Delete `Hydra.Events.FileBased`, `Hydra.Persistence`, and
  `Hydra.PersistenceLog` which are no longer needed now that
  `Hydra.Events.SQLiteBased` is the sole persistence backend.

  Migration logic in `migrateFromFileBased` now reads the legacy
  newline-delimited JSON file directly, removing the dependency on
  `PersistenceIncremental`. The `Persistence` log constructor is removed
  from `HydraLog` along with it. Drop `resourcet` and `unliftio` from
  the library build-depends as they were only pulled in by the deleted
  modules.

mkSQLiteEventStore called sqlite3_open without first creating the
persistence directory. Fixed by adding createDirectoryIfMissing before
open, matching the behaviour of the old createPersistenceIncremental.

  Add `static-sqlite` to the static-libs overlay (built with
  `--disable-shared`) and point the `direct-sqlite` pkgconfig at it.
  This embeds libsqlite3 directly into the binary for both native and
  musl64 builds, so Docker images do not need libsqlite3.so at runtime —
  fixing the container crash-loop seen in the network-test CI workflow.

Signed-off-by: Sasha Bogicevic <[email protected]>

  Events are now persisted in a SQLite database (hydra.db) instead of a
  plain append-only JSON file (state). On first startup after upgrade,
  existing state files are automatically migrated into the database and
  renamed to state.migrated.

  Key changes:
  - Add Hydra.Events.SQLiteBased with mkSQLiteEventStore and
    migrateFromFileBased
  - WAL mode, synchronous=NORMAL, 64MB page cache for fast reads/writes
  - rotate uses a single transaction (atomic delete + checkpoint insert)
  - Migration batches all inserts in one transaction
  - Update Run.hs to wire up the SQLite store
  - Update docs to reflect SQLite backend and hydra.db filename
  - Add Hydra.Events.SQLiteBasedSpec mirroring FileBasedSpec

Signed-off-by: Sasha Bogicevic <[email protected]>

Signed-off-by: Sasha Bogicevic <[email protected]>

  Remove redundant fields from three StateChanged constructors:

  - SnapshotRequested: drop requestedTxIds (derivable from map txId snapshot.confirmed)
  - SnapshotConfirmed: change snapshot to Maybe (Nothing on normal AckSn path where the snapshot is already tracked in seenSnapshot; Just only on side-load path)
  - DecommitRecorded: drop utxoToDecommit (derivable from utxoFromTx decommitTx)
  - PartySignedSnapshot: replace snapshot :: Snapshot tx with snapshotNumber :: SnapshotNumber

  The API server reconstructs SnapshotConfirmed outputs by threading the seenSnapshot through a stateful mapAccum conduit for history replay and reading nodeStateP before updating for live events.

Signed-off-by: Sasha Bogicevic <[email protected]>

Signed-off-by: Sasha Bogicevic <[email protected]>

This reverts commit 276dcfa616388184538e37b4ab0e3cfe764799a3.

Bumps [follow-redirects](https://github.com/follow-redirects/follow-redirects) from 1.15.9 to 1.16.0.
- [Release notes](https://github.com/follow-redirects/follow-redirects/releases)
- [Commits](https://github.com/follow-redirects/follow-redirects/compare/v1.15.9...v1.16.0)

---
updated-dependencies:
- dependency-name: follow-redirects
  dependency-version: 1.16.0
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <[email protected]>

Bumps [lodash-es](https://github.com/lodash/lodash) from 4.17.21 to 4.18.1.
- [Release notes](https://github.com/lodash/lodash/releases)
- [Commits](https://github.com/lodash/lodash/compare/4.17.21...4.18.1)

---
updated-dependencies:
- dependency-name: lodash-es
  dependency-version: 4.18.1
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <[email protected]>

Bumps [handlebars](https://github.com/handlebars-lang/handlebars.js) from 4.7.8 to 4.7.9.
- [Release notes](https://github.com/handlebars-lang/handlebars.js/releases)
- [Changelog](https://github.com/handlebars-lang/handlebars.js/blob/v4.7.9/release-notes.md)
- [Commits](https://github.com/handlebars-lang/handlebars.js/compare/v4.7.8...v4.7.9)

---
updated-dependencies:
- dependency-name: handlebars
  dependency-version: 4.7.9
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <[email protected]>

Bumps [follow-redirects](https://github.com/follow-redirects/follow-redirects) from 1.15.9 to 1.16.0.
- [Release notes](https://github.com/follow-redirects/follow-redirects/releases)
- [Commits](https://github.com/follow-redirects/follow-redirects/compare/v1.15.9...v1.16.0)

---
updated-dependencies:
- dependency-name: follow-redirects
  dependency-version: 1.16.0
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <[email protected]>

Bumps [picomatch](https://github.com/micromatch/picomatch) from 2.3.1 to 2.3.2.
- [Release notes](https://github.com/micromatch/picomatch/releases)
- [Changelog](https://github.com/micromatch/picomatch/blob/master/CHANGELOG.md)
- [Commits](https://github.com/micromatch/picomatch/compare/2.3.1...2.3.2)

---
updated-dependencies:
- dependency-name: picomatch
  dependency-version: 2.3.2
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <[email protected]>

Co-Authored-By: Claude Opus 4.6 (1M context) <[email protected]>
Signed-off-by: Yurii Shynbuiev <[email protected]>

Co-Authored-By: Claude Opus 4.6 (1M context) <[email protected]>
Signed-off-by: Yurii Shynbuiev <[email protected]>