4 ms·
Right, but in this case that's not a thing anyways since there's only one server.
by t0astbread 6y ago
Right, but in this case that's not a thing anyways since there's only one server.
- IgorPartola 6y agoThe main reason for me is that Postgres can be backed up while online, and I can scale up to multiple servers if I suddenly need to. Not so much with SQLite where if a small project suddenly hit the front page of whatever I would suddenly need to get really creative.
- t0astbread 6y agoI'm not sure how well the architecture described in the article lends itself to horizontal scaling since everything assumes it's on the same machine (I think?). Granted, if you build for horizontal scaling I agree, a client/server database is the way to go. As for backups, SQLite also supports backups while another process is using the database.