Ruwan Xaviour Fernando

Rapid GraphQL API Development with PostGraphile

What if you could build a performant GraphQL API without writing a single resolver? Learn how a database-first approach makes it possible.

Rapid GraphQL API Development with PostGraphile
#1about 6 minutes

The buy vs build dilemma in media platforms

Axinom's product strategy evolved to offer modular microservices that solve the customer's choice between buying a monolith or building from scratch.

#2about 4 minutes

Choosing a tech stack for customizable services

The technology stack of Node.js, GraphQL, and PostgreSQL was selected to support expressive APIs and a relational data model for media content management.

#3about 5 minutes

Adopting a database-first API development philosophy

A development philosophy centered on treating the database as the API, maximizing auto-generation, and ensuring performance by default led to adopting PostGraphile.

#4about 6 minutes

Comparing database-first with schema-first and code-first

PostGraphile's database-first approach, where the SQL schema is the single source of truth, is contrasted with traditional schema-first and code-first GraphQL patterns.

#5about 7 minutes

Extending GraphQL schemas with PostGraphile plugins

The extensive plugin system in PostGraphile allows for auto-generating complex filters and adding custom business logic by extending the schema or wrapping resolvers.

#6about 5 minutes

Solving the N+1 query problem automatically

PostGraphile avoids the common GraphQL N+1 query problem by generating efficient SQL joins directly, rather than relying on less performant ORM patterns or data loaders.

#7about 4 minutes

Live demo of generating an API from a database

A live demonstration showcases running the PostGraphile CLI against a PostgreSQL database to instantly generate a full-featured GraphQL API for queries and mutations.

#8about 6 minutes

Q&A on pagination and database compatibility

Audience questions are answered regarding PostGraphile's built-in support for cursor-based pagination and its specific design for PostgreSQL, not other databases.

Related jobs
Jobs that call for the skills explored in this talk.

Matching moments

Audience Q&A on tools, errors, and GraphQL
32:41 MIN

Audience Q&A on tools, errors, and GraphQL

API Design - Getting Started

Introducing GraphQL and its core concepts
02:00 MIN

Introducing GraphQL and its core concepts

GraphQL: Does it replace SQL, REST or Something Else?

Understanding the core concepts of GraphQL APIs
16:27 MIN

Understanding the core concepts of GraphQL APIs

GraphQL + Apollo + Next.js: A Lovely Trio

A quick introduction to GraphQL fundamentals
04:00 MIN

A quick introduction to GraphQL fundamentals

GraphQL Mesh – Why GraphQL between services is the worst idea and the best idea at the same time!

Exploring GraphQL as an API query language
11:33 MIN

Exploring GraphQL as an API query language

Putting the Graph In GraphQL With The Neo4j GraphQL Library

Q&A on GraphQL, team structure, and vendor software
44:31 MIN

Q&A on GraphQL, team structure, and vendor software

Building high performance and scalable architectures for enterprises

Q&A on graph databases, custom resolvers, and security
41:06 MIN

Q&A on graph databases, custom resolvers, and security

Putting the Graph In GraphQL With The Neo4j GraphQL Library

Addressing GraphQL security and implementation challenges
17:32 MIN

Addressing GraphQL security and implementation challenges

GraphQL: Does it replace SQL, REST or Something Else?

Featured Partners

Related Videos

See all videos
GraphQL: Does it replace SQL, REST or Something Else?28:12

GraphQL: Does it replace SQL, REST or Something Else?

Gregor Bauer

Putting the Graph In GraphQL With The Neo4j GraphQL Library47:48

Putting the Graph In GraphQL With The Neo4j GraphQL Library

William Lyon

GraphQL + Apollo + Next.js: A Lovely Trio40:45

GraphQL + Apollo + Next.js: A Lovely Trio

Josh Goldberg

The Great API Debate: REST, GraphQL, or gRPC?28:16

The Great API Debate: REST, GraphQL, or gRPC?

Alexis Yushin

GraphQL Mesh – Why GraphQL between services is the worst idea and the best idea at the same time!34:28

GraphQL Mesh – Why GraphQL between services is the worst idea and the best idea at the same time!

Uri Goldshtein

Rethinking Reactive Architectures with GraphQL 41:06

Rethinking Reactive Architectures with GraphQL

David Leitner

Graphs and RAGs Everywhere... But What Are They? - Andreas Kollegger - Neo4j46:51

Graphs and RAGs Everywhere... But What Are They? - Andreas Kollegger - Neo4j

Postgres in the Age of AI (and Devin)20:50

Postgres in the Age of AI (and Devin)

Nikita Shamgunov

Related Articles

View all articles
S
SciChart
The Fastest JavaScript Charts - Built for React and Beyond
For most developers, browser charting works fine — until it doesn’t. Once you push beyond tens of thousands of points, add live streaming, or need advanced interactions, the story changes: frame drops, frozen dashboards, memory issues. That’s where S...
The Fastest JavaScript Charts - Built for React and Beyond
CH
Chris Heilmann
Dev Digest 151: SEO in an AI world, security fixes and Doomed PDFs
Inside last week’s Dev Digest 151 . 🔎 How ChatGPT compares to search and what that means for SEO ✂️ Job cuts across the board as companies curb DEI programs 🟨 @Microsoft releases 161 Windows security updates ⚠️ @Google’s OAuth bug endangers million...
Dev Digest 151: SEO in an AI world, security fixes and Doomed PDFs
DC
Daniel Cranney
Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS
Inside last week’s Dev Digest 168 . 📊 The state of OpenAI’s GPT models 🤖 20% of Salesforce code written by AI 👩‍💻 Hacking Postgres 🙅‍♂️ How to block Meta AI from your Instagram 🔧 How to fix common CSS mistakes 💻 Make your GitHub profile stand out 🥱 ...
Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS

From learning to earning

Jobs that call for the skills explored in this talk.

Full Stack Engineer

Full Stack Engineer

Climax.eco
Rotterdam, Netherlands

€70-100K
Senior
TypeScript
PostgreSQL
Cloud (AWS/Google/Azure)