I would like to be able to select which vfs to use with the ATTACH
DATABASE command, similar to what is possible with sqlite3_open_v2().
A PRAGMA statement might be the easiest to implement, but extending
the ATTACH DATABASE seems more elegant.
I was thinking of either:
ATTACH DATABASE 'file.db' AS alias USING 'vfs_name'
or
ATTACH DATABASE 'file.db' AS alias WITH vfs = 'vfs_name'
It might also be nice to be able to use the latter syntax for
additional per-database settings, e.g. locking_mode, journal_mode,
etc.
I hope this is a useful suggestion.
-- gifford
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
