Ivan
Ivan

Reputation: 95

What is a default transaction isolation level in sqlalchemy for Postgres?

I use sqlalchemy for Postgres DB.

engine = create_engine(
    "postgresql://postgres:postgres@localhost/test"

...

Create engine without Postgres dialect(psycopg2, pg8000, or other). So my question: what is a default transaction isolation level? And what is a default Postgres dialect?

Upvotes: 5

Views: 2590

Answers (1)

AdamKG
AdamKG

Reputation: 14081

Per the docs, the default postgres driver used by SQLAlchemy is psycopg2.

The default transaction isolation level is configured on the DB side, not by the client. Out-of-the-box, it is READ COMMITTED.

Upvotes: 8

Related Questions