in reply to Accessing SQLite databases within ZIP files

It seems that since SQLite 3.22 (just released), there is a zipfile extension that allows reading from ZIP-compressed SQLite databases reading and writing ZIP files as if they were tables.

To use it you will either need to manually compile it and load it as a dynamic extension, or modify your build of DBD::SQLite so that the file is directly included and the extension is registered.

Update: This does not treat a compressed SQLite-ZIP file identical to a plain SQLite file, unfortunately.

  • Comment on Re: Accessing SQLite databases within ZIP files