zlacker

[parent] [thread] 0 comments
1. dillon+(OP)[view] [source] 2021-06-12 21:00:45
Thanks for posting this! It is relevant to me right now and great example. Especially since I'm using a new to me database, Spanner.

Specifically I similarly pull rows into a 'queue' like that linked sql by WHERE primary key, primary key, and queue_status ORDER BY timestamp, uuid LIMIT 10. I was worried what would happen with many requests around the same time if it would accidentally pull duplicates into 'queue.'

I think hopefully I've implemented Spanner locking read write transaction correctly and that this won't cause problems at scale (we're not even close to google scale lol).

[go to top]