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.
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.
If you mean “it doesn’t have every feature of Postgres” and behaves a little differently then sure but it absolutely is a database.