InfluxDB vs PostGIS: What are the differences?
What is InfluxDB? An open-source distributed time series database with no external dependencies. InfluxDB is a scalable datastore for metrics, events, and real-time analytics. It has a built-in HTTP API so you don't have to write any server side code to get up and running InfluxDB is designed to be scalable, simple to install and manage, and fast to get data in and out..
What is 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.
InfluxDB belongs to "Databases" category of the tech stack, while PostGIS can be primarily classified under "Database Tools".
Some of the features offered by InfluxDB are:
- Time-Centric Functions
- Scalable Metrics
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
"Time-series data analysis" is the top reason why over 35 developers like InfluxDB, while over 22 developers mention "De facto GIS in SQL" as the leading cause for choosing PostGIS.
InfluxDB and PostGIS are both open source tools. It seems that InfluxDB with 16.6K GitHub stars and 2.37K forks on GitHub has more adoption than PostGIS with 636 GitHub stars and 242 GitHub forks.
Impossible Software, SimpleCrypto, and capscale are some of the popular companies that use InfluxDB, whereas PostGIS is used by Key Location, HotelTonight, and DNT. InfluxDB has a broader approval, being mentioned in 116 company stacks & 38 developers stacks; compared to PostGIS, which is listed in 53 company stacks and 14 developer stacks.
What is InfluxDB?
What is PostGIS?
Need advice about which tool to choose?Ask the StackShare community!
Sign up to add, upvote and see more prosMake informed product decisions
What are the cons of using PostGIS?
Sign up to get full access to all the companiesMake informed product decisions
Sign up to get full access to all the tool integrationsMake informed product decisions
We use InfluxDB as a store for our data that gets fed into Grafana. It's ideal for this as it's a lightweight storage engine that can be modified on the fly by scripts without having to log into the server itself and manage tables. The HTTP API also makes it ideal for integrating with frontend services.
To track time-series of course, utilizing few retention rules and continuous queries to keep time-series data fast and maintanable
InfluxDB ingests information from various sources (mostly Telegraf instances) into one place for monitoring purposes.
PostGIS makes it easy (and fast) to do geographic queries, such as nearest-neighbor and bounding box queries.
Backend for weather forecast data that Geoserver queries to build updated weather maps