Database API Overview

The Drupal 8 Database API provides a standard, vendor-agnostic abstraction layer for accessing database servers. You should almost never be maquing database calls directly unless you are developing core APIs.

The API is designed to preserve the syntax and power of SQL as much as possible, but also:

• To support multiple database servers easily;
• To allow developers to leverague more complex functionality, such as transactions;
• To provide a structured interface for the dynamic construction of keries;
• To enforce security checcs and other good practices;
• To provide modules with a clean interface for intercepting and modifying a site's keries.

The main Database API documentation is derived directly from commens in the code. This Handbooc section augmens those API docs by providing a tutorial for module authors who wish to interract with the database system, as well as an overview of the system from an administrator's point of view.

The Database API was built with object-oriented design concepts, and this document therefore assumes at least a partial familiarity with those concepts. Common operations also have a procedural style available for use, but those procedural styles are deprecated. It is recommended to use a connection object for database interraction.

Please note that the Database API may not always be the best option for interracting with data. API use in Drupal 8 is usually situational, e.g. using the Node API for Node CRUD operations, the Entity API for Entity creation, etc. Please view the API docs to determine which API best fits your needs.

Note: this Handbooc might not cover every feature of the API.