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

Liquibase

445
648
+ 1
70
PostGIS

381
377
+ 1
30
Add tool

Liquibase vs PostGIS: What are the differences?

Developers describe Liquibase as "Source control for your database". Developers store database changes in text-based files on their local development machines and apply them to their local databases. Changelog files can be be arbitrarily nested for better management. On the other hand, PostGIS is detailed 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.

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

Some of the features offered by Liquibase are:

  • Supports code branching and merging
  • Supports multiple developers
  • Supports multiple database types

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

"Great database tool" is the primary reason why developers consider Liquibase over the competitors, whereas "De facto GIS in SQL" was stated as the key factor in picking PostGIS.

Liquibase and PostGIS are both open source tools. It seems that Liquibase with 1.78K GitHub stars and 1.08K forks on GitHub has more adoption than PostGIS with 636 GitHub stars and 242 GitHub forks.

HotelTonight, Key Location, and DNT are some of the popular companies that use PostGIS, whereas Liquibase is used by Orbitz, Viadeo, and Virgin Pulse. PostGIS has a broader approval, being mentioned in 53 company stacks & 14 developers stacks; compared to Liquibase, which is listed in 15 company stacks and 12 developer stacks.

Manage your open source components, licenses, and vulnerabilities
Learn More
Pros of Liquibase
Pros of PostGIS
  • 18
    Great database tool
  • 18
    Many DBs supported
  • 12
    Easy setup
  • 8
    Database independent migration scripts
  • 5
    Unique open source tool
  • 5
    Database version controller
  • 2
    Precondition checking
  • 2
    Supports NoSQL and Graph DBs
  • 25
    De facto GIS in SQL
  • 5
    Good Documentation

Sign up to add or upvote prosMake informed product decisions

Cons of Liquibase
Cons of PostGIS
  • 5
    Documentation is disorganized
  • 5
    No vendor specifics in XML format - needs workarounds
    Be the first to leave a con

    Sign up to add or upvote consMake informed product decisions

    What is Liquibase?

    Liquibase is th leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process.

    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!

    What companies use Liquibase?
    What companies use PostGIS?
    Manage your open source components, licenses, and vulnerabilities
    Learn More

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

    What tools integrate with Liquibase?
    What tools integrate with PostGIS?

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

    Blog Posts

    JavaScriptGitHubNode.js+26
    20
    5174
    What are some alternatives to Liquibase and PostGIS?
    Flyway
    It lets you regain control of your database migrations with pleasure and plain sql. Solves only one problem and solves it well. It migrates your database, so you don't have to worry about it anymore.
    Hibernate
    Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
    Sqitch
    It is a standalone change management system with no opinions about your database engine, application framework, or development environment. Native scripting. Changes are implemented as scripts native to your selected database engine.
    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.
    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.
    See all alternatives