pgcenter vs pgweb

pgcenter

Command-line admin tool for observing and troubleshooting Postgres. (by lesovsky)

Source Code

Suggest alternative

Edit details

pgweb

Cross-platform client for PostgreSQL databases (by sosedoff)

Database Postgresql Golang Pgweb Cross-Platform

Source Code

sosedoff.github.io

Suggest alternative

Edit details

Our great sponsors

WorkOS - The modern identity platform for B2B SaaS

InfluxDB - Power Real-Time Data Analytics at Scale

SaaSHub - Software Alternatives and Reviews

Our great sponsors

pgcenter		pgweb
	Project
2	Mentions	4
1,509	Stars	8,282
-	Growth	-
0.0	Activity	7.2
about 1 year ago	Latest Commit	8 days ago
Go	Language	Go
GNU General Public License v3.0 or later	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

pgcenter

Posts with mentions or reviews of pgcenter. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-12-18.

PostgreSQL 16 Bi-Directional Logical Replication
5 projects | news.ycombinator.com | 18 Dec 2023

https://github.com/lesovsky/pgcenter#postgresql-statistics
...
"Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps" (2023) from the creators of CRDTs https://news.ycombinator.com/item?id=37590257
electric-sql/electric:
How can I check the load of the PostgreSQL container?
3 projects | /r/PostgreSQL | 24 Jun 2021

pgmetrics will not tell you anything about the load in your database and container. It is more about the details of the internal structure of the database. You can try the pgcenter tool. https://github.com/lesovsky/pgcenter

pgweb

Posts with mentions or reviews of pgweb. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-12-12.

Ask HN: What apps have you created for your own use?
212 projects | news.ycombinator.com | 12 Dec 2023

Built Pgweb (Postgres GUI) some time ago since I could not find a good minimalistic database explorer.
https://github.com/sosedoff/pgweb
The app is super simple, made with Go + jQuery and I still use it almost every day, and has brought it to every single company I've been with.
Slashbase: A modern in-browser database IDE & CLI for your dev & data workflows. Supports PostgreSQL & MongoDB.
2 projects | /r/programming | 4 Jan 2023
Slashbase: The open-source in-browser database IDE & CLI for your dev/data workflows written in Golang. Supports: PostgreSQL & MongoDB.
2 projects | /r/golang | 24 Dec 2022
A nice front end for reading mysql or postgres data?
1 project | /r/selfhosted | 17 Oct 2021

For postgresql, pgweb is perfect.

What are some alternatives?

When comparing pgcenter and pgweb you can also consider the following projects:

pg_activity - pg_activity is a top like application for PostgreSQL server activity monitoring.

rqlite - The lightweight, distributed relational database built on SQLite.

Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.

Dotsql - A Golang library for using SQL.

go-pg - Golang ORM with focus on PostgreSQL features and performance

cockroach - CockroachDB - the open source, cloud-native distributed SQL database.

sqlc - Generate type-safe code from SQL

tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial

electric - Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.

sqlhooks - Attach hooks to any database/sql driver

cloudnative-pg - CloudNativePG is a comprehensive platform designed to seamlessly manage PostgreSQL databases within Kubernetes environments, covering the entire operational lifecycle from initial deployment to ongoing maintenance

InfluxDB - Scalable datastore for metrics, events, and real-time analytics