Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.



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


Correct!




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: