News for hackers. Stuff that matters.
Re:SQLite 3.32 by lenkite on Saturday May 23, 2020 @12:10PM (#23284077)
How do you architect this ? This works only for single process web-apps right ? With no HA or failover ?
Re:SQLite 3.32 by jventura on Saturday May 23, 2020 @12:28PM (#23284254)
Right! But as I said, the low traffic volume doesn’t require more than this kind of architecture.

I do regular file backups and have a cron job restarting the web apps each 20 minutes, it’s enough for now. I would love to have a more solid architecture, but it matches the traffic volume and it’s good enough..

Re:SQLite 3.32 by duskwuff on Saturday May 23, 2020 @07:12PM (#23287472)
TBH, it'll work for a lot of multi-process apps, so long as the app runs on a single server and the app doesn't do anything foolish like write to the database on every page hit. For read-mostly applications -- like a blog, wiki, or even a small web forum -- SQLite is a surprisingly adequate database.