(jellyfin.org)

353 points HunOL | 3 comments | 01 Nov 25 12:59 UTC | HN request time: 0.697s | 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.

mkoubaa ◴[01 Nov 25 14:44 UTC] No.45781998[source]▶

Seems like it's asking to be forked

1. justin66 ◴[01 Nov 25 14:58 UTC] No.45782143[source]▶

It has been forked at least once:

replies(1): >>45790067 #

2. fulafel ◴[02 Nov 25 13:14 UTC] No.45790067[source]▶

How are the defaults there?

replies(1): >>45792348 #

3. justin66 ◴[02 Nov 25 18:33 UTC] No.45792348[source]▶

The default is, don't use it.

SQLite concurrency and why you should care about it