Home

The motivation for this extension library grew out of my continued usage of SQLite at work. On many occasions I needed to calculate a histogram or the ratio of histogram bins. Although this can be accomplished using other programming languages or tools such a R, Matlab or Mathematica I decided that it would be simpler to have these functionalities readily available from SQLite. Prior to writing this library I would implement histograms directly with SQL syntax typically spanning 20 lines or more.

The functionality of the extension library and some of the graphs featuring as examples here were used in these publications:

https://doi.org/10.1073/pnas.1701640114

https://doi.org/10.1107/s2059798318004357