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