Add SQLcipher to SQLite implementation

[MarByteBeep]

What is the problem this feature would solve?

Currently the sqlite implementation, which is based on better-sqlite3, doesn't seem to support (sqlcipher) encrypted databases.

What is the feature you are proposing to solve the problem?

Would it be possible to add sqlcipher (https://www.zetetic.net/sqlcipher/) support, such that the following would be allowed?

db.run('PRAGMA cipher_compatibility = 4');
db.run(`PRAGMA key = 'mysecretkey'`);
db.run('PRAGMA journal_mode = WAL');

Currently I get an error when attempting to read from an encrypted sqlite database:

SQLiteError: file is not a database
 errno: 26
  code: "SQLITE_NOTADB"

What alternatives have you considered?

I've tried node-sqlcipher which seems to work fine, but since it's based on @mapbox code, I run into a whole bunch of webpack errors when tying to use the database in combination with vite, as is discussed here: mapbox/node-pre-gyp#661

It would be so awesome if Bun simply supports this out-of-the-box

[dalisoft]

+1