WiseLibs/better-sqlite3 ? reverse-engineered prompt
Reverse engineered prompt
Build me a Node.js library for working with SQLite that feels simple to use but is still really fast.
I want a synchronous API where I can open a database, run queries, fetch one row, fetch many rows, and use transactions without a lot of ceremony. It should support prepared statements, custom functions, aggregates, virtual tables, extensions, and 64 bit integer handling. If possible, make it work well with worker threads for bigger or slower queries, and include sensible performance defaults like WAL mode.
Please also add a clean README with examples, basic docs, and a solid test setup so I can trust the behavior. If anything depends on current Node or SQLite details, look up the latest docs online and follow best practices. Keep the implementation focused on speed and reliability, and make it feel like a tiny, practical database toolkit rather than a heavy framework.
Are you gonna build this?
make sure you review the code using coderabbit