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