SQLite

• http://www.sqlite.org/contrib
  • extension-functions.c - Provide mathematical and string extension functions for SQL queries using the loadable extensions mechanism. (Aggregate: stdev, variance, mode, median, lower_quartile, upper_quartile.)
  • gcc -fPIC -lm -shared extension-functions.c -o libsqlitefunctions.so
  • SELECT load_extension('./libsqlitefunctions.so');