SQL

470 readers

1 users here now

Related Fediverse communities:

#sql on Mastodon
#postgresql on Mastodon
c/PostgreSQL on programming.dev

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

founded 1 year ago

MODERATORS

Ategon

jnovinger

Optimizing SQLite for servers (kerkour.com)

submitted 4 months ago by 0x0 to c/sql

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 ;

top 7 comments

sorted by: hot top controversial new old

[–] [email protected] 3 points 4 months ago

Good article. Interesting perspective on the problem.

[–] [email protected] 2 points 4 months ago (1 children)

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

[–] sjpwarren 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!

[–] [email protected] 1 points 4 months ago (1 children)

And why would anyone use SQLite outside the embedded world, when you can get way more performance with ClickHouse?

[–] 0x0 3 points 4 months ago (1 children)

Did you read the article?

There's more to SQLite than the embedded world and not everyone requires ClickHouse's performance.

[–] [email protected] 0 points 4 months ago (1 children)

I actually did. There is still no reason to be wasteful with ressources. Why should I need to use a 4 core machine, when I could just use a single core machine?

Only because „it works“, does not make it a valid reason to use it.

[–] 0x0 1 points 4 months ago

Why should I need to use a 4 core machine

Just 'cos the article writer used one doesn't mean you have to and i doubt "multiple CPUs" is a requirement for SQLite.