3 ms·

What makes this product an “edge” database?

• no_circuit 5y ago
  Presumably it refers to edges in an object graph [0]. EdgeDB seems to be currently deployed as a management, schema, and graph-to-sql translation layer for PostgreSQL. [0] https://www.edgedb.com/blog/edgedb-a-new-beginning#edgedb https://www.edgedb.com/blog/edgedb-a-new-beginning#edgedb.
  • 1st1 5y ago
    Correct!
  • methyl 5y ago
    > Note that this SQL query is not very efficient. An experienced developer would rewrite it to use subqueries Anyone care to explain why is that? I thought the query plan should be the same for JOINs and subqueries.
    • RedCrowbar 5y ago
      There is a difference in how large a set `array_agg` would need to process, since `LEFT JOIN` may produce a very sparse relation and NULLs still have to be scanned over.
• karmakaze 5y ago
  It's not a database meant to run on the 'edge'. I'm guessing it's a graph database built on the PostgreSQL codebase. > EdgeDB is a relational database that stores and describes the data as strongly typed objects and relationships between them. > EdgeDB is built on top of PostgreSQL, inheriting all its core strengths: ACID compliance, performance, and reliability.