4 ms·

I did not, just had a quick glance at what was available. What is your use case and which plugins would you recommend? Providing some kind of bare bones report

I did not, just had a quick glance at what was available. What is your use case and which plugins would you recommend? Providing some kind of bare bones report/dashboard with the visualization plugin?

ocdtrekkie 4y ago
In my case, I log the GPS data from my car, but wanted a private way to explore that (obviously sensitive) data. https://datasette.io/plugins/datasette-cluster-map https://datasette.io/plugins/datasette-cluster-map is a really neat example of a "just works" plugin: If you have latitude and longitude columns, it will plot them! But there are numerous plugins for certain types of visualizations, there's a bunch for handling editing, inserts, uploads, etc. Some of the examples are pretty neat examples of what you can do with a bit of tuning: https://global-power-plants.datasettes.com/global-power-plants/global-power-plants https://global-power-plants.datasettes.com/global-power-plan... is pretty neat.
- masklinn 4y ago
  Will datasette automatically provide useful graph views of time series? Or is there a good plug-in of that? One thing I’m trying to get better at is resource tracking (mostly energy) but it’s pretty clunky using a spreadsheet (likely because I’m not super knowledgeable and really don’t care).
  - simonw 4y ago
    https://datasette.io/plugins/datasette-vega https://datasette.io/plugins/datasette-vega is the original visualization plugin, built on Vega. Example here: https://datasette.io/content/stats?_facet=package&package=datasette-vega&_size=max#g.mark=line&g.x_column=date&g.x_type=temporal&g.y_column=downloads&g.y_type=quantitative https://datasette.io/content/stats?_facet=package&package=da... I've been hoping to build a new one around Observable Plot for a while now. This plugin still requires you to pick what columns you would like to see plotted. Ideally I'd like it to take an informed guess based on the data and maybe offer you some thumbnails of suggested charts which you could then click to view larger.

ocdtrekkie 4y ago

In my case, I log the GPS data from my car, but wanted a private way to explore that (obviously sensitive) data. https://datasette.io/plugins/datasette-cluster-map https://datasette.io/plugins/datasette-cluster-map is a really neat example of a "just works" plugin: If you have latitude and longitude columns, it will plot them! But there are numerous plugins for certain types of visualizations, there's a bunch for handling editing, inserts, uploads, etc. Some of the examples are pretty neat examples of what you can do with a bit of tuning: https://global-power-plants.datasettes.com/global-power-plants/global-power-plants https://global-power-plants.datasettes.com/global-power-plan... is pretty neat.

masklinn 4y ago
Will datasette automatically provide useful graph views of time series? Or is there a good plug-in of that? One thing I’m trying to get better at is resource tracking (mostly energy) but it’s pretty clunky using a spreadsheet (likely because I’m not super knowledgeable and really don’t care).
- simonw 4y ago
  https://datasette.io/plugins/datasette-vega https://datasette.io/plugins/datasette-vega is the original visualization plugin, built on Vega. Example here: https://datasette.io/content/stats?_facet=package&package=datasette-vega&_size=max#g.mark=line&g.x_column=date&g.x_type=temporal&g.y_column=downloads&g.y_type=quantitative https://datasette.io/content/stats?_facet=package&package=da... I've been hoping to build a new one around Observable Plot for a while now. This plugin still requires you to pick what columns you would like to see plotted. Ideally I'd like it to take an informed guess based on the data and maybe offer you some thumbnails of suggested charts which you could then click to view larger.