Increasing Velocity with GraphQL and PostgreSQL

Presentation byBenjie Gillam

GraphQL has exploded in popularity since its public launch in 2015, and PostgreSQL is still going strong after almost 30 years of development, gaining market share and impressive features at an ever increasing rate.

These tools can pair beautifully, in particular because they're both strongly typed and declarative. In this talk, we'll learn how combining these two technologies can lead to massively increased software development and delivery speed, faster APIs, fewer bugs, and ultimately enable you to focus on delivering value on the frontend rather than maintaining three different layers of data models and associated logic on the backend (DB, application, API).

Similar Presentations

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

We built a real-time system for Postgres→React sync using a `LISTEN/NOTIFY` Postgres trigger, GraphQL `@live` queries, a React hook and a custom ORM-inspired GraphQL query builder. Starting from ESP32 microcontroller devices sending MQTT messages and a Node/Postgres backend, we moved from polling to a stand-alone PoC with Yoga, Prisma triggers, and a custom `useLiveQuery` hook. After proving that the PoC was working we integrated with all our existing full-stack apps. So now we have low-latency UI updates, reusable cross-app logic, and easier extension for new sensor values. Great UX and excellent DX.

Tobbe Lundberg

Celebrating ten years of PostGraphile

GraphQL celebrated it's 10 year birthday last year, today it's PostGraphile's turn! Hear from maintainer Benjie about the origins of the project, the lessons learned along the way, and how the project has evolved to meet the needs of its users despite being MIT-licensed OSS.

Benjie Gillam

Rapid Prototyping With Graphs & Neo4j

Modeling, storing, and querying application data as a graph can help developers quickly get projects up and running by working with data the same way that we think about our domain: as a graph. In this talk we will explore how to apply this graph thinking technique to building GraphQL APIs using the Neo4j GraphQL Library and how we can leverage developer tools to go from idea to backend with nothing but graphs and GraphQL.

William Lyon

Show & Tell: End-to-End of Guild's GraphQL Architecture

Ever wonder about the full data stack powering Guild? Taz will give you an in-depth show & tell of the end-to-end architecture, covering everything from:

Database: how Postgres is used to manage & authorize deeply interconnected social data GraphQL server: how that Postgres database gets transformed into GraphQL GraphQL Persisted Operations: security & efficiency gains implemented on the server Fine-grained caching: how all data provided via GraphQL is cached for read-after-write consistency Server-side rendering: ensuring there isn't reflows / loading spinners/ re-rendering on initial load due to data fetching Client-side rendering: efficiently fetching data via Relay Data catalog: using GraphQL as a data catalog, to power all data fetching across Guild (i.e. not only the web app that you'd expect)

Taz Singh

Platform Sponsors

Supercharge your dev team with AI code reviews

Get your free trial now

Torc is a community-first platform bringing together remote-first software engineer and developer opportunities from across the globe. Join a network that’s all about connection, collaboration, and finding your next big move — together.

Join our community today!