Get Advice Icon

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

PostGIS
PostGIS

183
134
+ 1
28
SQLite
SQLite

3.3K
2.6K
+ 1
504
Add tool

PostGIS vs SQLite: What are the differences?

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; SQLite: A software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.

PostGIS and SQLite are primarily classified as "Database" and "Databases" tools respectively.

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

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, SQLite has a broader approval, being mentioned in 313 company stacks & 470 developers stacks; compared to PostGIS, which is listed in 53 company stacks and 14 developer stacks.

- No public GitHub repository available -

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 SQLite?

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
Get Advice Icon

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

Why do developers choose PostGIS?
Why do developers choose SQLite?

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

    Be the first to leave a con
    What companies use PostGIS?
    What companies use SQLite?

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

    What tools integrate with PostGIS?
    What tools integrate with SQLite?

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

    What are some alternatives to PostGIS and SQLite?
    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 SQLite
    Daniel Quinn
    Daniel Quinn
    Senior Developer at Workfinder · | 2 upvotes · 22.1K views
    atThe Paperless ProjectThe Paperless Project
    PostgreSQL
    PostgreSQL
    SQLite
    SQLite

    SQLite is a tricky beast. It's great if you're working single-threaded, but a Terrible Idea if you've got more than one concurrent connection. You use it because it's easy to setup, light, and portable (it's just a file).

    In Paperless, we've built a self-hosted web application, so it makes sense to standardise on something small & light, and as we don't have to worry about multiple connections (it's just you using the app), it's a perfect fit.

    For users wanting to scale Paperless up to a multi-user environment though, we do provide the hooks to switch to PostgreSQL .

    See more
    Interest over time
    Reviews of PostGIS and SQLite
    No reviews found
    How developers use PostGIS and SQLite
    Avatar of Romans Malinovskis
    Romans Malinovskis uses SQLiteSQLite

    We build queries in PHP with DSQL that work with SQLite. We also have SQLite data controller, so that you can build SQLite-based models.

    Avatar of Coolfront Technologies
    Coolfront Technologies uses SQLiteSQLite

    Used during the "build process" of Coolfront Mobile's Flat rate search engine database. Flat rate data that resides in Salesforce is transformed using SQLite into a format that is usable for our mobile Flat rate search engine (AKA: Charlie).

    Avatar of Sripathi Krishnan
    Sripathi Krishnan uses SQLiteSQLite

    RDBTools is a self-hosted application, and it is important that the installation process is simple. With SQLite, we create a new database file for every analysis. Once the analysis is done, the SQLite file can be thrown away easily.

    Avatar of Perljobs.Ru
    Perljobs.Ru uses SQLiteSQLite

    All the dynamic data (i.e.: jobs) is stored in a simple SQLite database.

    Все динамические данные (вакансии) хранятся в простой SQLite БД.

    Avatar of A. M. Douglas
    A. M. Douglas uses SQLiteSQLite

    There's really no call for something heavier for this site. SQLite is simple, easy to use and quite reliable given its age.

    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 DNT
    DNT uses PostGISPostGIS

    Geospatial queries

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