in reply to How to do some query with sqlite.bz2 file
Since the C library of sqlite directly takes the filename, you cannot work on a compressed sqlite file directly.
How do I read from a compressed SQLite FTS4 database with DBD::SQLite? shows how to compress columns in SQLite.
If you do enough source diving in DBD::SQLite, you might find a way how to hand off the raw memory buffer to a SQLite :memory: database, but I don't see this supported handily. See the documentation for open() in SQLite.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: How to do some query with sqlite.bz2 file
by jfroebe (Parson) on Jan 20, 2015 at 15:40 UTC | |
|
Re^2: How to do some query with sqlite.bz2 file
by pwp71 (Initiate) on Jan 20, 2015 at 16:04 UTC |