Need advice about which tool to choose?Ask the StackShare community!
OData vs PostGraphile: What are the differences?
Developers describe OData as "A REST-based protocol for querying and updating data *". It is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. It helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. On the other hand, *PostGraphile** is detailed as "Instant GraphQL API for your PostgreSQL database; use standalone or as a Node.js middleware; MIT-licensed OSS". Execute one command (or mount one Node.js middleware) and get an instant high-performance GraphQL API for your PostgreSQL database.
OData and PostGraphile can be primarily classified as "Query Languages" tools.
PostGraphile is an open source tool with 7.61K GitHub stars and 370 GitHub forks. Here's a link to PostGraphile's open source repository on GitHub.
Pros of OData
- Patterns for paging, sorting, filtering7
- ISO Standard5
- Query Language4
- RESTful3
- No overfetching, no underfetching3
- Get many resources in a single request2
- Self-documenting2
- Batch requests2
- Bulk requests ("array upsert")2
- Ask for what you need, get exactly that2
- Evolve your API by following the compatibility rules1
- Resource model defines conventional operations1
- Resource Modification Language1
Pros of PostGraphile
- Postgres based authentication10
- Great developer support6
- Lightning fast5
- Database first with no braking changes5
- Simple to set up and scale4
- Bye bye Resolvers4
- Back to database first3
- 9 Automatically generates your GraphQL schema3
- Easy setup of relationships and permissions3
- Instant production ready GraphQL3
- Works with new and existing databases1
Sign up to add or upvote prosMake informed product decisions
Cons of OData
- Overwhelming, no "baby steps" documentation1
