4 ms·
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
by ken 7y ago
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?
- dragonwriter 7y ago> 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.
- taffer 7y ago> Is there a caniuse.com for SQL? Not exactly the same, but: https://modern-sql.com/ https://modern-sql.com/
- bcoates 7y agoCREATE INDEX is fundamentally an implementation detail of the RDBMS engine; there can be no meaningful standardization there.