Does anyone know if a Linux binary extension of this is available (.so)? If you load RSQLite package into R you will get the RSQLite.so file that can be used as an extension in a Linux version of SQLite. It works. http://cran.r-project.org/web/packages/RSQLite/index.html
(RSQLite.extfuns.dll) is 40 KB while RSQLite.so is 4 MB. It appears that (RSQLite.extfuns.dll) is just the "extension-functions.c", while RSQLite.so is a full implementation of SQLite for R plus the extension functions. (RSQLite.extfuns.dll) still works on Windows versions of software that use SQLite. I wish these were compiled into every release of SQLite as they are very useful. 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. The string functions ltrim, rtrim, trim, replace are included in recent versions of SQLite and so by default do not build. https://github.com/seth/RSQLite.extfuns/blob/master/src/extension-functions.c Joe Fisher Oregon State University
