Need advice about which tool to choose?Ask the StackShare community!
Add tool
pgcli vs PgHero: What are the differences?
pgcli: Postgres CLI with autocompletion and syntax highlighting. This is a postgres client that does auto-completion and syntax highlighting; PgHero: 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.
pgcli and PgHero can be categorized as "Database" tools.
Some of the features offered by pgcli are:
- Auto-completion as you type for SQL keywords as well as tables and columns in the database.
- Syntax highlighting using Pygments.
- Smart-completion (enabled by default) will suggest context-sensitive completion.
On the other hand, PgHero provides the following key features:
- Live query stats
- Available as a ruby gems
- System stats for Amazon RDS
pgcli and PgHero are both open source tools. It seems that pgcli with 8.01K GitHub stars and 365 forks on GitHub has more adoption than PgHero with 4.78K GitHub stars and 244 GitHub forks.
Get Advice from developers at your company using StackShare Enterprise. Sign up for StackShare Enterprise.
Learn MoreWhat is pgcli?
This is a postgres client that does auto-completion and syntax highlighting.
What is PgHero?
Postgres performance insights made easy.
Need advice about which tool to choose?Ask the StackShare community!
What companies use pgcli?
What companies use PgHero?
What companies use pgcli?
No companies found
What companies use PgHero?
See which teams inside your own company are using pgcli or PgHero.
Sign up for StackShare EnterpriseLearn MoreSign up to get full access to all the companiesMake informed product decisions
What tools integrate with pgcli?
What tools integrate with PgHero?
What tools integrate with pgcli?
What tools integrate with PgHero?
What are some alternatives to pgcli and PgHero?
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
DataGrip
A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.
DBeaver
It is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc.
Microsoft SQL Server Management Studio
It is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. It provides tools to configure, monitor, and administer instances of SQL Server and databases. Use it to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.