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 = TrueNot the same as Kafka's enable.auto.commit, which commits consumer offsets.Related terms
- transaction — A group of database changes that succeed or fail together, so the data is never left half-updated.
- psycopg — The most widely used Python driver for PostgreSQL databases.
- enable.auto.commit — The consumer setting that, when true, commits offsets automatically on a background timer.
Taught in
- Dual Writes And Why They Lose Data — Apache Kafka & Event Streaming