Transaction Handling

In SQLite, statements are auto-committed by default. That means, for example, a standalone create table statement will be committed as soon as the statement finishes executing.

To combine multiple statements in a transaction, you must explicitly begin a transaction, or use “Manual” transaction mode (see notes below).

Manual Transaction Mode

Pre-requisites

To use Manual mode with the SQLite adapter, you must be running Harlequin v1.20.0 or higher using Python 3.12 or higher.

Using Manual Mode

In Manual mode, you do not explicitly need to begin a transaction: one will be opened for you. You can commit that transaction either by executing a commit; query, or pressing the ”🡅” button in the Run Query bar. Analogously, you can roll back a transaction by executing rollback; or pressing the ”⮌” button.