Graphile
0 views0
CommentsWhat 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 Languages category of a tech stack.
Key Features
instant GraphQL schema via reflection over PostgreSQL database APIcompiles complex GraphQL queries into very few SQL statements resulting in high performancebuilt entirely from plugins - heavily customisablesupport for PostgreSQL RBAC and RLSwatch mode (monitors for database schema changes) for great DXstandalone server, express middleware, or GraphQL schemaintegration with Express auth via pgSettings (e.g. Passport.js, optional)JWT auth (optional)very strong support for PostgreSQL functionssimple to set up and scale
PostGraphile Pros & Cons
Pros of PostGraphile
- ✓Postgres based authentication
- ✓Great developer support
- ✓Database first with no braking changes
- ✓Lightning fast
- ✓Bye bye Resolvers
- ✓Simple to set up and scale
- ✓9 Automatically generates your GraphQL schema
- ✓Back to database first
- ✓Easy setup of relationships and permissions
- ✓Instant production ready GraphQL
Cons of PostGraphile
No cons listed yet.
PostGraphile Alternatives & Comparisons
What are some alternatives to PostGraphile?
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.
SQL
SQL is designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).
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.
Oracle PL/SQL
It is a powerful, yet straightforward database programming language. It is easy to both write and read, and comes packed with lots of out-of-the-box optimizations and security features.