[R-sig-DB] Link RSQLite to external (windows) SQLite Installation?

[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 using 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
>

	[[alternative HTML version deleted]]