What is PostGraphile?
Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database
PostGraphile is a tool in the Query Languages category of a tech stack.
PostGraphile is an open source tool with 9.9K GitHub stars and 469 GitHub forks. Here’s a link to PostGraphile's open source repository on GitHub
Who uses PostGraphile?
15 companies reportedly use PostGraphile in their tech stacks, including Booking, Fielda, and Storyscript.
50 developers on StackShare have stated that they use PostGraphile.
Node.js, PostgreSQL, GraphQL, ExpressJS, and Apollo are some of the popular tools that integrate with PostGraphile. Here's a list of all 11 tools that integrate with PostGraphile.
Pros of PostGraphile
Postgres based authentication
Simple to set up and scale
Great developer support
Bye bye Resolvers
Database first with no braking changes
Instant production ready GraphQL
Back to database first
9 Automatically generates your GraphQL schema
Easy setup of relationships and permissions
Works with new and existing databases
- instant GraphQL schema via reflection over PostgreSQL database API
- compiles complex GraphQL queries into very few SQL statements resulting in high performance
- built entirely from plugins - heavily customisable
- support for PostgreSQL RBAC and RLS
- watch mode (monitors for database schema changes) for great DX
- standalone server, express middleware, or GraphQL schema
- integration with Express auth via pgSettings (e.g. Passport.js, optional)
- JWT auth (optional)
- very strong support for PostgreSQL functions
- simple to set up and scale
PostGraphile Alternatives & Comparisons
What are some alternatives to PostGraphile?
See all alternatives
Prisma is an open-source database toolkit. It replaces traditional ORMs and makes database access easy with an auto-generated query builder for TypeScript & Node.js.
An open source GraphQL engine that deploys instant, realtime GraphQL APIs on any Postgres database.
GraphQL is a data query language and runtime designed and used at Facebook to request and deliver data to mobile and web apps since 2012.
PostgreSQL is an advanced object-relational database management system that supports an extended subset of the SQL standard, including transactions, foreign keys, subqueries, triggers, user-defined types and functions.