3 ms·
I haven't looked into this in detail but I'm excited for this. A company I used to work with had a tool a lot like this and it was very useful as it allowed us
by leros 4y ago
I haven't looked into this in detail but I'm excited for this. A company I used to work with had a tool a lot like this and it was very useful as it allowed us to build dashboards that could pull data from anything or join/transform data through code. Very very handy.
One thing I found annoying about our internal tool is I often found myself duplicating boilerplate code for simple things. Like, initialize a MySQL connection, run a query, and render it with a graphing library. I don't know what your tool does, but it would be nice if it had the ability to insert a "SQL query line graph" rather than making me write those 10 lines of python.
- pea 4y agoThanks for the feedback. Regarding creating plots from SQL, we were just talking about that internally. It's a really interesting idea and something we have used ourselves in django-sql-explorer (https://django-sql-explorer.readthedocs.io/en/latest/features.html#displaying-query-results-as-charts https://django-sql-explorer.readthedocs.io/en/latest/feature...) We have a set of components (https://github.com/datapane/components https://github.com/datapane/components) and can look at something for autoplotting from a query. Similarly, we recently built a component to automatically create vega-lite plots from datasets using ChatGPT, which is another approach that works well (if interested, I can write up as a blogpost).