←back to thread

SQLite concurrency and why you should care about it

(jellyfin.org)
353 points HunOL | 1 comments | 01 Nov 25 12:59 UTC | HN request time: 0s | source
Show context
mickeyp ◴[01 Nov 25 13:48 UTC] No.45781619[source]▶
SQLite is a cracking database -- I love it -- that is let down by its awful defaults in service of 'backwards compatibility.'

You need a brace of PRAGMAs to get it to behave reasonably sanely if you do anything serious with it.

replies(2): >>45781956 #>>45781998 #
tejinderss ◴[01 Nov 25 14:38 UTC] No.45781956[source]▶
Do you know any good default PRAGMAs that one should enable?
replies(3): >>45782017 #>>45782031 #>>45782813 #
1. e2le ◴[01 Nov 25 16:11 UTC] No.45782813[source]▶
Although not what you asked for, the SQLite authors maintain a list of recommended compilation options that should be used where applicable.

https://sqlite.org/compile.html#recommended_compile_time_opt...