Yes, it's five minutes to set up now. But it's an extra liability to have to maintain the network in the future, when things inevitably change.
Re:Siren Call of SQLite on the Server
by crazygringo on Wednesday February 19, 2025 @02:15PM
(#43106144)
OK. Maybe an extra 10 min of work in the future?
Compare that to the days or even weeks it's going to take you to migrate to a client-server database platform as soon as you need to scale to two webservers. All the queries that need to be tested and modified as necessary... potentially different table structures... the migration of data... no thanks.
Most projects will never need to scale to two web servers. The ones that do will be successful enough to have the resources to migrate.
But I guess this all depends on whether it's B2B (likely not to have that many customers), B2C (potentially more users), or a hobby project (gimme operational simplicity!). And many other variables. YMMV!
I call it five minutes of setup, if even.
And if you're dealing with SQLite, are you making backups somewhere on a network? Securely? With credentials? Where do you keep the credentials for your webserver itself? If you're running a website, you're dealing with a network and credentials from the start.