PgHero vs pgweb: What are the differences?
Developers describe PgHero as "Rails database insights made easy. Add the gem, get a dashboard with long running queries, cache hit rate, and more". Postgres performance insights made easy. On the other hand, pgweb is detailed as "Web-based PostgreSQL database browser written in Go". This is a web-based browser for PostgreSQL database server. Its written in Go and works on Mac OSX, Linux and Windows machines. Main idea behind using Go for the backend is to utilize language's ability for cross-compile source code for multiple platforms. This project is an attempt to create a very simple and portable application to work with PostgreSQL databases.
PgHero and pgweb can be categorized as "Database" tools.
Some of the features offered by PgHero are:
- Live query stats
- Available as a ruby gems
- System stats for Amazon RDS
On the other hand, pgweb provides the following key features:
- Connect to local or remote server
- Browse tables and table rows
- Get table details: structure, size, indices, row count
PgHero and pgweb are both open source tools. It seems that pgweb with 5.94K GitHub stars and 419 forks on GitHub has more adoption than PgHero with 4.78K GitHub stars and 244 GitHub forks.