search

dwyl / how-to-choose-a-database

How to choose the right dabase
97 stars 11 forks source link

TimescaleDB (scalable time-series database on PostgreSQL) #11

Open nelsonic opened 7 years ago

nelsonic commented 7 years ago

When Boring is Awesome: Building a scalable time-series database on PostgreSQL https://blog.timescale.com/when-boring-is-awesome-building-a-scalable-time-series-database-on-postgresql-2900ea453ee2

nelsonic commented 7 years ago

https://github.com/timescale/timescaledb

nelsonic commented 6 years ago

They have really worked on their DOCs: http://www.timescale.com/how-it-works I will be diving into this v. soon!

newswim commented 6 years ago

I set it up for a small project and it just worked. Excellent dev experience.

More specifically, it's treated as just a regular PG extension, and you simply declare a custom type on a field. However, under the hood it's doing this windowing magic that opens up the in-memory time series potential.

nelsonic commented 6 years ago

@newswim yeah, I saw your repo. 👀 🎉 We'll be using TimeScale for a very similar purpose in the near future. 😉 Stoked you had a good experience getting it setup; very reassuring! 👍

nelsonic commented 5 years ago

@RobStallion if you aren't too pressed for time on https://github.com/dwyl/bestevidence consider exploring TimeScale for the questions & answers. If you are time-crunched, we can always refactor later. 👍

nelsonic commented 4 years ago

https://blog.timescale.com/blog/multi-node-petabyte-scale-time-series-database-postgresql-free-tsdb/ https://news.ycombinator.com/item?id=23272992