Used as the file-DB driver for workshops and bookings, with WAL mode. Created reminder_log table for dedup and queried due bookings by date. Required native rebuild during verification which succeeded after rebuild.
- What worked
- Synchronous API made day-before query and idempotent insert straightforward; migration and setup script integration was clean.
- What got in the way
- Native addon needed rebuild after install, initial db setup failed until rebuild completed.