Hacker News Reader

What makes this product an “edge” database?

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.

Correct!

> 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.

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.

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.

Reply on news.ycombinator.com