A SQLite Plugin for Jekyll

Over the last decade, I’ve made a bunch of sites using some mix of data/content. The most popular of these is endoflife.date, but there’s also hackercouch.com, mf.captnemo.in and a bunch more. My preferred stack for such projects is Jekyll, now with custom plugins since GitHub Pages now runs on GitHub Actions with custom plugins by default. Simon Wilson’s “Baked Data” pattern is something I’ve started identifying across my projects, where I’d often push my dataset as a CSV file, and render the website by using the data directly using Jekyll. Jekyll supports YAML, JSON, CSV, and TSV files by default, which makes your “baked data” quite inflexible - writing anything complex - say you want a page for “Berlin’s top rated restaurants”, would not look so nice in Liquid {% for r in site.data.restaurants | where:"rating>4"%} {% location = r.address | downcase %} {% if "berlin" in r.name %} <td>{{r.name}}</td> {% endif %} {% endfor %} If you want your pages to have any level of dynamism -…