Need advice about which tool to choose?Ask the StackShare community!

PgHero

9
32
+ 1
0
PostGIS

330
336
+ 1
30
Add tool

PgHero vs PostGIS: What are the differences?

What is 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.

What is PostGIS? Open source spatial database. PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.

PgHero and PostGIS 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, PostGIS provides the following key features:

  • Processing and analytic functions for both vector and raster data for splicing, dicing, morphing, reclassifying, and collecting/unioning with the power of SQL
  • raster map algebra for fine-grained raster processing
  • Spatial reprojection SQL callable functions for both vector and raster data

PgHero and PostGIS are both open source tools. PgHero with 4.78K GitHub stars and 244 forks on GitHub appears to be more popular than PostGIS with 645 GitHub stars and 246 GitHub forks.

Get Advice from developers at your company using Private StackShare. Sign up for Private StackShare.
Learn More
Pros of PgHero
Pros of PostGIS
    Be the first to leave a pro
    • 25
      De facto GIS in SQL
    • 5
      Good Documentation

    Sign up to add or upvote prosMake informed product decisions

    What is PgHero?

    Postgres performance insights made easy.

    What is PostGIS?

    PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.

    Need advice about which tool to choose?Ask the StackShare community!

    Jobs that mention PgHero and PostGIS as a desired skillset
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US
    Pinterest
    San Francisco, CA, US; Palo Alto, CA, US
    CBRE
    Narva, Ida-Virumaa, Estonia
    What companies use PgHero?
    What companies use PostGIS?
    See which teams inside your own company are using PgHero or PostGIS.
    Sign up for Private StackShareLearn More

    Sign up to get full access to all the companiesMake informed product decisions

    What tools integrate with PgHero?
    What tools integrate with PostGIS?

    Blog Posts

    JavaScriptGitHubNode.js+26
    19
    4719
    What are some alternatives to PgHero and PostGIS?
    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.
    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.
    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.
    See all alternatives