https://authzed.com logo
SQL:2023 is finished: Here is what’s new
w

williamdclt

04/14/2023, 9:23 AM
You 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 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
w

williamdclt

04/14/2023, 2:14 PM
Pretty much what I thought reading it 😁
j

Joey

04/14/2023, 2:15 PM
but yeah, I read that last night too and went "someday..."