The Jekyll SQLite plugin allows users to replace data files with SQLite databases as a data source, making it easy to create APIs and websites. It supports various types of queries and prepared queries with parameter binding. A demo website is available for reference, showcasing how to define data sources and use data attributes. Users can also generate data within each page or automatically generate files for each page using the datapage_gen plugin. Bug reports and pull requests are welcome on GitHub, but note that only maintained versions of Jekyll and Ruby are supported.
https://github.com/captn3m0/jekyll-sqlite