News for hackers. Stuff that matters.

A comment on Costs of running a Python webapp for 55k monthly users. Parent comment

Re:Costs of running a Python webapp for 55k monthly users by limteary on Friday September 04, 2020 @04:00AM (#24372770)
Why use SQLite?

My postgres process doesn't come close to using up enough resources to push me out of even the cheap VPS tiers and I don't have to worry about locking if there's a heavy write load.

[ Parent | on HN ]
Re:Costs of running a Python webapp for 55k monthly users by theshrike79 on Friday September 04, 2020 @05:25AM (#24373266)
Backing up an SQLite database is as simple as copying a single file. As long as nothing is writing in the file, you're good.
[ Parent | on HN ]
Re:Costs of running a Python webapp for 55k monthly users by mattmanser on Friday September 04, 2020 @05:46AM (#24373397)
That's not a reason.

Plus setting up a nightly back up of any SQL database, regardless of creed, is like a 10 line cron job.

[ Parent | on HN ]
Re:Costs of running a Python webapp for 55k monthly users by ClumsyPilot on Friday September 04, 2020 @07:57AM (#24374131)
Some developers have never written a cron job.

I think the point here is, SQLite setup would provide satisfactory results at this scale.

If the choice is betweeen a PAAS database offering and SQLite, you can pick SQLite. If you have skills / are prepared for managing dbserver yourself, then do that.

[ Parent | on HN ]
Re:Costs of running a Python webapp for 55k monthly users by aahortwwy on Friday September 04, 2020 @05:47AM (#24373406)
Yeah, fair point. From a cost standpoint it's more about using the same server for your application and your database.
[ Parent | on HN ]