[R-sig-DB] RSQLite and transparent compression
Grant Farnsworth
gv|@rn@ @end|ng |rom gm@||@com
Tue Aug 6 02:23:20 CEST 2013
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!
More information about the R-sig-DB
mailing list