Re:Idyll Language – Author interactive narratives for the web
by garyclarke27 on Saturday January 06, 2018 @03:56AM
(#16084474)
Agreed ‘out of the box’ sql data source (postgres for me) would be a killer feature to add.
SQL is just text, but amazingly powerful and a million times more useful than a file reference.
Re:Idyll Language – Author interactive narratives for the web
by mathisonian on Saturday January 06, 2018 @05:48PM
(#16087921)
Agreed that this would be really nice to have! We are working on a compile-time plugin system, so it should be possible to setup something the executes embedded SQL at compile time to allow generation of more dynamic documents.
Frequently I'll have a data set (list of transactions over time, log of analytics events to a site, etc.) that I want to visualize. It usually involves slicing the data in multiple ways with a handful of queries.
It'd be really cool if I could load up a CSV file / SQLite database per document and embed charts that visualize queries on that data. The goal would be to keep the data, visualizations, and text as close together as possible.
Short of this feature being available, I can only do something like:
- write some SQLite queries
- write a quick script to run each query, and save the results to a file (CSV/JSON)
- reference each individual file from the Idyll document
Again, really cool project!