[Python-Dev] Supporting native backup facility of SQLite

[Paul Moore]

On 11 July 2016 at 16:59, Lele Gaifax <lele at metapensiero.it> wrote:
> Paul Moore <p.f.moore at gmail.com> writes:
>
>> There's also apsw (https://github.com/rogerbinns/apsw), which appears
>> to support backup - http://rogerbinns.github.io/apsw/backup.html.
>
> Thank you, will have a look: not sure it fits my need, because the application
> is currently based on Python's sqlite module (thru SQLAlchemy), and it seems
> I'd have to open another APSW connection just to make the backup...
>
> Original questions still hold, though.

Indeed - I don't see any reason why exposing the backup API through
the sdlib module would be unacceptable (there's plenty of
sqlite-specific functionality in there already, it's not as if there's
a need to limit the module to just the DB-API interface). If you were
interested in doing that, I'd suggest opening a tracker issue with a
patch.

Paul