Description Usage Arguments Available extension functions Examples
These extension functions are written by Liam Healy and made available through the SQLite website (http://www.sqlite.org/contrib).
1 | initExtension(db)
|
db |
A |
acos, acosh, asin, asinh, atan, atan2, atanh, atn2, ceil, cos, cosh, cot, coth, degrees, difference, exp, floor, log, log10, pi, power, radians, sign, sin, sinh, sqrt, square, tan, tanh
charindex, leftstr, ltrim, padc, padl, padr, proper, replace, replicate, reverse, rightstr, rtrim, strfilter, trim
stdev, variance, mode, median, lower_quartile, upper_quartile
1 2 3 4 5 6 7 | library(DBI)
db <- RSQLite::datasetsDb()
RSQLite::initExtension(db)
dbGetQuery(db, "SELECT stdev(mpg) FROM mtcars")
sd(mtcars$mpg)
dbDisconnect(db)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.