PostGraphile
vs
Prisma
PostGraphile
Prisma
What is PostGraphile?
PostGraphile (previously known as PostGraphQL) is a free an open-source software project that lets you spin up GraphQL APIs on top of an existing PostgreSQL database, instantly. PostGraphile automatically detects tables, columns, indexes, relationships, views, types, functions and comments in your database. Based on that information it generates a GraphQL server and API which is automatically updated when changes are made to the database or its data.
How much does PostGraphile cost?
No pricing information available..
What platforms does PostGraphile support?
Top PostGraphile Pros & Cons
PostGraphile automatically generates a GraphQL API from your PostgreSQL database schema
I love the fact that PostGraphile automatically detects tables, columns, indexes, relationships, views, types, functions and comments from my PostgreSQL database schema and instantly creates a GraphQL server and GraphiQL interface. With PostGraphile I can focus on what's important, making my idea come to reality, instead of fiddling with tooling.
Database-Driven Development
Everything in PostGraphile revolves around your database schema. You write SQL, and PostGraphile automatically generates your GraphQL API. At first I was sceptical towards the model of database-driven development, but it has taught me how powerful our relational databases really are. As of late, the trend has been to move further and further away from database layer, with the introduction of ORMs, NoSQL, Serverless etc.. maybe these ideas are misguided?
Makes use of PostgreSQL's row-level security
PostGraphile is built around features native to PostgreSQL. One such feature is PostgreSQL's row-level security, which can be utilized to build application authentication, authorization and role-based access systems right into your database.
Top PostGraphile Alternatives
Hasura
Hasura is a software development tool that lets you build real-time GraphQL APIs for a PostgreSQL database. The software is free and open source, while enterprise features are provided at a cost. Hasura is perfect for building GraphQL powered microservices and 3factor applications.
PostgREST
PostgREST is a standalone web server and development tool that automatically turns your PostgreSQL database into a RESTful API.
Strapi
Strapi is a free and open source headless CMS developed with JavaScript for Node.js. The software makes it really simple to generate REST and GraphQL APIs. Simply create your database schema and relationships in the Strapi admin panel UI, and Strapi will auto-generate API endpoints to represent the data structures provided. Strapi comes packed with features you come to expect from normal CMS's such as authentication, authorization, content management and a media library. The software can be used for free and can be self-hosted on any server and platform. Extra enterpise functionallity is currently being developed, and will be sold at cost.
The software
Prisma
is removed from the Top PostGraphile Alternatives since you are comparing against it.
If you are looking for more software, applications or projects similar to
PostGraphile
we recommend you to check out our full list containing 8 PostGraphile Alternatives.
PostGraphile Gallery
What is Prisma?
Prisma is a free and open source modern database access layer for TypeScript and Node.js. The software aims to make database access easier with an auto-generated and type-safe query builder that's tailored to your database schema. Prisma is a new take on the traditional ORMs and SQL query builders found in many frameworks and development solutions today. By providing a single access layer that works across databases and technologies Prisma creates what they believe to be the feature of database access and management. Prisma ships with the Prisma Client, a tool that makes it easy to reason about your database queries, so that you can focus on your data and application rather than complex SQL queries or ORM models. With Prisma you can create your own GraphQL or REST API that can access different types of databases including PostgreSQL, MongoDB and MySQL.
How much does Prisma cost?
No pricing information available..
What platforms does Prisma support?
Top Prisma Alternatives
Firebase
Firebase is a Platform-as-a-Service (PaaS) for hosting and develop mobile and web applications. With Firebase developers can move quickly and integrate with third-party software with less friction. Firebase provides an API that can packe your application into a single SDK that works cross-platform for iOS, Android, JavaScript and C++. The Firebase platform is owned by Google and to-date over 1.5 million applications has been shipped on the platform.
Fauna
Fauna is the data API for client-serverless applications. It provides web-native GraphQL interface, with support for custom business logic and integration with the serverless ecosystem. Fauna transforms the traditional DBMS into a Data API that gives you all of the capabilities of traditional database, without sacrificing flexibility, scale, and performance. By utilizing a globally-distributed storage and compute fabric, Fauna-powered applications are delivered to end-users fast and reliably on modern security infrastructure.
Hasura
Hasura is a software development tool that lets you build real-time GraphQL APIs for a PostgreSQL database. The software is free and open source, while enterprise features are provided at a cost. Hasura is perfect for building GraphQL powered microservices and 3factor applications.
The software
PostGraphile
is removed from the Top Prisma Alternatives since you are comparing against it.
If you are looking for more software, applications or projects similar to
Prisma
we recommend you to check out our full list containing 6 Prisma Alternatives.