Hi there, I've got a question about the created_xi...
# spicedb
s
Hi there, I've got a question about the created_xid on the relations table. I wanted to know when a relation was created, so I looked to the created_xid field, which I was told maps to a transaction. This was the created_xid 'MzU5NjczMzA=', and when I decrypted it
echo "MzU5NjczMzA=" | base64 --decode | xxd -p
I got this value - 3335393637333330 When I look at relation_tuple_transaction table, all the xids are 8 characters long. It seemed that my decrypted created_xid matched more to the snapshot field which has the format - 8characters:8characters: I tried inserting colons to query for the transaction by snapshot, but it didn't work. Then I tried just using the first 8 characters, 33353936, since I noticed xid is the first half of snapshot for each row. Still, I got no results. When I queried the table to find the oldest transaction recorded, it was from yesterday. This created_xid was from weeks ago, so I couldn't find the timestamp. It seems like relation_tuple_transaction only contains recent data (maybe 24hs). I was able to find the timestamp using another internal database that stores related info, but was wondering if there's a way to find the info with spiceDB.
6 Views