search

pawelsalawa / sqlitestudio

A free, open source, multi-platform SQLite database manager.
https://sqlitestudio.pl
Other
5.43k stars 585 forks source link

[feature request] Allow to disable journaling #2900

Open pawelsalawa opened 6 years ago

pawelsalawa commented 6 years ago

(This issue was migrated from the old bug tracker of SQLiteStudio)

Original ID from old bug tracker: 3016 Originally created at: Tue Jan 19 18:04:32 2016 Originally last updated at: Tue Jan 19 18:04:32 2016

I have the DB file at the location where new files can''t be created. When my app opens such DB, it always executes "PRAGMA journal\_mode = OFF;" first. SQLiteStudio fails to update such DB with the message "Could not commit view changes. Error message: unable to open database file"

Please add the new option "Disable journaling" that will always execute that command first before doing anything else. \n\nOperating system:\nFreeBSD 64-bit\n\nVersion:\n3.0.7

pawelsalawa commented 6 years ago

Originally created at: Tue Jan 19 18:04:32 2016

On the second thought, you might also want to add options for some othoer SQLite pragmas. Examples that I use for some DB connections: PRAGMA synchronous = OFF; (improves speed) PRAGMA cache\_size = -1000000; (improves speed) PRAGMA foreign\_keys=ON; PRAGMA defer\_foreign\_keys=ON; (executed after 'BEGIN TRANSACTION;', delays foreign keys until commit.)

pawelsalawa commented 6 years ago

Related to #2658