Metabase Redash

by



  • Redash helps you make sense of your data. Connect and query your data sources, build dashboards to visualize data and share them with your company. Metabase and Redash can be primarily classified as 'Business Intelligence' tools. Metabase and Redash are.
  • What is Metabase? It is an easy way to generate charts and dashboards, ask simple ad hoc queries without using SQL, and see detailed information about rows in your Database. You can set it up in under 5 minutes, and then give yourself and others a place to ask simple questions and understand the data your application is generating.
  1. Metabase Dash
  2. Metabase Dashboard Tutorial

Super impressed with @metabase! We are using it internally for a dashboard and it really offers a great combination of ease of use, flexibility, and speed. Paavo Niskala (@Paavi) December 17, 2019. @metabase is the most impressive piece of software I’ve used in a long time. If you have data you want to understand give it a try.

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.

pgAdmin

  • Home Page: https://www.pgadmin.org
  • Type: Browser-based desktop GUI
Redash vs metabase

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.

Metabase

pgweb

  • Home Page: http://sosedoff.github.io/pgweb/
  • Type: Single-binary Go-based web server
Metabase dashboard filter

Metabase Dash

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

Metabase Dashboard Tutorial

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
Kibana

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.

Metabase

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.

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. Learn morehere or signup todayfor a free trial.