/plushcap/analysis/hasura/timescaledb-2-0-with-hasura-part-2-multi-node

TimescaleDB 2.0 with Hasura Part 2 - Multi-Node

What's this blog post about?

In this blog post, the author explores using TimescaleDB 2.0 alongside Hasura and discusses their experience with setting up a multi-node feature in TimescaleDB 2.0. The multi-node feature allows for creating a cluster of TimescaleDB instances to scale both reads and writes. The author shares the infrastructure setup, authentication mechanisms, and how to create distributed hypertables. They also discuss performance comparison between non-distributed and distributed hypertables, foreign key and relationship handling, continuous aggregate views, SQL functions, triggers, and caveats of using distributed hypertables. Lastly, they mention running with Hasura GraphQL Engine and the need for manual relationship definition due to foreign keys not working on a distributed hypertable.

Company
Hasura

Date published
Jan. 22, 2021

Author(s)
Toan Nguye, Tyler Hanna

Word count
1688

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.