SQLite Forum

VACUUM INTO for vfs conversion
Login

VACUUM INTO for vfs conversion

(1.1) By Max (Maxulite) on 2021-09-29 16:08:20 edited from 1.0 [source]

I recently noticed that VACUUM INTO command has an "implicit" feature not mentioned in the docs. It can be used for conversion between VFSes. Since it support URI filenames the target might be different to the VFS the database is opened with. I, for example, for a long time had dedicated menu items in my admin for converting the current db to a specific VFS format and back. Now (actually since the day VACUUM INTO was introduced) one can also do this with an SQL construct

VACUUM INTO 'file:///c:/temp/mydb?vfs=myvfs'.

I think this feature is deserved to be added to the VACUUM doc page, maybe as a simple several words sentence.

Something to wish for is support for passing custom uri parameters to VFSes. With this it would be possible to VACUUM INTO with required parameters like for example passwords for encrypted databases and so on.

(2) By anonymous on 2021-09-30 15:57:38 in reply to 1.1 [link] [source]

Something to wish for is support for passing custom uri parameters to VFSes.

This already exists.