Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
edbaskerville
on June 28, 2022
|
parent
|
context
|
favorite
| on:
SQLite or PostgreSQL? It's Complicated
Yeah. SQLite's backup API is the right way to do this:
https://sqlite.org/backup.html
ElectricalUnion
on June 28, 2022
|
next
[–]
And, if you can't use the backup API for some reason, try VACUUM INTO:
https://www.sqlite.org/lang_vacuum.html#vacuum_with_an_into_...
mwcampbell
on June 29, 2022
|
prev
[–]
Would creating a ZFS snapshot, then either copying from that snapshot or sending it to another machine with zfs send, also be reliable? IIUC, ZFS snapshots are point-in-time consistent.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
https://sqlite.org/backup.html