News for hackers. Stuff that matters.
Re:SQLite – The “server-process-edition” branch by emn13 on Wednesday August 15, 2018 @05:38PM (#17770005)
It's faster? Simpler?

Conversely, why would you choose one of those alternatives?

(I don't actually think there aren't any reasons to do so, mind you, but I can well imagine that if you really KISS, well - even at impressive sizes sqlite makes sense).

Re:SQLite – The “server-process-edition” branch by vesak on Thursday August 16, 2018 @12:29AM (#17771891)
SQLite's typing is rather weak, is it not? That might be a tad scary for someone used who relies on that part of PostgreSQL.
Re:SQLite – The “server-process-edition” branch by kjax on Thursday August 16, 2018 @01:42AM (#17772214)
It sure is. After recently porting a large application from SQLite to Postgres, much of my time was spent casting types and ensuring code was updated to input the correct types into Postgres. All in all, the changes were for the better, as many bugs were discovered and resolved in the process.
Re:SQLite – The “server-process-edition” branch by da_chicken on Thursday August 16, 2018 @12:52PM (#17776363)
Well, the historic one is, "because you need multiple concurrent data writers."

But, that's what this branch is supposed to be for. So now the reason is: "because you need multiple concurrent data writers from multiple processes." And it might also be "you need multiple concurrent data writers and care about your data enough to not risk loss in the event of a system crash or power failure" since it uses PRAGMA synchronous=OFF.