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

Seth Falcon seth at userprimary.net
Sun May 30 22:33:24 CEST 2010


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/



More information about the R-packages mailing list