Robotap

Reports and dashboards from definitions, not code. Point it at a database, a folder of CSV or Parquet files or a web API; write a query, a report and a page of plain HTML; get an interactive report.

• A project is a folder of JSON and HTML. A change shows on the next reload.
• CSV and Parquet are queried with SQL inside the server: no database to host.
• The same data is also JSON and CSV for other programs, under the same access rules.

The name is short for roodborsttapuit, the Dutch name of the stonechat: the small bird of the icon.

Try a report

• A music storeSales by country, month and genre from a SQL database: click a country, a genre or an artist and everything follows.
• A zoomable sunburstThe same store as a d3 visual that lives in one module of the project: nothing of the framework changed.
• A choropleth mapThe countries of the world, coloured by what the music store sold in each: the shapes are a GeoJSON file and the revenue is joined to them like any other data.
• Lines with notesFive genres over the years, with a line, a region, a level and an arrow pointing at the chart: the lines, their colours and the notes are three datasets.
• Expenses from a CSV fileA plain file, queried with SQL by DuckDB, with a form to choose the country and the number of rows.
• ChartsLines, bars, areas and dots from the same few datasets.
• Master and detailPick a row in one table and the table next to it follows.
• TablesSorting, searching, paging and cells that show a badge, a bar, a link or a picture.
• Trains near meAsks your browser for a position, finds the nearest station from a web API and shows its departures on a map.
• The documentationThe guides, read by a report from a folder of files.

More

See also reports embedded in a plain HTML page and the same data as CSV.