News for hackers. Stuff that matters.
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.
Re:The Session Extension by mst on Monday December 13, 2021 @11:47PM (#29548345)
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)

Re:The Session Extension by pstuart on Monday December 13, 2021 @08:10PM (#29546938)
The writers need to be serialized but it's not that big a pain.
Re:The Session Extension by le-mark on Monday December 13, 2021 @07:04PM (#29546426)
Multiple reader single writer out performs Postgres in my testing, by a large margin.