Postgraphile v5 ​

https://postgraphile.org/ Postgraphile provides an extensible high-performance automatic GraphQL API for PostgresSQL.

Why postgraphile? ​

Reasons for using it in place of the Supabase client for the bulk of data access include:

• Ability to expose custom schemas more easily
• A rich query-builder experience (ruru)
• I have multiple postgraphile-4 applications that may one day port to Supabase
• Postgraphile v5 is optimized for edge-function deployment and is a natural fit for use with Nuxt3

How postgraphile? ​

// server/api/graphql.ts
import { postgraphile } from "postgraphile"
import { grafserv } from "grafserv/h3/v1";
import preset from "./graphile.config.js";  

const pgl = postgraphile(preset);
const serv = pgl.createServ(grafserv);

export default defineEventHandler(async (event) => {
  return serv.handleEvent(event)  
})

As of this writing, this is how postgraphile is integrated with nuxt in this starter.

Postgraphile v5 is currently in beta.

The key point here is that the grafserv h3 plugin is exposed by postgraphile, and actually handles things at the h3 level.

Nuxt is built on nitro, which in turn is built on h3

Special thanks to benjie for offering to implement this vital component and to dodobibi for the (upcoming) nuxt module.

Refer to https://postgraphile.org/postgraphile/next/config to understand the accompanying graphile.config.ts file.

Currently, subscriptions do not work. This will be remedied by upcoming postgraphile and nuxt releases, but as of now there are a couple of pull requests that are necessary.