Hello, I've been working on some enhancements for RSQLite, and here they are :-) CHANGES ======= Version 0.4-5 * Update to the SQLite 3 API for fetching records. This means that the records are pulled from the database as required, and not cached in memory as was previously done. * dbConnect() now has a parameter "loadable.extensions" which will allow loading of extensions. See the loadable extensions documentation: http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions The source and binary packages are available at: http://puggy.symonds.net/~ashish/downloads/R/ I'm planning to add more features to RSQLite next week: * use actual types from SQLite and remove the type.convert calls * implement DBIPreparedStatment and friends, similar to ROracle * implement dbApply (if time permits .. this will be tough). BTW, the SQLite tarball for 0.4-4 contains a ELF-binary copy of SQLite (I assume it's Linux) in the inst/ folder. This get copied on even windows binary packages, increasing its size from roughly 356kB -> 1.5M. Hope this helps, Ashish
RSQLite enhancements
2 messages · Ashish Kulkarni, Seth Falcon
Hi Ashish, "Ashish Kulkarni" <ashish.kulkarni at kalyptorisk.com> writes:
Hello, I've been working on some enhancements for RSQLite, and here they are :-)
Wow, these changes look great. I will plan on applying the patch you posted.
I'm planning to add more features to RSQLite next week: * use actual types from SQLite and remove the type.convert calls * implement DBIPreparedStatment and friends, similar to ROracle * implement dbApply (if time permits .. this will be tough).
Sounds good. I think there are many users who will appreciate having access to prepared statements.
BTW, the SQLite tarball for 0.4-4 contains a ELF-binary copy of SQLite (I assume it's Linux) in the inst/ folder. This get copied on even windows binary packages, increasing its size from roughly 356kB -> 1.5M.
Oops, will take care of that in the next push to CRAN. While there _is_ an ELF-binary that doesn't belong, the size is not going to be 356kB. The sqlite source tarball is 1.7MB alone. + seth