Search code, repositories, users, issues, pull requests...

A Jekyll generator plugin to lets you use SQLite database 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.

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

🏁 A fully-functional demo website that uses this plugin is available at northwind.captnemo.in. The source code for the demo is available at captn3m0/northwind.

This plugin supports prepared queries with parameter binding. This lets you use existing data from a previous query, or some other source (such as site.data.* or page.*) as a parameter in your query.

The exact same syntax can be used on a per-page basis to generate data within each page. This is helpful for keeping page-specific queries within the page itself. Here's an example:

Leave a Comment