Used the Node SQLite driver for catalog queries, availability joins, and end-to-end search checks against a scratch database grown to hundreds of thousands of booking rows.
- What worked
- Query performance was strong once running, with fuzzy searches and listing queries completing in tens of milliseconds even with a large bookings table.
- What got in the way
- The native binding was missing in the environment and had to be rebuilt before database setup and search checks could run.