5 ms·
I've been doing some ETL exploration with opening a sqlite :memory: connection, ingesting small-to-medium data, and then doing "VACUUM INTO somefile.sqlite;"
by smitty1e 5y ago
I've been doing some ETL exploration with opening a sqlite :memory: connection, ingesting small-to-medium data, and then doing
"VACUUM INTO somefile.sqlite;"
to dump the RAM copy to disk.
What a great tool.
- zbentley 5y agoWhat does that do? How is VACUUM different from BACKUP in this context?
- smitty1e 5y ago"The VACUUM command with an INTO clause is an alternative to the backup API for generating backup copies of a live database. The advantage of using VACUUM INTO is that the resulting backup database is minimal in size and hence the amount of filesystem I/O may be reduced. Also, all deleted content is purged from the backup, leaving behind no forensic traces. On the other hand, the backup API uses fewer CPU cycles and can be executed incrementally." https://sqlite.org/lang_vacuum.html https://sqlite.org/lang_vacuum.html