top | item 24372770 (no title) limteary | 5 years ago 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. discuss order hn newest theshrike79|5 years ago 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. mattmanser|5 years ago 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. load replies (1) aahortwwy|5 years ago Yeah, fair point. From a cost standpoint it's more about using the same server for your application and your database.
theshrike79|5 years ago 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. mattmanser|5 years ago 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. load replies (1)
mattmanser|5 years ago 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. load replies (1)
aahortwwy|5 years ago Yeah, fair point. From a cost standpoint it's more about using the same server for your application and your database.
theshrike79|5 years ago
mattmanser|5 years ago
Plus setting up a nightly back up of any SQL database, regardless of creed, is like a 10 line cron job.
aahortwwy|5 years ago