Can sqlite read gzipped databases?

John Nagle nagle at
Wed Mar 21 06:00:25 CET 2007

    Gzipped files aren't a good random access medium.  It's
unlikely that anyone will implement this.

				John Nagle

Paul Smith wrote:
> Hi,
> I'd like to read a series of sqlite database files that have already been 
> gzipped and was wondering if this can be done on the fly. In other words, can 
> I avoid explicitly unzipping the file into another file, but instead get an 
> SQL connection to the zip file either directly (can't see an option to do 
> this) or to an object in memory resulting from unzipping, eg. (hypothetically);
> import gzip
> from sqlite3 import dbapi2 as sqlite
> data = gzip.GzipFile('Mydbase.db.gz','r')
> d =
> cnx = sqlite.connect(d) # or .connect(data)
> cur = cnx.cursor()
> ....etc
> The above of course doesn't work, but just to give you the idea.
> Thanks,
> Paul

More information about the Python-list mailing list