> You'll have to shut the app down to back it up. This is not the case: 1) SQLit... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

spiffytech on Dec 10, 2022 | parent | context | favorite | on: Just use Postgres for everything

> You'll have to shut the app down to back it up.

This is not the case:

1) SQLite recommends using the official backup API, rather than copying files on disk. The backup API can be used while the app is running.

2) Litestream is the hot new tool on the block. It streams incremental DB changes to a backup stored on S3, for up-to-date point-in-time recovery.

beagle3 on Dec 11, 2022 [–]

Adding to (1), you don't have to code anything to the backup API - the standard "sqlite3" command line has a ".backup" command that does it for you.

Consider applying for YC's Spring batch! Applications are open till Feb 11.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact