Hey all,
We've been working on a fairly major upgrade of the SQLite.jl package over
the last few months and are happy to announce a new release. This is a
breaking change with the most recent tagged version in METADATA, so if you
wish to stay on the old API version, just run `Pkg.pin("SQLite")`.
Otherwise, to see the updates, you can simply run `Pkg.update()` if the
`SQLite.jl` package is already installed, or run `Pkg.add("SQLite")` to
install the package for the first time.
The newer package boasts some great updates including a more Julian
interface (the older package was modeled after the sqldf R package), the
removal of DataFrames dependency making the package much more lightweight,
but still easy to feed the new `SQLite.ResultSet` type into a DataFrame;
there are also some awesome features allowing the use of custom julia
scalar and aggregate functions in SQL statements by registering the julia
function. Usage of custom Julia types is also supported for storing and
loading in SQL tables (using the serialization interface).
We've tried to put in many more tests and push the docs further along, but
are of course always looking to improve.
For those unfamiliar, SQLite is a lightweight, relational database system
easy to run on a local machine. It's extremely handy for working with
medium to large datasets that still fit on a single machine (MBs to GBs).
It supports SQL statements to create, update, and delete relational tables,
as well as select statements to perform calculations, or subset specific
datasets.
-Jacob Quinn and Sean Marshallsay
