Show HN: SQLite Plugin for Jekyll https://ift.tt/uJdkcW9

Show HN: SQLite Plugin for Jekyll I love Jekyll, especially the Datafiles[0] feature, which lets you use CSV/JSON/YAML files and iterate through them. Mixed with the Jekyll Data Pages generator[1], which lets you create a page for every row in your dataset, it is a very powerful combination. However, Liquid is a terrible language for data-mangling, and simple filtering/sorting/merging can become very annoying. So I wrote a Jekyll SQLite plugin that lets you use the same data interface in Jekyll/Liquid, but backed by a SQLite file(s). It gives you the simplicity of the Baked Data pattern[2], and the flexibility of using SQL for data-wrangling, within a static site generator. As a demo, I took the northwind dataset, and generated a site[3] with a few sample queries[4]. It demos both site-level, and page-level queries alongside data-pages generator to generate a page for every product/category/customer. I've been using this across a few sites in production for almost a year, looking for feedback on usage semantics and feature suggestions. [0]: https://ift.tt/AjmD2Ks [1]: https://ift.tt/1Ercgvh [2]: https://ift.tt/daypx1u [3]: https://ift.tt/hepKNty [4]: https://ift.tt/PZcBWkm https://ift.tt/fm40aDR November 26, 2024 at 01:11PM