Jekyll let’s you use CSV/YAML/JSON files as data source, but they’re unwieldy since the schema is fixed.
The plugin is meant to let you reshape your data before you use it within Jekyll. You get complete flexibility of SQLite, to let you join tables, use indexes etc.
What I can’t figure out is how to best do “dynamic” queries, say a query that needs to show the number of reviews on the restaurant page (restaurants is the table). Each of these page will need to run a dynamic query with the page.id variable.
SQLite Injection isn’t a big issue, since this is all trusted input. But I’d like something better than just Templating queries using liquid.
I’m doing some parameterized queries on the global level (see README). Need to find a nice way to do them locally.
Maybe just putting them in metadata would be a good way?
Jekyll let’s you use CSV/YAML/JSON files as data source, but they’re unwieldy since the schema is fixed.
The plugin is meant to let you reshape your data before you use it within Jekyll. You get complete flexibility of SQLite, to let you join tables, use indexes etc.
What I can’t figure out is how to best do “dynamic” queries, say a query that needs to show the number of reviews on the restaurant page (restaurants is the table). Each of these page will need to run a dynamic query with the page.id variable.
SQLite Injection isn’t a big issue, since this is all trusted input. But I’d like something better than just Templating queries using liquid.
I’m doing some parameterized queries on the global level (see README). Need to find a nice way to do them locally.
Maybe just putting them in metadata would be a good way?