Hi All, I'm trying to figure out how to link RSQLite to an external sqlite3.dll file compiled for a 64bit platform. I see from the CRAN installation instructions that on a unix machine there's a way to set the configuration to access an outside, so I assume it's possible (see: http://cran.r-project.org/web/packages/RSQLite/INSTALL). Any guidance on how to point RSQLite to a 64 bit sqlite3.dll? The reason, for those interested, is that 32 bit windows was built with memory addressing that couldn't allocate more than 2gb of ram to a single process. The 32 bit build of sqlite3 still has these variable types, so even on a 64 bit machine, it can't allocate more than 2gb of ram. SQLite.org just (today) posted a 64 bit .dll file for SQLite, but I'm not sure how to point RSQLite to that library. Thanks! Nick
Link RSQLite to external (windows) SQLite Installation?
2 messages · Nick Eubank
A few followup notes of other things I've tried: - compiled the FULL (so sqlite3 folder with lib and include and an .exe inside) 64 bit build; installed (and tested) in "C:/sqlite3". - removed and installed RSQLite with INSTALL_opts="--with-sqlite-dir=C:/sqlite3"(since "configure-args" aren't for windows) - removed and installed RSQLite with system vars PKG_LIBS="-Lc:/sqlite3/lib -lsqlite" and PKG_CPPFLAGS="-Ic:/sqlite3/include" Still no luck.
On Mon, Jun 30, 2014 at 11:26 AM, Nick Eubank <nickeubank at gmail.com> wrote:
Hi All, I'm trying to figure out how to link RSQLite to an external sqlite3.dll file compiled for a 64bit platform. I see from the CRAN installation instructions that on a unix machine there's a way to set the configuration to access an outside, so I assume it's possible (see: http://cran.r-project.org/web/packages/RSQLite/INSTALL). Any guidance on how to point RSQLite to a 64 bit sqlite3.dll? The reason, for those interested, is that 32 bit windows was built with memory addressing that couldn't allocate more than 2gb of ram to a single process. The 32 bit build of sqlite3 still has these variable types, so even on a 64 bit machine, it can't allocate more than 2gb of ram. SQLite.org just (today) posted a 64 bit .dll file for SQLite, but I'm not sure how to point RSQLite to that library. Thanks! Nick