Hello All,
I'm trying to figure out how to link RSQLite to an external sqlite3
installation compiled for a 64bit platform. I see from the CRAN
installation instructions (see:
http://cran.r-project.org/web/packages/RSQLite/INSTALL) that on a unix
machine there's a way to set the configuration to access an outside, and in
theory the installation says it looks for sqlite installations before
downloading one of it's own, so I assume it's possible.
I've tried the changes recommended in the installation PDF, including:
- compiling and installing sqlite3 (a full folder located at C:/sqlite3
with "lib", "include", and an .exe), then removing and reinstalling
RSQLite.
- removing and installing RSQLite with
INSTALL_opts="--with-sqlite-dir=C:/sqlite3" (since apparently
"configure-args" aren't for windows?)
- removing and installing RSQLite after setting system vars
PKG_LIBS="-Lc:/sqlite3/lib -lsqlite" and PKG_CPPFLAGS="-Ic:/sqlite3/include"
- removing and installing RSQLite after setting system var
"LD_LIBRARY_PATH=C:/sqlite3/lib"
In all cases, when I create then query a new database (using dbGetInfo())
the system remains 3.7.17 -- the default RSQLite installation -- never
3.8.5 -- the version I installed.
(The reason, for those interested, is that 32 bit windows was built with
memory address stored in variables that couldn't address to more than 2gb
of space, limiting individual processes to ~1900mb. The 32 bit build of
sqlite3 still uses the variable types that can only cover 2gb of ram, so
even on a 64 bit machine, 32bit sqlite3 can't allocate more than 2gb of
ram, which has a huge effect on performance. So I'm trying to connect to a
64 bit build. )
Thanks!
Nick
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
