EdgeDB

Development

Definitions

  1. A database that combines the reliability of PostgreSQL with a modern query language called EdgeQL, designed to replace both the ORM and raw SQL in application development. EdgeDB runs on top of PostgreSQL but provides its own schema definition language, a powerful query language that handles deep nested queries and aggregations more elegantly than SQL, and a built-in migration system. Its TypeScript query builder generates fully typed queries from the schema. EdgeDB aims to solve the 'impedance mismatch' between relational databases and application code that has plagued developers for decades. While ambitious in scope, adoption has been gradual as developers weigh the benefits of a better query language against the risk of a non-standard database.

    In plain English: A modern database built on PostgreSQL that replaces SQL with a more developer-friendly query language. It tries to eliminate the need for an ORM by making the database itself easier to work with.

    Example: EdgeDB's query for fetching a user with their posts and comments is one readable statement, not three joined SQL tables.