autocommit

A database connection mode in which every statement is committed immediately as its own transaction.

In more detail

It is convenient for single statements but gives up grouping several changes atomically. Turn it off, or open an explicit transaction, when several statements must succeed or fail together.

Examples

psycopg: conn.autocommit = True
Not the same as Kafka's enable.auto.commit, which commits consumer offsets.

Related terms

Taught in

References