Arcana::DB
Connection management for the Postgres-backed identity / org store.
Configured via ARCANA_DATABASE_URL. Postgres is opt-in — when
the env var is unset, Arcana::DB.connection returns nil and
callers must handle that. This keeps current single-tenant
localhost users working without a database.
Connection format: postgres://user:pass@host:port/dbname
The underlying pool is provided by crystal-db (crystal-pg is the
Postgres driver shard). Default pool settings are fine for now;
tunables can be added later via env vars if needed.
Class methods
Open the connection pool. Idempotent — repeated calls return the
same DB::Database. Returns nil if ARCANA_DATABASE_URL is unset.
Force the connection. Raises if ARCANA_DATABASE_URL is unset —
use this in code paths that require Postgres (admin CLI, auth
middleware), as opposed to opportunistic uses.