Database connection: Difference between revisions

Revision as of 22:16, 4 August 2021

Revision as of 11:03, 10 October 2021

Line 1:

A '''Database connection''' is a facility in [[computer science]] that allows [[Client (computing)|client]] software to talk to [[database server]] software, whether on the same machine or not. A '''connection''' is required to send [[command (computing)|commands]] and receive answers, usually in the form of a result set.clienved

Ved

t]] software to talk to [[database server]] software, whether on the same machine or not. A '''connection''' is required to send [[command (computing)|commands]] and receive answers, usually in the form of a result set.

Connections are a key concept in [[data-centric]] programming. Since some DBMS engines require considerable time to connect, [[connection pooling]] was invented to improve performance. No command can be performed against a database without an "open and available" connection to it.