{c}
{tag=SQL transaction isolation level}

https://www.sqlite.org/pragma.html#pragma_read_uncommitted mentions:

> The default isolation level for SQLite is SERIALIZABLE

It does not appear possible to achieve the other two levels besides SERIALIZABLE and READ UNCOMMITED

https://www.sqlite.org/isolation.html


<SQLite> isolation levels

SQLite isolation levels

{c}

= SQL isolation level
{synonym}

Each transaction isolation level specifies what can or cannot happen when two queries are being run in parallel, i.e.: the <memory semantics> of the system.

Remember that queries can affects thousands of rows, and database systems like <PostgreSQL> can run multiple such queries at the same time.

Good summary on the <PostgreSQL> page: https://www.postgresql.org/docs/14/transaction-iso.html

Implementation specifics:
* <SQLite isolation levels>


Ciro Santilli @cirosantilli 37

 Tagged: SQL transaction isolation level