Re:SQLite in Production: Lessons from Running a Store on a S...
by crazygringo on Tuesday April 07, 2026 @12:16PM
(#47677590)
> since you'll still need to migrate your local Postgres to a central Postres
No you don't. You leave your DB in-place and turn off the web server part. Or even if you do want to migrate, it's basically literally as easy as copying over a directory.
> that's pretty much acknowledging the other one is simpler to setup and maintain.
No it's not. What logic led you there...? They're basically equally simple to set up and maintain, but one also scales while the other doesn't.
The main advantage of SQLite has nothing to do with setup and maintenance, but rather the fact that it is file-based and can be integrated into the binary of other applications, which makes it amazing for locally embedded databases used by user-installed applications. Which is the opposite of the client-server paradigm necessary when you have multiple webservers.
No you don't. You leave your DB in-place and turn off the web server part. Or even if you do want to migrate, it's basically literally as easy as copying over a directory.
> that's pretty much acknowledging the other one is simpler to setup and maintain.
No it's not. What logic led you there...? They're basically equally simple to set up and maintain, but one also scales while the other doesn't.
The main advantage of SQLite has nothing to do with setup and maintenance, but rather the fact that it is file-based and can be integrated into the binary of other applications, which makes it amazing for locally embedded databases used by user-installed applications. Which is the opposite of the client-server paradigm necessary when you have multiple webservers.