GraphQL VS EdgeDB

• Efficient Data Retrieval
  GraphQL allows clients to request only the data they need, reducing the amount of data transferred over the network and improving performance.
• Strongly Typed Schema
  GraphQL uses a strongly typed schema to define the capabilities of an API, providing clear and explicit API contracts and enabling better tooling support.
• Single Endpoint
  GraphQL operates through a single endpoint, unlike REST APIs which require multiple endpoints. This simplifies the server architecture and makes it easier to manage.
• Introspection
  GraphQL allows clients to query the schema for details about the available types and operations, which facilitates the development of powerful developer tools and IDE integrations.
• Declarative Data Fetching
  Clients can specify the shape of the response data declaratively, which enhances flexibility and ensures that the client and server logic are decoupled.
• Versionless
  Because clients specify exactly what data they need, there is no need to create different versions of an API when making changes. This helps in maintaining backward compatibility.
• Increased Responsiveness
  GraphQL can batch multiple requests into a single query, reducing the latency and improving the responsiveness of applications.

Possible disadvantages

• Complexity
  The setup and maintenance of a GraphQL server can be complex. Developers need to define the schema precisely and handle resolvers, which can be more complicated than designing REST endpoints.
• Over-fetching Risk
  Though designed to mitigate over-fetching, poorly designed GraphQL queries can lead to the server needing to fetch more data than necessary, causing performance issues.
• Caching Challenges
  Caching in GraphQL is more challenging than in REST, since different queries can change the shape and size of the response data, making traditional caching mechanisms less effective.
• Learning Curve
  GraphQL has a steeper learning curve compared to RESTful APIs because it introduces new concepts such as schemas, types, and resolvers which developers need to understand thoroughly.
• Complex Rate Limiting
  Implementing rate limiting is more complex with GraphQL than with REST. Since a single query can potentially request a large amount of data, simple per-endpoint rate limiting strategies are not effective.
• Security Risks
  GraphQL's flexibility can introduce security risks. For example, improperly managed schemas could expose sensitive information, and complex queries can lead to denial-of-service attacks.
• Overhead on Small Applications
  For smaller applications with simpler use cases, the overhead introduced by setting up and maintaining a GraphQL server may not be justified compared to a straightforward REST API.

• Graph-Relational Model
  EdgeDB combines the features of relational and graph databases, allowing for complex queries and relationships while maintaining data integrity typical in relational databases.
• Advanced Query Language (EdgeQL)
  EdgeQL offers a more intuitive and expressive query syntax compared to traditional SQL, facilitating easier and more efficient data retrieval.
• Schema Evolution
  EdgeDB provides robust tools for schema migrations and versioning, making it easier to evolve the database schema without downtime or data loss.
• Type Safety
  With its strong typing system, EdgeDB reduces runtime errors by ensuring data type consistency across the database operations.
• Integrated Indexing and Constraints
  EdgeDB supports advanced indexing and constraints, improving query performance and maintaining data integrity natively.

Possible disadvantages

• Relative Newness
  Being relatively new in the market, EdgeDB might lack extensive community support and third-party integrations compared to more established databases.
• Learning Curve
  Technicians accustomed to traditional SQL or other database paradigms might face a learning curve when adapting to EdgeDB's unique features and query language.
• Limited Ecosystem
  EdgeDB's ecosystem, including tooling, documentation, and community resources, is less mature compared to other well-established database systems.
• Potential for Rapid Changes
  As a developing technology, EdgeDB may undergo rapid changes and updates, which may lead to instability or additional maintenance overhead.
• Hosting and Compatibility Concerns
  Deploying EdgeDB might have specific hosting requirements, and compatibility with existing infrastructure could be a concern for some users.

REST vs. GraphQL: Critical Look

More videos

Checking out EdgeDB - The Developer Database (Better than Prisma ORM?!)

More videos

• API Development: How to Transition to Modern APIs

  GraphQL is a query language combined with a server-side runtime. It was created by Facebook in 2012, and soon after, they released the specification to the public and made a NodeJS implementation open source. - Source: dev.to / 6 months ago

• Readings in Database Systems (5th Edition)

  Definitely they should include D4M and GraphQL [1],[2]. Not only D4M can cater for structured relational data, it also suitable for sparse data in spreadsheet, matrices and graph. It's essentially a generalization of SQL but for all... - Source: Hacker News / 9 months ago

• Why GraphQL Is Gaining Adoption

  GraphQL is becoming a popular choice, making development easier. - Source: dev.to / 12 months ago

View more

• Beyond SQL: A relational database for modern applications

  A new DB, with a new query language that's like "SQL done right"? This immediately reminded me of EdgeDB: https://edgedb.com/ Is there anyone here who knows enough about these two products to do a compare/contrast? - Source: Hacker News / about 3 years ago

• Beyond SQL: A relational database for modern applications

  See also https://edgedb.com/ which is another relational database without sql. - Source: Hacker News / about 3 years ago

• DuckDB 0.8.0

  >relational no-sql Do you mean something like edgeDB?[0] Or do you mean some non-declarative language completely? I don't see the latter making much sense. The issue with SQL for me is the "natural language" which quickly loses all... - Source: Hacker News / over 3 years ago

View more