Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses
Is it just me or is this a severe case of "if you only have a database, everything looks like a SQL query"? Don't get me wrong, I think it's incredible that Postgres is flexible enough to do this, but there are better data structures for graphs than tables.If you need to do this at relatively small scale, just load the data into memory and don't bother with doing it in the database. If you need to do this at large scale, get a dedicated graph database. I guess I just don't see the niche where doing it in Postgres fits in. Anyone with a real world example? I'd love to be proven wrong here since it's definitely cool.