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 benbjohnson on Thursday March 25, 2021 @03:32PM (#26584401)
I'm in the process of adding read replication to Litestream[1] so folks can scale out the read-side of their SQLite applications to multiple nodes (or replicate to edge nodes for low-latency).

[1]: https://litestream.io/

[ Parent | on HN ]
Re:SQLite is not a toy database by pdimitar on Thursday March 25, 2021 @06:26PM (#26586383)
Amazing. This was missing for my use-case and I gave up on LiteStream because of it but now it seems I have to revisit!

Wonderful job.

[ Parent | on HN ]
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 ]