27
Optimizing SQLite for servers (kerkour.com)
submitted 4 months ago by 0x0@programming.dev to c/sql@programming.dev
7 comments fedilink hide all child comments

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 ;

you are viewing a single comment's thread
view the rest of the comments
[-] nezbyte@lemmy.world 2 points 4 months ago

I tend to use DuckDB now instead of SQLite for my applications. Though it would be nice if it had better concurrency support.

[-] sjpwarren@programming.dev 3 points 4 months ago

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!

this post was submitted on 20 Jun 2024
27 points (100.0% liked)

SQL

469 readers
1 users here now

Related Fediverse communities:

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

founded 1 year ago
MODERATORS
Ategon@programming.dev
jnovinger@programming.dev