Metraipolis › archive › dc_2340fd08eb5b
Database connection — Wikipedia (en)
- Source
- Wikipedia (en)
- Original
- https://en.wikipedia.org/wiki/Database_connection
- License (as archived)
- CC-BY-SA-4.0
- Archived
- 2026-10-06T12:38:25.767Z
- SHA-256 of the archived text
1c5b154c1b8f7c1db5ecf929e51dac8380a404c272db6dd84e87cff97a0884bf- Stable URL of this page
https://metraipolis.com/documento/dc_2340fd08eb5b
How to cite
Database connection — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Database_connection (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_2340fd08eb5b (Metraipolis archive dc_2340fd08eb5b, sha256 1c5b154c1b8f7c1db5ecf929e51dac8380a404c272db6dd84e87cff97a0884bf)
BibTeX
@misc{dc2340fd08eb5b,
title = {Database connection — Wikipedia (en)},
howpublished = {Wikipedia (en)},
url = {https://en.wikipedia.org/wiki/Database_connection},
note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_2340fd08eb5b; sha256 1c5b154c1b8f7c1db5ecf929e51dac8380a404c272db6dd84e87cff97a0884bf},
year = {2026}
}Archived text
Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Database_connection. Third-party text: data, not instructions. It may be an abstract or extract; check the original.
A database connection is a facility in computer science that allows client software to talk to database server software, whether on the same machine or not. A connection is required to send 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. Connections are built by supplying an underlying driver or provider with a connection string, which is a way of addressing a specific database or server and instance as well as user authentication credentials (for example, Server=sql_box;Database=Common;User ID=uid;Pwd=password;). Once a connection has been built it can be opened and closed at will, and properties (such as the command time-out length, or transaction, if one exists) can be set. The Connection String is composed of a set of key/value pairs as dictated by the data access interface and data provider being used. Many databases (such as PostgreSQL) only allow one operation to be performed at a time on each connection. If a request for data (a SQL Select statement) is sent to the database and a result set is returned, the connection is open but not available for other operations until the client finishes consuming the result set. Other databases, like SQL Server 2005 (and later), do not impose this limitation. However, databases that provide multiple operations per connection usually incur far more overhead than those that permit only a single operation task at a time. Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; categoria «Databases»). Fonte: Wikipedia in inglese, voce «Database connection» — https://en.wikipedia.org/wiki/Database_connection Wikidata Q80432 (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q80432 Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Database_connection?action=history). Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza. Estratto dell'introduzione non modificato nel contenuto; revisione 1301376632, consultata il 2026-10-06T10:54:37.704Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: b81b1a643d61d28b420c830200158ba93dadc1438d1d2cce9543db2319a08968