Microsoft SQL Server vs PostGIS

Get Advice Icon

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

Microsoft SQL Server
Microsoft SQL Server

3.9K
2.8K
+ 1
525
PostGIS
PostGIS

188
138
+ 1
28
Add tool

Microsoft SQL Server vs PostGIS: What are the differences?

Microsoft SQL Server: A relational database management system developed by Microsoft. Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions; 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.

Microsoft SQL Server belongs to "Databases" category of the tech stack, while PostGIS can be primarily classified under "Database Tools".

"Reliable and easy to use" is the primary reason why developers consider Microsoft SQL Server over the competitors, whereas "De facto GIS in SQL" was stated as the key factor in picking PostGIS.

PostGIS is an open source tool with 636 GitHub stars and 242 GitHub forks. Here's a link to PostGIS's open source repository on GitHub.

According to the StackShare community, Microsoft SQL Server has a broader approval, being mentioned in 470 company stacks & 425 developers stacks; compared to PostGIS, which is listed in 53 company stacks and 14 developer stacks.

- No public GitHub repository available -

What is Microsoft SQL Server?

Microsoft® SQL Server is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions.

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.
Get Advice Icon

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

Why do developers choose Microsoft SQL Server?
Why do developers choose PostGIS?

Sign up to add, upvote and see more prosMake informed product decisions

    Be the first to leave a con
    What companies use Microsoft SQL Server?
    What companies use PostGIS?

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

    What tools integrate with Microsoft SQL Server?
    What tools integrate with PostGIS?

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Microsoft SQL Server and PostGIS?
    Oracle
    Oracle Database is an RDBMS. An RDBMS that implements object-oriented features such as user-defined types, inheritance, and polymorphism is called an object-relational database management system (ORDBMS). Oracle Database has extended the relational model to an object-relational model, making it possible to store complex business models in a relational database.
    Apache Aurora
    Apache Aurora is a service scheduler that runs on top of Mesos, enabling you to run long-running services that take advantage of Mesos' scalability, fault-tolerance, and resource isolation.
    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.
    Microsoft Access
    It is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, it can help you create appealing and highly functional applications in a minimal amount of time.
    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.
    See all alternatives
    Decisions about Microsoft SQL Server and PostGIS
    AWS Elastic Beanstalk
    AWS Elastic Beanstalk
    Heroku
    Heroku
    Ruby
    Ruby
    Rails
    Rails
    Amazon RDS for PostgreSQL
    Amazon RDS for PostgreSQL
    MariaDB
    MariaDB
    Microsoft SQL Server
    Microsoft SQL Server
    Amazon RDS
    Amazon RDS
    AWS Lambda
    AWS Lambda
    Python
    Python
    Redis
    Redis
    Memcached
    Memcached
    AWS Elastic Load Balancing (ELB)
    AWS Elastic Load Balancing (ELB)
    Amazon Elasticsearch Service
    Amazon Elasticsearch Service
    Amazon ElastiCache
    Amazon ElastiCache

    We initially started out with Heroku as our PaaS provider due to a desire to use it by our original developer for our Ruby on Rails application/website at the time. We were finding response times slow, it was painfully slow, sometimes taking 10 seconds to start loading the main page. Moving up to the next "compute" level was going to be very expensive.

    We moved our site over to AWS Elastic Beanstalk , not only did response times on the site practically become instant, our cloud bill for the application was cut in half.

    In database world we are currently using Amazon RDS for PostgreSQL also, we have both MariaDB and Microsoft SQL Server both hosted on Amazon RDS. The plan is to migrate to AWS Aurora Serverless for all 3 of those database systems.

    Additional services we use for our public applications: AWS Lambda, Python, Redis, Memcached, AWS Elastic Load Balancing (ELB), Amazon Elasticsearch Service, Amazon ElastiCache

    See more
    Interest over time
    Reviews of Microsoft SQL Server and PostGIS
    No reviews found
    How developers use Microsoft SQL Server and PostGIS
    Avatar of Brillium, Inc.
    Brillium, Inc. uses Microsoft SQL ServerMicrosoft SQL Server

    We've always counted on SQL Server as our database backend. It has served us well over the years. It isn't the cheapest part of our stack, but with the plethora of tools provided by 3rd parties, we have found an incredible and scalable method of keeping our data available and easy to maintain.

    Avatar of Andrew Miller
    Andrew Miller uses Microsoft SQL ServerMicrosoft SQL Server

    Defacto, industry standard for backend relational databases. Entity Framework makes designing, migrating & maintaining SQL Server databases a breeze. LocalDB is especially helpful during development.

    Avatar of David Flynn
    David Flynn uses Microsoft SQL ServerMicrosoft SQL Server

    Our core systems that we integrate with are using SQL Server 2012 / 2016 database servers. We use database views on core system databases to help build our domain model.

    Avatar of Olo
    Olo uses Microsoft SQL ServerMicrosoft SQL Server

    Main transactional database. SQL Server 2012 Enterprise with AlwaysOn Availability Groups for high availability and disaster recovery.

    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 Arbor Health, LLC
    Arbor Health, LLC uses Microsoft SQL ServerMicrosoft SQL Server

    Managing script output and input, as well as data cleansing.

    Avatar of Mathias Vonende
    Mathias Vonende uses PostGISPostGIS

    Storage for geo data.

    Avatar of DNT
    DNT uses PostGISPostGIS

    Geospatial queries

    How much does Microsoft SQL Server cost?
    How much does PostGIS cost?
    Pricing unavailable
    Pricing unavailable
    News about PostGIS
    More news