How far can you go without a message queue?

Re:How far can you go without a message queue? by skyde on Monday August 29, 2022 @01:31PM (#32640980)

the only way to do an "atomic increment operation" is to use the "Watch" command or to write stored procedure.

Watch is a poor man transaction and stored procedure does not work when you need to read value interactively from somewhere else (user/filesystem/another database) while inside a transaction.

[ Parent | on HN ]

Re:How far can you go without a message queue? by Spivak on Tuesday August 30, 2022 @06:44PM (#32656120)

You're literally describing INCR, it's atomic. But I know what you mean, you want atomic GET then SET which is done by WATCH.

I don't disagree with you about WATCH being less powerful than PG transactions. SQLite data types are less powerful than PG types but it's still a database.

[ Parent | on HN ]