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

Increasing the value of talk recordings post-event
04:57 MIN

Increasing the value of talk recordings post-event

Cat Herding with Lions and Tigers - Christian Heilmann

Organizing a developer conference for 15,000 attendees
01:32 MIN

Organizing a developer conference for 15,000 attendees

Cat Herding with Lions and Tigers - Christian Heilmann

Automating video post-production with local scripts
02:54 MIN

Automating video post-production with local scripts

Cat Herding with Lions and Tigers - Christian Heilmann

Establishing a single source of truth for all data
02:39 MIN

Establishing a single source of truth for all data

Cat Herding with Lions and Tigers - Christian Heilmann

Using content channels to build an event community
04:49 MIN

Using content channels to build an event community

Cat Herding with Lions and Tigers - Christian Heilmann

Selecting strategic partners and essential event tools
03:17 MIN

Selecting strategic partners and essential event tools

Cat Herding with Lions and Tigers - Christian Heilmann

Rapid-fire thoughts on the future of work
02:44 MIN

Rapid-fire thoughts on the future of work

What 2025 Taught Us: A Year-End Special with Hung Lee

Breaking down silos between HR, tech, and business
03:39 MIN

Breaking down silos between HR, tech, and business

What 2025 Taught Us: A Year-End Special with Hung Lee

Featured Partners

Related Videos

See all videos
Putting the Graph In GraphQL With The Neo4j GraphQL Library47:48

Putting the Graph In GraphQL With The Neo4j GraphQL Library

William Lyon

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

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

Gregor Bauer

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

GraphQL + Apollo + Next.js: A Lovely Trio

Josh Goldberg

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

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

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

Alexis Yushin

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

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)