Software Alternatives, Accelerators & Startups
Register | Login

PostGIS VS MySQL

Compare PostGIS VS MySQL and see what are their differences

LiveSession
LiveSession helps you analyze users’ behavior, improve UX, find JS bugs, and increase conversion rates using session replays, and event-based product analytics. featured
Contents:
  1. » Base Details
  2. » Videos
  3. » Reviews
  4. » Alternatives

PostGIS logo PostGIS

Open source spatial database

MySQL logo MySQL

The world's most popular open source database
  • PostGIS Landing page
    Landing page //
    2021-12-18
  • MySQL Landing page
    Landing page //
    2022-06-17

PostGIS videos

+ Add

Como Instalar o PostgreSQL com PostGIS | ALL com GEO

More videos:

  • Review - Paul Ramsey: This Is PostGIS
  • Review - A New Dimension To PostGIS : 3D

MySQL videos

+ Add

MySQL IN 10 MINUTES (2020) | Introduction to Databases, SQL, & MySQL

More videos:

  • Review - A Review of MySQL Open Source Software

Category Popularity

0-100% (relative to PostGIS and MySQL)

PostGIS

MySQL

Maps
100 100%
Maps
0% 0
Databases
6 6%
Databases
94% 94
Database Tools
100 100%
Database Tools
0% 0
Relational Databases
0 0%
Relational Databases
100% 100

User comments

Share your experience with using PostGIS and MySQL. For example, how are they different and which one is better?
Log in or Post with

Reviews

These are some of the external sources and on-site user reviews we've used to compare PostGIS and MySQL

PostGIS Reviews

The Top 10 Alternatives to ArcGIS
For those in the engineering and GIS community, PostGIS is a well-known open source extension for the PostgreSQL database that allows for spatial data to be stored, managed, and queried. The software enables users to conduct complex geospatial analyses and – because it is built on top of the powerful open-source database PostgreSQL – it can handle large datasets with ease....
Source: equatorstudios.com

MySQL Reviews

MariaDB Vs MySQL In 2019: Compatibility, Performance, And Syntax
MySQL: MySQL is an open-source relational database management system (RDBMS). Just like all other relational databases, MySQL uses tables, constraints, triggers, roles, stored procedures and views as the core components that you work with. A table consists of rows, and each row contains a same set of columns. MySQL uses primary keys to uniquely identify each row (a.k.a...
Source: blog.panoply.io
20+ MongoDB Alternatives You Should Know About
MySQL® is another feasible replacement. MySQL 5.7 and MySQL 8 have great support for JSON, and it continues to get better with every maintenance release. You can also consider MySQL Cluster for medium size sharded environments. You can also consider MariaDB and Percona Server for MySQL
Source: www.percona.com

Social recommendations and mentions

Based on our record, MySQL should be more popular than PostGIS. It has been mentiond 4 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

PostGIS mentions (1)

  • Efficient Distance Querying in MySQL
    This is an interesting article about strategies to use when traditional indexes just won't do, but for the love of the index please use MySQL's (or postgres' or sqlite's) built in spatial index for this particular class of problems. It will does this sort of thing much, much more efficiently than 99% of in house solutions. https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html... - Source: Hacker News / over 2 years ago

MySQL mentions (4)

  • I have a recurring issue with a MySQL DB where I continually run out of disk space due to logs being filled. I've tried everything I can think of. Can anyone think of anything else I should try?
    So, I did a quick read through the mysql reference and found a bunch of flush related commands. I tried:. Source: about 1 year ago
  • MMORPG design resources
    MySQL: Any SQL or DB knock-off, really... mysql.com - mariadb.org - sqlite.org. Source: over 1 year ago
  • Probably a syntax error
    15 years and five strokes ago. I was a Unix sysadmin. ALthough I was never an actual programmer, I did maintenance/light enhancement for the organization's website, in php. Now, as self-administered cognative therapy, I'm going back to it. This is an evil HR application that uses the mysql.com employees sample database. The module below enables the evil HR end user to generate a list of the oldest workers so... Source: almost 3 years ago
  • An absolute nightmare with mysql 8.0.25
    I always use the packages from mysql.com, that way I don't have to deal with strange configuration stuff along those lines, but anyway, I'm afraid I'm out of ideas. Surely someone else would have run in to the same issue here though. Source: about 3 years ago

What are some alternatives?

When comparing PostGIS and MySQL, you can also consider the following products

Slick - A jquery plugin for creating slideshows and carousels into your webpage.

PostgreSQL - PostgreSQL is a powerful, open source object-relational database system.

Sequel Pro - MySQL database management for Mac OS X

Microsoft SQL - Microsoft SQL is a best in class relational database management software that facilitates the database server to provide you a primary function to store and retrieve data.

DataGrip - Tool for SQL and databases

MongoDB - MongoDB (from "humongous") is a scalable, high-performance NoSQL database.

Loading...