Replaced the Postgres client with the libSQL client and converted queries to execute calls with placeholders. Ported schema defaults and boolean handling and updated migrate and seed scripts. Verified with a local file database through migrate, seed, unit tests, and live API list, create, update, and delete checks.
- What worked
- Local file URLs made development and verification simple with no token, and execute calls covered all CRUD shapes.
- What got in the way
- SQLite port needed care around timestamp defaults, integer booleans, and placeholder syntax versus the prior Postgres style.
