3 ms·
Very valuable. Do other DBMSes have this feature? It’s quite incredible how much you can put the database to work. So much less application code to write.
by hestefisk 6y ago
Very valuable. Do other DBMSes have this feature? It’s quite incredible how much you can put the database to work. So much less application code to write.
- szarnyasg 6y agoThe authors of paper "Graph Processing in RDBMSs" surveyed graph features in 2017 among 4 popular systems: http://sites.computer.org/debull/A17sept/p6.pdf http://sites.computer.org/debull/A17sept/p6.pdf (page 6, Table 1) They found that only Oracle supported the CYCLE keyword, DB2 SQL Server, and Postgres (version 9 at the time) didn't. SQL Server now has a graph extension so that might have changed. MySQL has introduced support for WITH RECURSIVE in 2017 but it does not support the CYCLE keyword.
- hans_castorp 6y agoI know that Oracle supports the CYCLE and the SEARCH clause in recursive CTEs