dbal

Doctrine Database Abstraction Layer

MIT License

Downloads
442M
Stars
9.4K
Committers
601
View Code on GitHub Visit Website
Ecosystems: MariaDB, PostgreSQL, SQLite, MySQL, sql-server

Bot releases are hidden (Show)

dbal - 4.0.0-RC2

Published by derrabus 9 months ago

Breaking Changes

Improvements

Changes from Lower Branches

Full Changelog: https://github.com/doctrine/dbal/compare/4.0.0-RC1...4.0.0-RC2

dbal - 4.0.0-RC1

Published by derrabus about 1 year ago

Breaking Changes

Improvements

Changes from Lower Branches

New Contributors

Full Changelog: https://github.com/doctrine/dbal/compare/4.0.0-beta3...4.0.0-RC1

dbal - 4.0.0-beta3

Published by derrabus about 1 year ago

What's Changed

New Contributors

See also

This release contains all changes of the 3.x series since 3.6.0. For more information, please refer to the individual release announcements:

Full Changelog: https://github.com/doctrine/dbal/compare/4.0.0-beta2...4.0.0-beta3

dbal - 4.0.0-beta2

Published by derrabus over 1 year ago

What's Changed

New Contributors

Full Changelog: https://github.com/doctrine/dbal/compare/4.0.0-beta1...4.0.0-beta2

dbal - 4.0.0-beta1

Published by morozov almost 2 years ago

Release 4.0.0-beta1

4.0.0-beta1

  • Total issues resolved: 31
  • Total pull requests resolved: 198
  • Total contributors: 18

BC Break,QueryBuilder

BC Break,Connecting,Events,Schema Introspection,Schema Management,Transactions

Error Handling

BC Break,Schema Comparison

BC Break,Schema Comparison,Schema Management

BC Break,Schema Management

Improvement,Schema Comparison

Schema Comparison

BC Break,SQLite

BC Break,Drivers,SQLite,pdo_sqlite

BC Break,Error Handling,Improvement

BC Break,Foreign Keys,Primary Keys,Schema Management

BC Break,Error Handling,Schema Management

Error Handling,Improvement

Error Handling,Schema Definition

BC Break

BC Break,Configuration,Connections,PostgreSQL

SQLite,Schema Comparison,Schema Management

BC Break,Configuration,Connections,Platform Detection

BC Break,Configuration,Connections

Error Handling,PHP,PostgreSQL

BC Break,Platforms,SQL Server

Foreign Keys,MySQL,Schema Introspection

BC Break,Foreign Keys,MySQL,Schema Management

BC Break,Default Values,Improvement,SQL Server,Schema Management

BC Break,Columns

BC Break,Schema Introspection

PostgreSQL,Schema Management

SQL Server,Schema Management

BC Break,Columns,Schema Definition

Schema Management

Schema Management,Test Suite

Oracle,Schema Management

BC Break,Connections,Improvement

BC Break,Prepared Statements

BC Break,PHP,Platforms,Portability,Transactions

BC Break,PHP,QueryBuilder

BC Break,PHP,Prepared Statements

Improvement,PHP

PHP

Code Style

BC Break,Platforms

Prepared Statements

Bug,MySQL,Schema Comparison

Platforms,SQLite

BC Break,Platforms,SQLite,Schema,Sequences,Types

BC Break,Platforms,Types

Oracle,Platforms

BC Break,Configuration,Schema Introspection

BC Break,Columns,Types

BC Break,Drivers,Schema Management

BC Break,Schema Introspection,Tools

BC Break,SQLite,Schema Management

BC Break,Reserved Keywords,Schema Management

BC Break,Foreign Keys,Platforms

BC Break,Deprecation,Foreign Keys,Quoting,Schema Management

Deprecation

BC Break,Improvement,PostgreSQL

Platforms,Schema Management

Default Values,MySQL

BC Break,Platforms,Schema Introspection

BC Break,Improvement,Prepared Statements

Reserved Keywords,Static Analysis

Types

BC Break,Types

IBM DB2,Improvement,Query Limit/Offset Modification

Improvement,Oracle,Query Limit/Offset Modification

Documentation,Static Analysis

BC Break,Platforms,Sequences

BC Break,Oracle,Platforms

BC Break,Schema Introspection,Type Mapping

BC Break,Tools

BC Break,MySQL,Platforms

BC Break,Platforms,PostgreSQL

BC Break,Connections

Type Mapping

BC Break,Logging

BC Break,Platforms,SQLite,Schema Management

Test Suite

BC Break,Error Handling,Improvement,Schema Management

Improvement

BC Break,SQL Server

BC Break,Foreign Keys,Indexes,Platforms,Schema,Schema Management

BC Break,Oracle,PostgreSQL,SQL Server,SQLite,Schema,Schema Management

BC Break,Indexes,Platforms

BC Break,Platforms,SQLite

Platforms,Sequences

Code Style,Strict Typing

BC Break,Events,Platforms,Schema Management

BC Break,Improvement,Schema

BC Break,Improvement,Schema Comparison

BC Break,Connections,Drivers,Platform Detection

BC Break,Platforms,PostgreSQL,SQL Server

BC Break,Bug,Foreign Keys,Schema Comparison,Schema Definition

BC Break,Improvement,Platforms

Connections,Error Handling,Improvement,Transactions

BC Break,Sequences

BC Break,Connections,PDO,Sequences

BC Break,Improvement,MySQL,Platforms

BC Break,Cache

BC Break,Reserved Keywords

BC Break,Platforms,Reserved Keywords

BC Break,PostgreSQL,Schema Management

Static Analysis

BC Break,Bug,Connections,Schema Management

BC Break,Bug,Connections

Code Style,Improvement,mysqli,oci8

Error Handling,Transactions

BC Break,Improvement,Schema,Schema Introspection,Schema Management

Improvement,QueryBuilder

BC Break,Improvement,QueryBuilder

Code Style,Improvement

BC Break,Improvement,QueryBuilder,Strict Typing

BC Break,Connecting,Improvement,Prepared Statements,Strict Typing

Improvement,QueryBuilder,Strict Typing

BC Break,Improvement,Schema Introspection,Schema Management

Improvement,Strict Typing

BC Break,Improvement,Schema Definition,Strict Typing,Test Suite,Types

Bug,Documentation

Improvement,Test Suite

Code Style,Improvement,MySQL

Bug,QueryBuilder

Columns,Improvement,Test Suite

BC Break,Columns,Improvement,Platforms

BC Break,Columns,Events,Improvement,Tables

Improvement,Strict Typing,Test Suite

BC Break,Events,Improvement,Strict Typing

BC Break,Improvement,Strict Typing

Improvement,Sharding,Strict Typing

BC Break,Improvement,Strict Typing,Tools

BC Break,Improvement,Strict Typing,Types

BC Break,Connections,Improvement,Strict Typing

BC Break,Improvement,Schema,Strict Typing

BC Break,Improvement,Platforms,Strict Typing

BC Break,Drivers,Improvement,Strict Typing

BC Break,Improvement,Prepared Statements,Strict Typing

BC Break,Improvement

BC Break,Deprecation,Platforms,PostgreSQL

Bug

BC Break,Columns,Improvement,Schema Management,Strict Typing

BC Break,IBM DB2,Improvement

BC Break,Improvement,Platforms,Prepared Statements,SQLite,Strict Typing

BC Break,Connections,Improvement,Quoting,Strict Typing

BC Break,Connections,Improvement,Prepared Statements,Strict Typing

BC Break,Connections,Strict Typing,Transactions

BC Break,Error Handling,Improvement,Prepared Statements,mysqli,oci8

BC Break,Code Style,Improvement,Strict Typing

BC Break,Improvement,Platforms,Query Limit/Offset Modification

BC Break,Columns,Platforms,Schema Definition,Type Conversion,Type Mapping,Types

Platforms,SQLite,Schema Introspection,Type Mapping,Types

dbal - Release 2.12.1

Published by morozov almost 4 years ago

Release 2.12.1

  • Total issues resolved: 2
  • Total pull requests resolved: 11
  • Total contributors: 7

Bug fixes

Deprecations

PHP 8

Packaging

Static Analysis

Documentation

dbal - Release 2.10.4

Published by morozov about 4 years ago

Release 2.10.4

Build Status

  • Total issues resolved: 2
  • Total pull requests resolved: 3
  • Total contributors: 3

Regressions

Bug fixes

CI improvements

dbal - Release 2.10.3

Published by morozov about 4 years ago

Release 2.10.3

Build Status

  • Total issues resolved: 3
  • Total pull requests resolved: 42
  • Total contributors: 9

Bug Fixes

Other Code Improvements

Static Analysis Improvements

CI Improvements

Documentation Improvements

Test Suite Improvements

Code Style Improvements

dbal - Release v2.10.1

Published by morozov almost 5 years ago

Build Status

This release fixes regressions introduced in release v2.10.0, implements some CI/testing improvements and introduces updates in the documentation.

  • Total issues resolved: 2
  • Total pull requests resolved: 9
  • Total contributors: 9

Regressions:

CI improvements and maintenance:

Test suite improvements:

Documentation updates:

dbal - Release v2.10.0

Published by morozov almost 5 years ago

Release v2.10.0

Build Status

This is a minor release of Doctrine DBAL that aggregates over 70 fixes and improvements developed by 25 contributors over the last year.

This release focuses on internal code quality improvement and deprecating the functionality identified for removal in the next major release.

Note that PHP 7.2 is now the minimum supported PHP version.

Backwards Compatibility Breaks

This release introduces a minor BC break. Default column values are no longer handled as SQL expressions. They are converted to SQL literals (e.g. escaped). The previous behavior was not portable and was never by design.

Clients must now specify default values in their initial form, not in the form of an SQL literal (e.g. escaped).

Before:

$column->setDefault('Foo\\\\Bar\\\\Baz');

After:

$column->setDefault('Foo\\Bar\\Baz');

Deprecations

  • The usage of the getDriver(), getDatabasePlatform() and getSchemaManager() methods of the ConnectionEventArgs class has been deprecated.
  • The usage of the getDatabasePlatform() method of the SchemaColumnDefinitionEventArgs class has been deprecated.
  • The usage of the getHost(), getPort(), getUsername() and getPassword() methods of the Connection class has been deprecated.
  • Passing multiple SQL statements as an array to SchemaAlterTableAddColumnEventArgs::addSql() and the same method in other SchemaEventArgs-based classes is deprecated.
  • Calling AbstractSchemaManager::tablesExist() with a string argument is deprecated.
  • Calling OracleSchemaManager::createDatabase() without an argument or by passing NULL is deprecated.
  • Unused schema manager methods are deprecated.
    • AbstractSchemaManager::_getPortableFunctionsList(),
    • AbstractSchemaManager::_getPortableFunctionDefinition(),
    • OracleSchemaManager::_getPortableFunctionDefinition(),
    • SqliteSchemaManager::_getPortableTableIndexDefinition().
  • The usage of NULL to indicate empty $username or $password when calling Doctrine\DBAL\Driver::connect() is deprecated.
  • Method Doctrine\DBAL\Platforms::_getAlterTableIndexForeignKeySQL() has been deprecated as no longer used.
  • Property Doctrine\DBAL\Driver\OCI8\OCI8Statement::$_PARAM has been deprecated as not used.
  • Method Doctrine\DBAL\Driver::getName() is deprecated.
  • The usage of user-provided PDO instance is deprecated.
  • Type::* constants are deprecated.
  • The Doctrine\DBAL\Driver\SQLSrv\SQLSrvStatement::LAST_INSERT_ID_SQL constant has been deprecated.
  • The constants in Doctrine\DBAL\SQLParserUtils have been deprecated.
  • The Doctrine\DBAL\Logging\LoggerChain::addLogger method has been deprecated.

Please see the details in the UPGRADE.md documentation.

New Features and Improvements

MySQL-related changes:

Driver level changes:

Schema management:

Types improvements:

Compatibility with Symfony 5:

Query Builder:

Logging:

Code quality improvements:

Test suite improvements:

Documentation improvements:

CI improvements:

Deprecations:

dbal - Release v2.9.3

Published by morozov almost 5 years ago

Release v2.9.3

Build Status

This release fixes regressions introduced in previous releases and other bugs.

  • Total issues resolved: 5
  • Total pull requests resolved: 14
  • Total contributors: 9

Regressions

Other bugs

CI improvements and maintenance

PHP 7.4 support

dbal - Release v2.9.2

Published by morozov almost 6 years ago

Release v2.9.2

Build Status

This release fixes regressions introduced in v2.9.1.

  • Total issues resolved: 2

MySQL, Schema Introspection:

MySQL, Schema Comparison:

dbal - Release v2.9.1

Published by morozov almost 6 years ago

Release v2.9.1

Build Status

This release fixes regressions introduced in v2.9.0 and issues specific to the SQL Anywhere platform.

  • Total issues resolved: 11

MySQL, Schema Introspection:

SQL Anywhere:

Schema Comparison:

Connections:

Cache:

Documentation:

dbal - Release v2.8.1

Published by morozov almost 6 years ago

Release v2.8.1

Build Status

This release backports the bug fixes implemented in newer DBAL versions.

  • Total issues resolved: 7

PostgreSQL:

Oracle:

SQL Anywhere:

Continuous Integration:

dbal - Release v2.9.0

Published by morozov almost 6 years ago

Release v2.9.0

Build Status

This is a minor release of Doctrine DBAL that aggregates over 40 fixes and improvements developed by 18 contributors over the last 5 months.

This release includes all changes of the 2.8.x series, as well as feature additions and improvements that couldn't land in patch releases.

Backwards Compatibility Breaks

This doesn't contain any intentional Backwards Compatibility (BC) breaks.

Deprecations

  • The usage of NULL to specify the absence of an offset in LIMITed queries is deprecated. Use 0 instead.
  • It's not recommended to rely on the default length specified by implementations of Type. These values are not used by the library and will be removed.
  • It's not recommended to rely on the string representation of Type objects.
  • Regular-expression based asset filters are deprecated in favor of callback-based as more extensible.
  • Calling Statement::fetchColumn() with an invalid column index is deprecated.
  • The dbal:import CLI command is deprecated. Please use other database client applications for import.

Please see details in the UPGRADE.md documentation.

New Features

  • Added support for MariaDB 10.3.
  • Added support for Windows authentication for SQL Server.
  • Added support for column length in index definitions on MySQL.

Improvements and Fixes

  • Implemented handling BLOB objects represented as streams in the MySQL (mysqli) driver.
  • Implemented handling BLOB objects represented as streams in the IBM DB2 driver.
  • DBAL is now continuously tested with the PDO driver for Oracle.
  • Implemented handling of URLs in master-slave and pooling-shard connection configuration.
  • The codebase is now fully compatible with the Doctrine Coding Standard v5.0.

Total issues resolved: 45

Deprecations:

New Features:

Bug Fixes:

Improvements:

Documentation Improvements:

Code Quality Improvements:

Continuous Integration Improvements:

dbal - Release v2.7.2

Published by morozov over 6 years ago

Release v2.7.2

Build Status

This release backports the bug fixes implemented in newer DBAL versions.

Total issues resolved: 7

Platforms:

Schema Comparison:

Performance:

Documentation:

dbal - Release v2.8.0

Published by morozov over 6 years ago

Release v2.8.0

Build Status

This is a minor release of Doctrine DBAL that aggregates over 30 fixes and improvements developed over the last 3 months.

This release includes all changes of the 2.7.x series, as well as feature additions and improvements that couldn’t land in patch releases.

Backwards Compatibility Breaks

This doesn't contain any intentional Backwards Compatibility (BC) breaks.

Dependency Changes

Please see details in the UPGRADE.md documentation.

Deprecations

  • The usage of binary fields whose length exceeds the maximum field size on a given platform is deprecated. Please use binary fields of a size which fits all target platforms, or use blob explicitly instead.
  • The usage of DB-generated UUIDs is deprecated. Their format is inconsistent across supported platforms and therefore the feature is not portable. Use a PHP library (e.g. ramsey/uuid) to generate UUIDs on the application side.

New features

  • Initial support of MySQL 8.
  • Initial support of PostgreSQL 11.
  • Ability to evaluate arbitrary SQL expressions via AbstractPlatform::getDummySelectSQL().

Improvements and Fixes

  • Improved support of binary fields on Oracle and IBM DB2.
  • Improved SQL Server configuration capabilities via both sqlsrv and pdo_sqlsrv.
  • Improved handling of AUTOINCREMENTed primary keys in SQLite.
  • Integration tests are run against IBM DB2 on Travis CI.
  • Code coverage is collected for the Oracle platform on continuousphp.

Total issues resolved: 33

Deprecations:

New Features:

Bug Fixes:

Improvements:

Documentation Improvements:

Code Quality Improvements:

Continuous Integration Improvements:

Dependencies

dbal - v2.7.1

Published by morozov over 6 years ago

Release v2.7.1

Build Status

This release fixes unintentional BC breaks:

  1. It was impossible to use deprecated fetch modes with PDO-based drivers.
  2. An unsupported option passed to the Column object prevented subsequent options from being applied.
  3. Date interval values stored prior to upgrade to v2.7.0 were reported as invalid.

Total issues resolved: 10

Backwards Compatibility Fixes:

Documentation Improvements:

Continuous Integration Improvements:

dbal - v2.7.0

Published by morozov over 6 years ago

Build Status

This is a minor release of Doctrine DBAL that aggregates over 80 fixes and improvements developed over the last 8 months.

This release includes all changes of the 2.6.x series, as well as feature additions and improvements that couldn't land in patch releases.

Backwards Compatibility Breaks

This release comes with one potential Backwards Compatibility (BC) break that is to be considered during upgrade.
Please see the details below.

Dependency requirement changes

There are no changes in requirements to runtime dependencies.

Deprecations

  • Direct usage of PDO:: constants in calls to DBAL API is deprecated.
  • Calls to \PDOStatement methods on a \Doctrine\DBAL\Driver\PDOStatement instance are deprecated.
  • A series of enum-like constants are deprecated.
  • Setting unsupported options on a schema column object is deprecated.

Please see details in the UPGRADE.md documentation.

New features

This release introduces the following major additions:

  • MariaDB 10.2 platform support
  • PostgreSQL 10 platform support

Improvements and Fixes

This release comes with a few bug fixes and a significant set of improvements in continuous integration processes, code style and documentation:

  • The code is continuously tested on all supported versions of SQL Server on Windows and Linux.
  • The code is tested with lowest compatible versions of dependencies.
  • New improved code style requirements have been introduced.
  • The codebase has been cleaned up from the fragments required to support the older PHP versions and uses the full power of the PHP 7.1.
  • All pull requests are validated for compliance with the coding standards before getting accepted.
  • Handling of platform-specific features has been improved.

A detailed list of fixes can be found below.

Total issues resolved: 81

BC Breaks:

Deprecations:

New Features:

Bug Fixes:

Improvements:

Documentation Improvements:

Continuous Integration Improvements:

Code Style Improvements:

Chore:

dbal - v2.6.3

Published by lcobucci almost 7 years ago

Build Status

This release fixes the generation of default values of immutable date/datetime
times, default values of PostgreSQL's SERIAL types, and the required arguments
for SSL connections using MySQLi.

Also includes a fix for a BC-break related to json types comparison.

Total issues resolved: 11

Package Rankings
Top 0.02% on Packagist.org
Top 3.62% on Proxy.golang.org
Related Projects
PostgreSQLDoctrineBundle

Symfony bridge bundle for https://github.com/pfilsx/PostgreSQLDoctrine package

19 Dec 2022 4
doctrine-functions-psql

Doctrine DQL Functions for PostgreSQL

22 Oct 2014 6
soluble-dbwrapper

Extra minimalist but universal database wrapper

01 Jan 2016 7
PostgreSQLDoctrine

Provides extended Doctrine and Doctrine migrations PostgreSQL support with specific features such...

18 Dec 2022 2
doctrine-dbal

Well-integrated Doctrine DBAL for Nette Framework (@nette)

16 May 2017 30
power-lite-pdo

PowerLite PDO is a DBAL PDO Wrapper, a lightweight and powerful PHP library that provides an effi...

23 Mar 2024 10
dbal

Database Abstraction Layer – concise secure API to construct queries & fetch data

12 Jan 2015 77