Better-sqlite3: Support the online backup API

Created on 23 Jan 2018  路  10Comments  路  Source: JoshuaWise/better-sqlite3

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.

enhancement

Most helpful comment

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

All 10 comments

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._

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.

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

oops. thx.

Was this page helpful?
0 / 5 - 0 ratings

Related issues

faac-spazio-italia picture faac-spazio-italia  路  5Comments

mann-david picture mann-david  路  5Comments

Silve2611 picture Silve2611  路  6Comments

BobbyT picture BobbyT  路  3Comments

DrDonkeyPunch picture DrDonkeyPunch  路  5Comments