Re:The Session Extension
by tptacek on Monday December 13, 2021 @05:13PM
(#29545356)
Multi-writer concurrency with sqlite is a giant pain in the ass.
[ Parent
| on HN ]
There are, nonetheless, lots of situations where I would have reached for pg automatically a few years ago where I now stop and think about which of the two is going to fit my use case better.
The comment you're replying to is saying rather more than that, and I don't endorse it, but the shift in the possibility space is still both fascinating and impressive.
(also I love sqlite's tendency to use pg as a syntax template, it seems like an example of two projects with significantly different goals playing to each others' strengths in a beautifully positive sum game fashion)
The writers need to be serialized but it's not that big a pain.