PDO\SQLite: add support for backup API

[bohwaz]

Description

SQLite3 class provides support for the SQLite3 backup API: https://www.php.net/manual/en/sqlite3.backup.php

 SQLite3::backup(SQLite3 $destination, string $sourceDatabase = "main", string $destinationDatabase = "main"): bool

It would be nice to have the same in PDO\SQLite:

PDO\SQLite::backup(PDO\SQLite $destination, string $sourceDatabase = "main", string $destinationDatabase = "main"): bool

[ndossche]

Yeah that's a fair request. I might give this a shot either today or tomorrow.

[bohwaz]

\o/ thanks!

With your work we are almost at the point of having the same features in both extensions! Maybe at one point we'll be able to deprecate \SQLite3 :)

[ndossche]

Maybe at one point we'll be able to deprecate \SQLite3 :)

Careful, you'll awake the BC police ;p

[bohwaz]

I'm part of the BC police but I think in the long term this would be nice to have only one codebase to maintain :)