SQL:2023 is finished: Here is what’s new
04/14/2023, 9:23 AM
You might have seen SQL:2023 and in particular the "property graph queries" section (
). I have no doubt that it
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?
04/14/2023, 2:13 PM
in 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
04/14/2023, 2:14 PM
Pretty much what I thought reading it 😁
04/14/2023, 2:15 PM
but yeah, I read that last night too and went "someday..."