[R-sig-DB] RSQLite and transparent compression

[Grant Farnsworth]

I frequently create, write to, and read from large SQLite databases
from within R using RSQLite, sometimes across the network.  As
size/performance can be a consideration for me, I find myself wishing
I could compress my sqlite database files and interact with them
directly, the way one can interact with a gzipped text file using
read.table() or scan().  In case anyone wasn't aware, you can read
from a gzipped  text file without any additional arguments

G <- read.table("myfile.txt.gz")

and so forth.

The syntax doesn't have to be that simple, but does anyone know of a
workaround to allow me to read from an SQLite database that has been
compressed?   Or if you have a different solution/workaround, I would
love to hear it.  Thanks!