sqliteconn

Overview ¶

Package sqliteconn opens SQLite connections that run a fixed set of statements, usually pragmas, on every connection the pool opens. It has no Shisho imports, so both pkg/database and pkg/testutils/testdb can use it.

Pragmas such as foreign_keys and busy_timeout apply only to the connection that ran them. database/sql discards a connection whose query is canceled mid-statement and opens a replacement with SQLite's defaults, so running them once at startup is not enough.