SQL:2023 is finished: Here is what’s new
w
williamdclt
04/14/2023, 9:23 AMYou might have seen SQL:2023 and in particular the "property graph queries" section (http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new#property-graph-queries).
I have no doubt that it could be used for spicedb, but out of interest do you foresee it actually unlocking improvements to spicedb? It could, for example, allow to do the graph walk to answer a permission check in a single SQL query. Is that something you'd like to do?
j
Joey
04/14/2023, 2:13 PMin an ideal world where it is fully optimized and we can translate portions to it, yes
but as we've seen with SQL implementations, "ideal" is often far from reality
I imagine it would be fairly easy to hit a corner case in the performance of this, especially since it is so new
so realistically... I imagine it'll be 3-5 years before this is optimized enough to benefit any level of translation
w
williamdclt
04/14/2023, 2:14 PMPretty much what I thought reading it 😁
j
Joey
04/14/2023, 2:15 PMbut yeah, I read that last night too and went "someday..."