Comment by marcklingen
2 years ago
Thanks for the hint. Having only one fully managed db seems to be interesting to reduce needs for joining across databases and less operations overhead (managing uptime, setting up infra for testing, CI etc.) on our 2 people engineering "team". Timescale is definitely on the list to be at least an intermediary solution that would be faster to adopt than migrating to e.g. ClickHouse over time. As you mentioned it, any obvious limitations to watch out for?
None that I am aware of, and that is why I am very interested in learning about any red flags you might have found that motivated your decision to move off Postgres/Supabase and that others should be aware of.
Currently the project is all Postgres and the managed version is on Supabase. No scalability issues yet, we consider different OLAP options as we are mostly interested in faster analytical queries
I've been using it recently and I will say it is definitely harder to perform common time series queries than something like InfluxDB.
Can you elaborate? Harder as in writing queries or harder as in making queries performant?
1 reply →