database-visualizer-tool

This repo demonstrate how to use graphana to easily create dashboard in graphana from data in postgres without redeveloping dashboard UI using angular/react etc

Go to the below blog for detailed instructions on how to setup the docker compose in this repo and create plots in Graphana https://machinelearninglab.blogspot.com/2023/02/setup-open-source-dashboard-for-machine.html

importing data to postgres

1. run create table
2. import csv using pgadmin
3. run alter table

Reference

Postgres

• https://www.postgresqltutorial.com/postgresql-tutorial/import-csv-file-into-posgresql-table/

Graphana

• Embedd graphana as iframe inline frame in the browser https://grafana.com/docs/grafana/latest/dashboards/share-dashboards-panels/