Get Advice Icon

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

PostGIS
PostGIS

194
143
+ 1
28
PostgREST
PostgREST

25
46
+ 1
2
Add tool

PostGIS vs PostgREST: What are the differences?

Developers describe PostGIS as "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. On the other hand, PostgREST is detailed as "Automatic REST API for Any Postgres Database". PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch.

PostGIS and PostgREST can be categorized as "Database" tools.

PostGIS and PostgREST are both open source tools. It seems that PostgREST with 12.5K GitHub stars and 585 forks on GitHub has more adoption than PostGIS with 645 GitHub stars and 246 GitHub forks.

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.

What is PostgREST?

PostgREST serves a fully RESTful API from any existing PostgreSQL database. It provides a cleaner, more standards-compliant, faster API than you are likely to write from scratch.
Get Advice Icon

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

Why do developers choose PostGIS?
Why do developers choose PostgREST?
    Be the first to leave a con
      Be the first to leave a con
      What companies use PostGIS?
      What companies use PostgREST?

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

      What tools integrate with PostGIS?
      What tools integrate with PostgREST?
        No integrations found
        What are some alternatives to PostGIS and PostgREST?
        MongoDB
        MongoDB stores data in JSON-like documents that can vary in structure, offering a dynamic, flexible schema. MongoDB was also designed for high availability and scalability, with built-in replication and auto-sharding.
        MySQL
        The MySQL software delivers a very fast, multi-threaded, multi-user, and robust SQL (Structured Query Language) database server. MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed software.
        Elasticsearch
        Elasticsearch is a distributed, RESTful search and analytics engine capable of storing data and searching it in near real time. Elasticsearch, Kibana, Beats and Logstash are the Elastic Stack (sometimes called the ELK Stack).
        PostgreSQL
        PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.
        ArcGIS
        It is a geographic information system for working with maps and geographic information. It is used for creating and using maps, compiling geographic data, analyzing mapped information, sharing and much more.
        See all alternatives
        Decisions about PostGIS and PostgREST
        No stack decisions found
        Interest over time
        Reviews of PostGIS and PostgREST
        No reviews found
        How developers use PostGIS and PostgREST
        Avatar of Kalibrr
        Kalibrr uses PostGISPostGIS

        PostGIS makes it easy (and fast) to do geographic queries, such as nearest-neighbor and bounding box queries.

        Avatar of Sail Tactics
        Sail Tactics uses PostGISPostGIS

        Backend for weather forecast data that Geoserver queries to build updated weather maps

        Avatar of Mathias Vonende
        Mathias Vonende uses PostGISPostGIS

        Storage for geo data.

        Avatar of AmperVue
        AmperVue uses PostgRESTPostgREST

        Production Database

        Avatar of DNT
        DNT uses PostGISPostGIS

        Geospatial queries

        How much does PostGIS cost?
        How much does PostgREST cost?
        Pricing unavailable
        Pricing unavailable
        News about PostGIS
        More news
        News about PostgREST
        More news