Does Xano support Row-Level Locks?

Abhishek B

I need to lock Updates to a table row while a Function is executing.

Example: Freeze customer's wallet while a Stock Transaction is processed.

Postgresql offers FOR UPDATE statement for row-level locks as mentioned in docs.

Can Xano support this?

Chris Coleman

Hi, Abhishek. While we currently do not support this natively (I'll move this to feature requests so we can keep track), you could build support for this with a boolean field in the table to denote whether a row is currently locked, and base your logic off of that.

Abhishek B

Thank you Chris, a boolean flag is exactly what I implemented.