Support the online backup API

[parasyte]

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.

[JoshuaWise]

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.

[tmdoit-zz]

Are you planning to add this?

[JoshuaWise]

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.

[JoshuaWise]

Version 5.0.0 is now released. This feature is next on the to-do list!

[131]

I'm also interested in this !

[insert motivation picture here]

[JoshuaWise]

Note to self: this feature requires a refactor of better-sqlite3's busy indicator. In other words, when this issue is resolved, #203 will be resolved at the same time.

Edit: the above statement is not strictly true.

[JoshuaWise]

I'm happy to announce that this feature is now available in v5.4.0.

Also, shameless plug: I'm now accepting supporters on Patreon. If your company uses this project, consider asking your manager to support it. Doing so will allow more great features like this to be developed faster.

[cekvenich]

Sorry... how would I back up using this api?

[JoshuaWise]

Read the docs

[cekvenich]

oops. thx.