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).

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)

Build collaborative, multiplayer applications faster and easier than ever with realtime GraphQL.

Curious about how a consumer-grade social application’s data architecture has been designed? Taz will review the end-to-end GraphQL architecture used at Guild. Everything from Relay to Persisted Operations cached on Cloudflare Workers to efficient Postgres schema resolution. The session is intended to be half show-and-tell and half open discussion with the audience.