News for hackers. Stuff that matters.

A comment on New Query Language for Graph Databases to Become International Standard. Parent comment

Re:New Query Language for Graph Databases to Become Internat... by ken on Wednesday September 18, 2019 @01:42PM (#21007884)
Yet SQL still hasn’t standardized “CREATE INDEX” yet, has it? How many databases have implemented graph traversals, and do they even use the same syntax?

The various implementations of SQL are so different from each other, and from the spec, that I no longer find it useful to consider them the same language.

Is there a caniuse.com for SQL?

[ Parent | on HN ]
Re:New Query Language for Graph Databases to Become Internat... by dragonwriter on Wednesday September 18, 2019 @01:46PM (#21007935)
> How many databases have implemented graph traversals, and do they even use the same syntax?

Recursive CTEs with standard syntax are in virtually every current-versiom notable SQL-based RDBMS, including SQLite. I think MySQL 8.0 was the last of the major ones to add support.

[ Parent | on HN ]
Re:New Query Language for Graph Databases to Become Internat... by bcoates on Wednesday September 18, 2019 @02:40PM (#21008554)
CREATE INDEX is fundamentally an implementation detail of the RDBMS engine; there can be no meaningful standardization there.
[ Parent | on HN ]
Re:New Query Language for Graph Databases to Become Internat... by taffer on Wednesday September 18, 2019 @02:05PM (#21008181)
> Is there a caniuse.com for SQL?

Not exactly the same, but: https://modern-sql.com/

[ Parent | on HN ]