Support dumping and recovering

[fabiospampinato]

SQLite's shell has two pretty cool commands:

• .dump: it converts an entire database into a SQL string basically.
• .recover: it's like .dump but it for all possible data it can find, including deleted stuff that hasn't been vacuumed yet, and data inside corrupted database.

I don't know if it would be practical to add support for these functions to deno-sqlite, but it sure would be nice, imo.

[dyedgreen]

We currently have serialize and deserialize. Do these do what you want?

[fabiospampinato]

No. Neither of them return me a SQL string. And serialize doesn't allow me to extract data from corrupted databases.

[dyedgreen]

I don't think those functions exist directly in the SQLite API. I'd be curios to see how the CLI implements those commands; but I'd prefer to only expose things that are possible with the SQL C API directly (transliterated to a more JS friendly API where possible).

[fabiospampinato]

Sure, no problem 👍