News for hackers. Stuff that matters.
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.
Re:SQLite: Past, Present, and Future by lvass on Thursday September 01, 2022 @10:32AM (#32676804)
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.