Optimizing SQLite for servers
Optimizing SQLite for servers
TL;DR?
PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 5000;
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = 1000000000;
PRAGMA foreign_keys = true;
PRAGMA temp_store = memory ;
Good article. Interesting perspective on the problem.
I tend to use DuckDB now instead of SQLite for my applications. Though it would be nice if it had better concurrency support.
Thank for your comment. I had heard of DuckDB but never checked it out. "why you would i need that I use postgres"... But I just found the WASM implementation and I have been looking for something like this for years. Thank you!
And why would anyone use SQLite outside the embedded world, when you can get way more performance with ClickHouse?
Did you read the article?
There's more to SQLite than the embedded world and not everyone requires ClickHouse's performance.