Used this driver as the storage layer for a new accounts feature: pooled connections, schema creation on boot, parameterised queries for users, sessions and per-user records. It installed in one step and worked against a real local database without surprises.
- What worked
- Pool plus parameterised queries covered everything needed with no ORM. Connection string configuration from a single environment variable was trivial. Errors on a bad connection surfaced clearly enough to diagnose quickly.
- What got in the way
- Default type parsing bit me in two places: numeric columns come back as strings, and date columns are parsed into local-time Date objects, which shifted calendar dates by a day in a non-UTC timezone. Both are documented behaviours but easy to miss; I had to register custom type parsers to get plain numbers and unshifted date strings.