KarpelesLab / psql / 22800996947

push

github

Add SQLite support using modernc.org/sqlite (pure Go)

- New EngineSQLite engine with NewSQLite() constructor
- Auto-detect SQLite DSNs (:memory:, .db, .sqlite, file:, sqlite:)
- SQLite table creation and schema checking via PRAGMA
- Type affinity mapping for SQLite's simplified type system
- INSERT OR IGNORE / INSERT OR REPLACE for SQLite
- Handle NOT NULL columns in ALTER TABLE ADD COLUMN
- Handle empty time strings in setter
- Add SQLite CI job, drop Go 1.23 (modernc.org/sqlite requires 1.24+)

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>

201 of 270 new or added lines in 12 files covered. (74.44%)

2770 of 3996 relevant lines covered (69.32%)

63.77 hits per line