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 GitHub stars and GitHub forks. Here’s a link to PostGraphile's open source repository on GitHub
Who uses PostGraphile?
Companies
18 companies reportedly use PostGraphile in their tech stacks, including HearMe, Booking, and Fielda.
Developers
67 developers on StackShare have stated that they use PostGraphile.
PostGraphile Integrations
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
10
6
5
5
4
4
3
3
3
3
1
PostGraphile's Features
- 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?
Prisma
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.
Hasura
An open source GraphQL engine that deploys instant, realtime GraphQL APIs on any Postgres database.
GraphQL
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
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.
TypeORM
It supports both Active Record and Data Mapper patterns, unlike all other JavaScript ORMs currently in existence, which means you can write high quality, loosely coupled, scalable, maintainable applications the most productive way.
