Prisma Prisma
vs
PostGraphile PostGraphile

This is a side by side comparison of Prisma and PostGraphile. Two products that are similar in nature, yet provide unique feature-sets that are worth taking in to account before making a purchasing decision or start using the software. This page can help you broadly analyze the products and weigh pros and cons against one another. Allowing you scrutinize peoples opinions about Prisma and PostGraphile, before making a decision if any of the products fit your use-case.

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?

Prisma is available for Web and Self-Hosted .

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.

Commercial & Proprietary
👍 Most people think Firebase is a good alternative to Prisma.

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.

Freemium & Proprietary
👍 Most people think Fauna is a good alternative to Prisma.

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.

Free , Commercial & Open Source , Proprietary

The software PostGraphile 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 Prisma we recommend you to check out our full list containing 6 Prisma Alternatives.

Prisma Gallery

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?

PostGraphile is available for Windows , macOS , Linux , Web and Self-Hosted .

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.

Freddie
Freddie
3 years, 7 months ago
Pro

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?

Freddie
Freddie
3 years, 7 months ago
Pro

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.

Freddie
Freddie
3 years, 7 months ago
Pro

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.

Free , Commercial & Open Source , Proprietary
👍 Most people think Hasura is a good alternative to PostGraphile.

PostgREST

PostgREST is a standalone web server and development tool that automatically turns your PostgreSQL database into a RESTful API.

Free & Open Source

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.

Freemium & Open Source

The software Prisma 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 PostGraphile we recommend you to check out our full list containing 8 PostGraphile Alternatives.

PostGraphile Gallery