connection

An open session between a program and a database, through which it sends statements and receives results.

In more detail

Some settings belong to the connection rather than the database: in SQLite, PRAGMA foreign_keys must be turned on for every new connection. A transaction also lives inside one connection, so two connections are two separate views of the data.

Related terms

Taught in

References