Re:Why SQLite succeeded as a database (2016)
by BubRoss on Wednesday February 19, 2020 @02:45PM
(#22369265)
Why didn't you just do more granular writes and let the different processes lock the file? SQLite is impressively fast, it can handle a lot before you need a full database.
[ Parent
| on HN ]
Re:Why SQLite succeeded as a database (2016)
by umvi on Wednesday February 19, 2020 @03:48PM
(#22369899)
I don't know how to do that.
Basically there is one process periodically dumping stats into a sqlitedb. There is an HTTP API that can retrieve said stats. How do I make it so the HTTP API doesn't occasionally fail when trying to read from the DB?
Re:Why SQLite succeeded as a database (2016)
by BubRoss on Wednesday February 19, 2020 @07:30PM
(#22371684)
Retry until it gets the lock and don't hold the lock longer than you need to to write to the db.
Really though if you are trying to read and write to a db concurrently and over the network, it sounds much more clear cut for something like postgres.
Re:Why SQLite succeeded as a database (2016)
by umvi on Thursday February 20, 2020 @09:29PM
(#22380478)
I don't really like the idea of a retry loop. Why doesn't sqlite have an API to just block until the DB is available?
Re:Why SQLite succeeded as a database (2016)
by BubRoss on Friday February 21, 2020 @12:40AM
(#22381162)
You asked the question and now you don't like the 'idea' of the answer. Use real numbers instead of feels, and again if you need real concurrency, use a real database.
Re:Why SQLite succeeded as a database (2016)
by umvi on Saturday February 22, 2020 @10:02AM
(#22391330)
"Retry" is not a solution; it's a workaround. Imagine if that's how opening files worked: "Oh yeah, if the file fails to open just retry a few times until it works."
There's a small chance even retrying 3 times you could fail all 3 times in a row. WAL journaling is a solution.