Re:SQLite the only database you will ever need in most cases
by yaur on Thursday April 15, 2021 @03:33AM
(#26817236)
"can't run embedded" means you have to have a dedicated DB server process. For anything I would use a database for this is a non issue, but if you want a DB in your mobile app (for example) it might be.
Re:SQLite the only database you will ever need in most cases
by skohan on Thursday April 15, 2021 @04:10AM
(#26817503)
So if SQLite is typically run embedded in the client application, does this mean it's not supported to have multiple clients operating on the same SQLite DB concurrently, or is there some support for this?
Re:SQLite the only database you will ever need in most cases
by hypertele-Xii on Thursday April 15, 2021 @04:35AM
(#26817707)
It uses filesystem locking mechanisms to synchronize concurrent access from multiple processes. One writer, multiple readers.
Re:SQLite the only database you will ever need in most cases
by devin on Thursday April 15, 2021 @04:32AM
(#26817676)
This is covered early on in the article.
Re:SQLite the only database you will ever need in most cases
by thomascgalvin on Thursday April 15, 2021 @09:24AM
(#26820151)
It's mentioned briefly in the article, but no instructions are given on how to properly configure busy_timeout and WAL to scale above more than a few concurrent writes per second.
Re:SQLite the only database you will ever need in most cases
by millerm on Thursday April 15, 2021 @08:52AM
(#26819826)
It’s sad when most people discuss things based on a one line title of something they haven’t read. Many questions here were answered in that article. I recently asked someone on a different site “didn’t you read the article?”. The obvious answer I alluded to was “No, I don’t have time.” Yet they managed to post about 15 different comments asking more questions about the article (title). I really wish there was a way to have a public forum with proper discourse with the caveat that people must read the material before they comment on it.
Re:SQLite the only database you will ever need in most cases
by 5cents on Thursday April 15, 2021 @07:43PM
(#26827549)
The technical blog of the public broadcaster of Norway has implemented exactly this: https://nrkbeta.no/2017/08/10/with-a-quiz-to-comment-readers...
The quiz module is open-source (https://nrkbeta.no/2017/03/06/our-comment-quiz-module-is-now...) and available on github https://github.com/nrkbeta/nrkbetaquiz
Re:SQLite the only database you will ever need in most cases
by millerm on Monday April 19, 2021 @02:07PM
(#26866082)
Thanks for the links. :-)
I've run Postgres in a pure RAM only configuration, never touching the disk except to start.
If you mean "it can't be compiled in to another application as a library", then yes that's true - it's not an embedded database.