Building Scalable APIs: PostgreSQL Meets GraphQL
summary
Shows a working Node.js + React demo that uses a single /graphql endpoint with resolvers that translate GraphQL operations into SQL against PostgreSQL; the demo creates, updates, deletes and fetches posts and the database records the changes (three tables: users, posts, comments). Argues GraphQL fixes over‑ and under‑fetching, cuts endpoint sprawl, and pairs with PostgreSQL features—query planner, read replicas and sharding, connection pooling via PG Bouncer, and json storage with jsonb—to reduce bandwidth and improve scalability and performance.
AI-written summary · about
chapters (8)
- 0:00Introduction to talk
- 1:52Challenges with REST APIs
- 9:34GraphQL fundamentals
- 14:52GraphQL and PostgreSQL demo
- 25:02PostgreSQL optimizations for GraphQL
- 30:23Business gains with GraphQL
- 32:54When to use REST vs GraphQL
- 40:52Q&A session
related talks
28mPowering React-based Dashboards using GraphQL and PostgreSQL
26m@live GraphQL in Practice: Postgres-to-React Realtime Data Sync
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend
59mGoodbye REST; Hello GraphQL
17mThe Power of GraphQL
25mIncreasing Velocity with GraphQL and PostgreSQL
23mOpen Source, Graphs and GraphQL: The next frontier of modern applications
09mGraphQL and React - Two Great Tastes that Taste Great Together