3 ms·
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 p
by dillondoyle 5y ago
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).