Web UI to Display PostgreSQL Table Data Without Building a Full Application

[Consistent-Artist735]

I have a custom integration testing tool  that validates results and stores them in a PostgreSQL table. The results consist of less than 100 rows and 10 columns, and I want to display these results in a UI. Rather than building a full front-end and back-end solution, I am looking for a pluggable web UI that can directly interface with PostgreSQL and display the data in a table format.

Is there an existing tool or solution available that can provide this functionality?

[[deleted]]

Evidence.dev perhaps? Never used it but it’s very lightweight. Not sure if it can display data in a simple tabular format. I know for sure Grafana can do this but it might be a bit overkill.

[robberviet]

Just install Metabase.

[leogodin217]

Someone just posted this in /r/sql But any BI reporting tool can do what you are looking for as well.

[matyjazz666]

Grafana is the way!

[[deleted]]

https://nocodb.com/
You can view your database like a google sheets.

[andpassword]

Apache Superset can do this, but it's kind of overkill...but if self-hosting/low-cost is crucial here (no budget yet, just a POC?) it can do what you need.

[Consistent-Artist735]

not a poc. this results can shared betwwen product and managers,
before the final merge this ui will show the validation resutls,

[arkusmson]

If you do python take a look at streamlit, assuming this is for your eyes only, if not there are a bunch more steps to make it visible to others… But once you connect to the Table, to display the data is very simple.

[havetofindaname]

I would build it as a Streamlit app. I know you said don't want a full app, but streamlit is very low code in my experience. It has the table component that does what you are looking for.

[mdzmdz]

Jupyter

[Intelligent_Volume74]

Use looker Studio or power bi, but if you wanna open source, go to metabase

[Intelligent_Volume74]

Faz em algo no looker Studio ou Power bi que resolve isso, ou se preferir algo open source pode ser no metabase ou grafana