Establish SQLite connection and lifecycle #16

New issue

Closed

opened 2026-09-04 23:26:44 +02:00 by arne · 0 comments

arne commented

2026-09-04 23:26:44 +02:00

Owner

Add the application database boundary using the selected CGO-free SQLite driver and tie its lifecycle to application startup and shutdown.

Acceptance criteria:

The application opens SQLite through a small database package using a configured database path.
Startup verifies connectivity and fails with a contextual error when the database cannot be opened or reached.
Connection-pool limits are explicitly appropriate for SQLite and documented in code or package documentation.
Shutdown closes the database after HTTP serving stops, with close failures handled visibly.
The database participates in /readyz readiness.
Unit or focused tests cover open failure, successful connectivity, and close/lifecycle behavior.
make check passes.

Dependencies:

Depends on configuration issue #2.
Integrates with readiness issue #13.

Add the application database boundary using the selected CGO-free SQLite driver and tie its lifecycle to application startup and shutdown. Acceptance criteria: - The application opens SQLite through a small database package using a configured database path. - Startup verifies connectivity and fails with a contextual error when the database cannot be opened or reached. - Connection-pool limits are explicitly appropriate for SQLite and documented in code or package documentation. - Shutdown closes the database after HTTP serving stops, with close failures handled visibly. - The database participates in `/readyz` readiness. - Unit or focused tests cover open failure, successful connectivity, and close/lifecycle behavior. - `make check` passes. Dependencies: - Depends on configuration issue #2. - Integrates with readiness issue #13.

arne added this to the Milestone 1: runtime foundation milestone

2026-09-04 23:26:44 +02:00

arne referenced this issue

2026-09-04 23:26:52 +02:00

Configure SQLite foreign keys, WAL mode, and busy timeout #17

arne referenced this issue

2026-09-04 23:27:01 +02:00

Add embedded SQLite migrations and migration tests #18

arne referenced this issue from a pull request that will close it,

2026-09-05 08:14:26 +02:00

Establish SQLite connection lifecycle #24

arne referenced this issue from a commit