doctrine/dbal

Features

• Database Abstraction Layers - Provides a consistent object-oriented interface for interacting with multiple relational database systems via a unified abstraction layer.
• Fluent Query Construction - Provides a fluent query builder for programmatically constructing portable SQL statements using method chaining.
• Schema and Migration Tools - Analyzes differences between two schema representations and generates the SQL required to migrate between them.
• Bidirectional Type Mappers - Includes a type mapper for converting database-specific data types into native application types and vice versa.
• Connection Establishment - Establishes authenticated sessions with relational databases using configuration parameters or connection strings.
• Data Type Mappings - Converts data types between a relational database and the application using built-in and user-defined mappings.
• Database Driver Abstractions - Implements a driver wrapper that standardizes connections and result sets across various relational database vendors.
• Database Drivers - Implements custom adapters and middleware to connect applications to proprietary or specialized relational database APIs.
• Database Object Abstractions - Represents tables, columns, and indexes as structured objects to ensure consistent normalization and quoting.
• Database Agnostic Generators - Provides a mechanism to generate SQL that is compatible across different database vendors and versions.
• Schema Introspection - Retrieves detailed metadata about tables, columns, and indexes to create an in-memory representation of the schema.
• Database Schema Managers - Programmatically inspects, models, and modifies database structures like tables and indexes using an object-oriented approach.
• Database Transaction Management - Controls groups of database operations as single units of work with support for savepoints and isolation levels.
• Object Oriented Querying - Offers a consistent object-oriented interface to interact with multiple relational database vendors.
• Prepared Statements - Implements prepared statements using placeholders to ensure security against injection and enable statement reuse.
• SQL Placeholder Bindings - Uses positional and named placeholders to separate SQL logic from input data and prevent injection attacks.
• Relational Database Abstractions - Provides a consistent object-oriented interface to interact with multiple relational database systems regardless of vendor.
• Programmatic Schema Forge Tools - Provides a programmatic API to execute DDL statements and control database structure without writing raw SQL.
• SQL Dialect Adapters - Adapts queries to ensure compatibility and feature support across different relational database platforms.
• Dialect-Specific SQL Generation - Translates abstract query requests into dialect-specific SQL strings based on the connected database version.
• SQL Query Builders - Ships a fluent query builder for programmatically constructing portable SQL statements across different dialects.
• Portable SQL Generation - Creates database-specific queries and schema definitions that work across different relational database engines and versions.
• Database Wrappers - Implements a driver wrapper that standardizes connections and result sets across different relational database vendors.
• Format Conversions - Translates application objects into the specific string formats required by the underlying database platform.
• Type Mapping - Provides a system for translating database-specific data types into native application types and vice versa.
• SQL Injection Prevention - Implements security primitives using prepared statements and parameter binding to prevent SQL injection attacks.
• Database Type Converters - Translates database-specific data types into native language types to ensure consistent data handling.
• Schema Modeling Objects - Creates an object-oriented representation of tables, sequences, and indexes to generate platform-specific SQL.
• Common Table Expressions - Supports the creation of named temporary result sets using Common Table Expressions (CTEs) within queries.
• Savepoints - Emulates nested transactions by managing SQL savepoints to allow partial rollbacks within a single connection.
• Application Type Mappings - Enables implementing custom conversion logic between application objects and database values via an extensible type system.
• Database Type Mappings - Allows overriding default vendor type mappings to control how database columns are interpreted by the application.
• Nested Transactions - Emulates nested transactions using SQL savepoints to allow partial rollbacks within a single connection.
• Retriable Transactions - Identifies transient failures like deadlocks to trigger automatic retry logic for transactions.
• Autoincrement Implementations - Creates self-incrementing primary keys using identity columns to ensure consistent ID generation across platforms.
• Indexes and Constraints - Creates and manages indexes and foreign key constraints across different database platforms.
• In-Memory Schema Representations - Represents database structures as an object graph to calculate differences and generate migration SQL.
• Query Expression Builders - Includes a dedicated expression builder for generating nested logic and comparison snippets for SQL filters.
• Query Result Fetching - Allows retrieving query results as associative arrays, numeric arrays, or indexed key-value pairs.
• Array Placeholder Expansion - Rewrites SQL queries to flatten arrays into placeholder lists for use in IN expressions.
• Portable Snippets - Generates vendor-specific SQL snippets and function calls to ensure consistent execution across different engines.
• SQL CRUD Operations - Provides simplified CRUD operation helpers to insert, update, or delete rows using associative arrays.
• SQL Literal Escaping - Quotes and escapes string values to ensure they are treated as literals within database statements.
• Transaction Demarcation & Isolation - Provides manual transaction demarcation and the ability to configure isolation levels for units of work.
• Middleware Pipelines - Includes a middleware-based execution pipeline for intercepting database operations for logging and profiling.
• Database Operation Interceptors - Features a middleware-based execution pipeline to intercept database operations for logging and profiling.

Star history