Over the years, the PostgreSQL community has come up with many high-qualityopen-source GUI tools for manipulating, visualizing and sharing the data livingin Postgres servers. Here is a round up of various types of useful GUI toolsthat can help you and your team manage and share your data.
MetabaseもRedashと同じく、オープンソースで提供されているダッシュボード作成ツールです。 MetabaseもRedashと同じように、簡単に使うことができます。 ①必要なファイルをイ. Metabase - An open-source business intelligence tool. Periscope - Periscope plugs directly into your database and lets you run, save and share analyses over billions of data rows in seconds. Redash - Easily query an existing database, share the dataset and visualize it in different ways. Oct 11, 2017 Metabase is more polished and easier for business folks. But redash supports more data sources (hive for instance). Both are open source and in my opinion can fill about 80% of dashboards and ad hoc analysis for a small to medium company. The other 20% your company must be rich enough to buy Tableau or rich enough to build its own solution.
pgAdmin
- Home Page: https://www.pgadmin.org
- Type: Browser-based desktop GUI
pgAdmin is the venerable quasi-official feature-rich GUI for PostgreSQL. It letsyou run queries as well as explore and examine every bit of your server anddatabases.
OmniDB
- Home Page: https://omnidb.org/index.php/en/
- Type: Browser-based desktop GUI
OmniDB also lets you run queries and explore and edit database objects. It alsosupports servers other than Postgres, including MySQL and Oracle. Supportsdebugging of user-defined functions (stored functions) written in PL/pgSQL.
DBeaver
- Home Page: https://dbeaver.io/
- Type: Java/Eclipse-based Desktop GUI
DBeaver is similar to pgAdmin and OmniDB, with support for more RDBMS servers.Can generate ER diagrams from the schema automatically.
pgweb
- Home Page: http://sosedoff.github.io/pgweb/
- Type: Single-binary Go-based web server
pgweb is a simple, easy-to-deploy tool that runs as a web server. You can viewdata, run queries and examine tables and indexes.
Metabase
- Home Page: https://www.metabase.com/
- Type: BI tool, server install
Metabase is a business intelligence tool, that can help your team setup, runand visualize queries. Knowledge of SQL is optional. Supports RDBMS (and datasources) other than PostgreSQL also.
Redash
- Home Page: https://redash.io/
- Type: BI tool, server install
Redash is also a business intelligence tool for teams, with a more hands-onapproach. It lets you write SQL queries directly and setup visualizationsand dashboard with more options and customizations.
Blazer
- Home Page: https://github.com/ankane/blazer
- Type: Basic BI queries, dashboards; server install
Blazer is a Ruby-on-Rails gem that let’s users define queries, visualizationsand dashboards, and share them with their team. You’ll need to know your wayaround RoR to make use of this.
Apache Superset
- Home Page: https://superset.incubator.apache.org/
- Type: BI tool, server install, Python-based
Apache Superset is an incubating (pre-release) BI tool of the Apache SoftwareFoundation. It has a rich set of visualizationsand support for many data sources.
Apache Zeppelin
- Home Page: https://zeppelin.apache.org/
- Type: Notebook, server install, Java-based
Zeppelin is a web-based notebook (like Jupyter for Python) from the ApacheSoftware Foundation. It lets you interactive explore the data from many sources(including PostgreSQL of course) with visualizations.
franchise
- Home Page: https://franchise.cloud/
- Type: Notebook, Online
Franchise is a web-based notebook that can connect to your local database usinga bridge tool, thus requiring no server installation. Supports data sources likeMySQL and BigQuery also.
More.
You can find even more links on the PostgreSQL Wiki,including commercial software, tools for ER diagrams, IDEs and more.
About pgDash
pgDash is a modern, in-depth monitoring solution designedspecifically for PostgreSQL deployments. pgDash shows you information andmetrics about every aspect of your PostgreSQL database server, collected usingthe open-source tool pgmetrics.pgDash provides core reporting and visualizationfunctionality, including collecting and displaying PostgreSQL information andproviding time-series graphs, detailed reports, alerting, teams and more.
Redash Vs
The Diagnostics feature in pgDash examines your PostgreSQL server and databasesscanning for potential issues that can impact the health and performance of thedeployment. No additional setup is required for Diagnostics - you just need tobe actively sending in data to pgDash. Control s for mac. Learn morehere or signup todayfor a free trial.