This came up when I was looking for a durable storage layer with hot backup capabilities. SQLite3 supports it readily: https://sqlite.org/backup.html The API just needs to be exposed to node. It looks like this (and probably other APIs) are unimplemented in all of the popular SQLite bindings for nodeJS.
Sure, there's no reason this can't be done. You can make a PR to speed things up, otherwise I'll get to it when I have time.
Are you planning to add this?
Soon version 5.0.0 will be released. That version won't have the online backup API, but soon after that I'll be working on adding support for this in a minor version.
Version 5.0.0 is now released. This feature is next on the to-do list!
I'm also interested in this !
[insert motivation picture here]
~Note to self: this feature requires a refactor of better-sqlite3's busy indicator. In other words, when this issue is resolved, https://github.com/JoshuaWise/better-sqlite3/issues/203 will be resolved at the same time.~
_Edit: the above statement is not strictly true._
Sorry... how would I back up using this api?
oops. thx.
Most helpful comment
Version 5.0.0 is now released. This feature is next on the to-do list!