Transactions or stored procedures or custom SQL

[Apple]

My experience with “start transaction”:

UI support for database transactions

As far as my testing goes, unfortunately not. If two HTTP requests come in, two BEGIN statements may be called sequentially, they’re not blocking and both run at the same time, throwing warnings at the database logs I have a feeling transactions must be wrapped and sent in “one-shot”