On Sunday, March 24, 2019 at 2:29:41 PM UTC-4, [email protected] wrote: > > João, > > No, SQLite transactions are not only ACID, the Isolation is Serializable, > which means even if the execute concurrently, > the result should be same as if they executed in series (on after the > other). What @Anthony describes should not be > necessary, since you already in a transaction. >
At the point of the first read, it is not in a transaction (a transaction is triggered by the first write operation). That is why the "BEGIN IMMEDIATE TRANSACTION" is necessary - to start the transaction, which in the case of SQLite (in non-WAL mode) locks the database. Anthony -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
