Open a compressed SQLite database in Python

Question

In Python, is there a more or less hacky way to open a compressed SQLite database without having to write a temporary file somewhere?

Something like:

import bz2
import sqlite3

dbfile = bz2.BZ2File("/path/to/file.bz2", "wb")
dbconn = sqlite3.connect(dbfile)

cursor = dbconn.cursor()
...

This of course raises:

ValueError: database parameter must be string or APSW Connection object

Manu · Accepted Answer · 2014-10-26 16:41:50Z

7

The underlying C-library directly uses the filename string. Thus there is no way to transparently work on it from Python.

See the code on Github

Depending on your OS, you might be able to use a RAM-disk to work on the file. If your sqlite-file is bigger than that, it might be time to switch to another DB-system, like Postgres.

answered Oct 26, 2014 at 16:41

Manu

3,5121 gold badge18 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kynikos Over a year ago

Thank you, PyFilesystem might be able to give me a cross-platform ramdisk

Collectives™ on Stack Overflow

Open a compressed SQLite database in Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest