News for hackers. Stuff that matters.

A comment on SQLite is not a toy database. Parent comment

Re:SQLite is not a toy database by yellowapple on Friday March 26, 2021 @05:05AM (#26590076)
Neat. I'll have to give that a whirl.

Would this enable any node to be a writer (i.e. would it lock the DB across all nodes)? Or would I have to designate some "master" server with exclusive write access and have any other servers forward write requests to that server?

[ Parent | on HN ]
Re:SQLite is not a toy database by benbjohnson on Saturday March 27, 2021 @12:10PM (#26603306)
It would be the latter. You'd need to have a single primary and replicas would need to redirect writes to that node.
[ Parent | on HN ]