sopa
04/08/2025, 9:51 PMecho "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.