A Jekyll generator plugin to lets you use SQLite databases instead of Data Files as a data source. It lets you easily create APIs and websites from a SQLite database, by linking together a database file, your template, and the relevant queries.

Jekyll’s Data Files are great, but they are limited to YAML/JSON/TSV/CSV file formats - this plugin gives you another option: SQLite databases.

It supports site-level queries, per-page queries, and prepared queries that can use existing data (possibly generated via more queries) as parameters.

The primary usecase is to avoid Liquid Hell, wherein you’re left mangling multiple data sources from CSV/JSON/YAML files using liquid templating by saving temporary variables, creating maps, and so on. SQL is a decent language for reshaping datasets - supporting joins, filters, and aggregations. So this allows you to use SQL for reshaping your data, and then use liquid for what it was meant for - presentation and templating.