m4heshd/better-sqlite3-multiple-ciphers ? reverse-engineered prompt
Reverse engineered prompt
Build me a Node.js SQLite library that feels really simple to use, but also supports encrypted databases with multiple cipher options. I want a fast synchronous API for querying, inserting, transactions, and prepared statements, plus support for things like custom functions, aggregates, virtual tables, extensions, and big integers. It should work nicely in Node and Electron, and ideally handle heavier queries without freezing everything.
The main thing I care about is encryption, so make it easy to open a database with a key, change the key later, and read or create databases using different cipher setups, including compatibility with older SQLCipher databases when needed. Keep the usage clean and beginner friendly, like opening a file and running SQL right away. If there are setup details or current docs I should follow for the encryption part, look them up online and use the right approach.
Are you gonna build this?
make sure you review the code using coderabbit