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
11:34 MIN

Audience Q&A on tools, errors, and GraphQL

API Design - Getting Started

Introducing GraphQL and its core concepts
04:04 MIN

Introducing GraphQL and its core concepts

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

Understanding the core concepts of GraphQL APIs
03:57 MIN

Understanding the core concepts of GraphQL APIs

GraphQL + Apollo + Next.js: A Lovely Trio

A quick introduction to GraphQL fundamentals
05:40 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
06:58 MIN

Exploring GraphQL as an API query language

Putting the Graph In GraphQL With The Neo4j GraphQL Library

How GraphQL improves upon REST's limitations
02:44 MIN

How GraphQL improves upon REST's limitations

REST in Peace? What does the API protocol of the future look like? Or do we have it already?

Q&A on GraphQL, team structure, and vendor software
13:52 MIN

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

Building high performance and scalable architectures for enterprises

Interacting with Astra DB using GraphQL and REST APIs
02:50 MIN

Interacting with Astra DB using GraphQL and REST APIs

Building Real-Time AI/ML Agents with Distributed Data using Apache Cassandra and Astra DB

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 Library
47:48

Putting the Graph In GraphQL With The Neo4j GraphQL Library

William Lyon

GraphQL + Apollo + Next.js: A Lovely Trio
40: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

Event based cache invalidation in GraphQL
36:58

Event based cache invalidation in GraphQL

Simone Sanfratello

Rethinking Reactive Architectures with GraphQL
41:06

Rethinking Reactive Architectures with GraphQL

David Leitner

How Gatsby Cloud's real-time streaming architecture drives <5 second builds
42:10

How Gatsby Cloud's real-time streaming architecture drives <5 second builds

Kyle Mathews

Related Articles

View all articles
Chris Heilmann
Dev Digest 134 - Where pixels sing?
News and ArticlesWeAreDevelopers LIVE Data and Security Day is on Wednesday, 25/09/2024. Learn about OPC UA Updates, Best Practices for Using GitHub Secrets, Passwordless Web 1.5, Emerging AI Security Risks, Data Privacy in LLMs and get a chance to t...
Dev Digest 134 - Where pixels sing?
Chris Heilmann
All the videos of Halfstack London 2024!
Last month was Halfstack London, a conference about the web, JavaScript and half a dozen other things. We were there to deliver a talk, but also to record all the sessions and we're happy to share them with you. It took a bit as we had to wait for th...
All the videos of Halfstack London 2024!

From learning to earning

Jobs that call for the skills explored in this talk.