PostGIS VS TimescaleDB

Compare PostGIS VS TimescaleDB and see what are their differences

Hive

Seamless project management and collaboration for your team. featured

Contents:

» Base Details
» Videos
» Reviews
» Alternatives

TimescaleDB

TimescaleDB is a time-series SQL database providing fast analytics, scalability, with automated data management on a proven storage engine.

Landing page //
2021-12-18

Landing page //
2023-09-23

Como Instalar o PostgreSQL com PostGIS | ALL com GEO

TimescaleDB videos

+ Add

Rearchitecting a SQL Database for Time-Series Data | TimescaleDB

Category Popularity

0-100% (relative to PostGIS and TimescaleDB)

TimescaleDB

Maps

100 100%

Maps

0% 0

Databases

0 0%

Databases

100% 100

Database Tools

100 100%

Database Tools

0% 0

Time Series Database

0 0%

Time Series Database

100% 100

User comments

Share your experience with using PostGIS and TimescaleDB. For example, how are they different and which one is better?

Reviews

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

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

TimescaleDB Reviews

ClickHouse vs TimescaleDB

Recently, TimescaleDB published a blog comparing ClickHouse & TimescaleDB using timescale/tsbs, a timeseries benchmarking framework. I have some experience with PostgreSQL and ClickHouse but never got the chance to play with TimescaleDB. Some of the claims about TimescaleDB made in their post are very bold, that made me even more curious. I thought it’d be a great...

Source: pradeepchhetri.xyz

4 Best Time Series Databases To Watch in 2019

The Guardian did a very nice article explaining on they went from MongoDB to PostgresSQL in the favor of scaling their architecture and encrypting their content at REST. As you can tell, big companies are relying on SQL-constraint systems (with a cloud architecture of course) to ensure system reliability and accessibility. I believe that PostgresSQL will continue to grow, so...

Source: medium.com

20+ MongoDB Alternatives You Should Know About

TimescaleDB If on the other hand you are storing time series data in MongoDB, then TimescaleDB might be a good fit.

Source: www.percona.com

Social recommendations and mentions

Based on our record, TimescaleDB should be more popular than PostGIS. It has been mentiond 5 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

TimescaleDB mentions (5)

Ask HN: Does anyone use InfluxDB? Or should we switch?
(:alert: I work for Timescale :alert:) It's funny, we hear this more and more "we did some research and landed on Influx and ... Help it's confusing". We actually wrote an article about what we think, you can find it here: https://www.timescale.com/blog/what-influxdb-got-wrong/ As the QuestDB folks mentioned if you want a drop in replacement for Influx then they would be an option, it kinda sounds that's not what... - Source: Hacker News / 6 months ago
Best small scale dB for time series data?
If you like PostgreSQL, I'd recommend starting with that. Additionally, you can try TimescaleDB (it's a PostgreSQL extension for time-series data with full SQL support) it has many features that are useful even on a small-scale, things like:. Source: over 1 year ago
Quick n Dirty IoT sensor & event storage (Django backend)
I have built a Django server which serves up the JSON configuration, and I'd also like the server to store and render sensor graphs & event data for my Thing. In future, I'd probably use something like timescale.com as it is a database suited for this application. However right now I only have a handful of devices, and don't want to spend a lot of time configuring my back end when the Thing is my focus. So I'm... Source: over 2 years ago
How fast and scalable is TimescaleDB compare to a NoSQL Database?
I've seen a lot of benchmark results on timescale on the web but they all come from timescale.com so I just want to ask if those are accurate. Source: over 2 years ago
The State of PostgreSQL 2021 Survey is now open!
Ryan from Timescale here. We (TimescaleDB) just launched the second annual State of PostgreSQL survey, which asks developers across the globe about themselves, how they use PostgreSQL, their experiences with the community, and more. Source: about 3 years ago