Re:SQLite: Past, Present, and Future
by rafale on Thursday September 01, 2022 @10:27AM
(#32676714)
Should have said the most performance oriented setting that's also safe from data corruption.
[ Parent
| on HN ]
Then it depends on the usage. You'd likely need to run with synchronous mode on, and even on WAL, multiple separate write transactions is a issue. If you don't have many writes or buffer them into not many transactions, SQLite is the most performant.