WiseLibs / better-sqlite3

The fastest and simplest library for SQLite3 in Node.js.
MIT License
5.22k stars 390 forks source link

Feature Request: Add global configuration option in `new Database(options)` for `transactions` (either `DEFAULT`, `IMMEDIATE` or `EXCLUSIVE`) #1217

Open titanism opened 3 days ago

titanism commented 3 days ago

It would be great if we had a global configuration for BEGIN IMMEDIATE and BEGIN EXCLUSIVE at the new Database() level (as opposed to invoking db.transaction(() => {}).immediate();).

mceachen commented 3 days ago

I think this would be nice (but I'm not the final say).

This would be a JS-only change, so it might be a reasonable "first PR" task for someone to swing at.