@live GraphQL in Practice: Postgres-to-React Realtime Data Sync

on YouTube ↗26m

" summary

A Postgres-to-React realtime pipeline is built end-to-end: ESP32 devices send MQTT to a Node broker, messages persist in Postgres, Postgres triggers use Postgres LISTEN/NOTIFY to invalidate live queries, and a custom useLiveQuery hook with Apollo and a Prisma-style GraphQL query builder pushes low-latency updates to React. The production rig runs on four deployed units with 216 crop spots each, moved from polling/subscriptions to server-sent-events live queries and incremental adoption across apps.

AI-written summary · about

" chapters (6)

1. 0:00Introduction and project overview
2. 3:12Current system architecture challenges
3. 8:09Designing the new real-time system
4. 12:44GraphQL ORM implementation details
5. 18:25System limitations and future steps
6. 21:55Next steps and open source call

" related talks

• 45mBuilding Scalable APIs: PostgreSQL Meets GraphQLShalaka D, Ramya B · PGConf India 2025
• 28mPowering React-based Dashboards using GraphQL and PostgreSQLLukas Fittl · React Rally 2016
• 58mCrafting compelling real-time web experiences with GraphQL and ReactRob Crowley · NDC Sydney 2018
• 24mRealtime React Apps with GraphQLRobert Zhu · React Conf 2017
• 21mLive-coding demoMarion Schleifer · ReactiveConf 2019
• 26mEverything You Need to Know About GraphQL in 3 ComponentsEve Porcello · React Rally 2018
• 18mCrafting compelling real-time web experiences with GraphQLRob Crowley · Decompress AU 2018
• 09mGraphQL and React - Two Great Tastes that Taste Great TogetherAdron Hall · React Summit 2020