[R-pkgs] New package RSQLite.extfuns and minor upgrade for RSQLite

From: Seth Falcon <seth_at_userprimary.net>
Date: Sun, 30 May 2010 13:33:24 -0700


RSQLite.extfuns provides SQLite extension functions for use with RSQLite. The package is a wrapper of extension functions written by Liam Healy and made available through the SQLite website (http://www.sqlite.org/contrib).

You can make the extension functions available on a per db connection basis like this:

library("RSQLite.extfuns")
db <- dbConnect(SQLite(), dbname = ":memory:") init_extensions(db)

The extension functions provided by the package include:

Math: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi.

String: replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr, padc, strfilter.

Aggregate: stdev, variance, mode, median, lower_quartile, upper_quartile.

RSQLite has been modified to provide the SQLite header files in the installed include directory so that RSQLite.extfuns (and other packages wishing to provide SQLite extension functions) can use LinkingTo. The default value of loadable.extensions is now TRUE.

+ seth

-- 
Seth Falcon | @sfalcon | http://userprimary.net/

_______________________________________________
R-packages mailing list
R-packages_at_r-project.org
https://stat.ethz.ch/mailman/listinfo/r-packages
Received on Mon 31 May 2010 - 06:40:01 EST

This archive was generated by hypermail 2.2.0 : Mon 31 May 2010 - 06:40:05 EST