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 - v2.6.2

Published by Ocramius about 7 years ago

Build Status

This release fixes an incorrect optimisation in
Doctrine\DBAL\Query\Expression\CompositeExpression which
could have led to dropping query expression components.

Also, DBAL was ignoring some important platform settings
when determining which cache keys to use when looking for
result caches: that could have led to sharing caches for
results produced by different DB connections.

Total issues resolved: 2

dbal - v2.6.1

Published by Ocramius about 7 years ago

Build Status

This release fixes an unintentional BC break that
prevented using DateTimeImmutable interfaces
in the pre-existing date-related types.

Users are still encouraged to migrate to the newly
introduced immutable date types.

Total issues resolved: 2

dbal - v2.6.0

Published by Ocramius about 7 years ago

Build Status

This is a minor release of Doctrine DBAL that aggregates over 200 fixes
and improvements that we have tested, checked, reviewed and stabilised
over the last year.

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

Backwards Compatibility Breaks

This release comes with few potential Backwards Compatibility (BC)
breaks that, while unlikely affecting consumers of the library, are
to be considered.
Please take some time to read the UPGRADE.md documentation.
The issues related to these BC breaks are listed below.

Dependency requirement changes

The dependency requirements for DBAL 2.6.0 onwards have also changed:

  • HHVM is no longer officially supported
  • PHP 7.1.0 is the minimum supported PHP version
  • The PDO extension is now a required dependency

Deprecations

  • The json_array type is now to be considered deprecated
  • The Doctrine\DBAL\Schema\Table#renameColumn() API is deprecated
    and disabled
  • The Doctrine\DBAL\Connection#getDatabasePlatform() may
    now trigger database connections, if a platform version
    isn't provided upfront

New features

This release introduces a few major additions:

  • PostgreSQL 9.4+ platform support
  • MySQL 5.7.9 (GA) platform support
  • A JsonType that maps to JSON column types when supported
    by the underlying RDBMS
  • DateIntervalType
  • DateTimeImmutableType
  • DateTimeTzImmutableType
  • DateImmutableType
  • TimeImmutableType
  • PDO::FETCH_OBJ emulation for mysqli and oci8
    statements
  • SSL root certificate configuration support for pdo_pgsql
  • SSL support for mysqli

Improvements and Fixes

This release comes with a myriad of improvements and
bug-fixes that should improve both compatibility with
exotic database engines and overall performance.
We focused on stability and reliability of
existing features, and improved the overall consistency
of cross-platform behavior of the library.

A detailed list of fixes can be found below.

Total issues resolved: 224

BC Breaks:

Deprecations:

New Features:

Bug Fixes:

Improvements:

Documentation Improvements:

Chore:

dbal - v2.5.13

Published by Ocramius about 7 years ago

Build Status

This release fixes a number of issues around the PostgreSQL,
OracleDB and MySQL platforms database introspection.

Connection DSN generation fixes were applied for the
SQLAnywhere driver.

Corrections on how record fetching mode have been applied to
the DB2 driver.

Fixes were applied to the handling of cursors and result
caching with pdo_sqlsrv.

Total issues resolved: 16

dbal - v2.5.12

Published by Ocramius over 7 years ago

Build Status

This release fixes some regressions introduced in OracleDB support in 2.5.11.
Specifically, closing a cursor caused an ORA-01002 exception to be raised
in some scenarios.

Further fixes include:

  • support for dropping "in use" databases in OracleDB and SQL Server (must disconnect first)
  • corrections in how the last insert ID is fetched on SQL Server
  • re-use of parameters bound to an sqlsrv statement via bindValue()

Total issues resolved: 8

dbal - v2.5.10

Published by Ocramius over 7 years ago

Build Status

This release fixes:

  • some PHP 5.3 compatibility issues that caused the test suite to fail
    for the previous release
  • index renaming for indexes that had particular assigned options, and
    that were being added rather than renamed or recreated under a different
    name
  • date and datetimetz OracleDB type introspection: these two types
    were incorrectly recognized as datetime

Total issues resolved: 4

dbal - v2.5.9

Published by Ocramius over 7 years ago

Build Status

This release fixes an issue with type information passed to Connection#update(),
which was incorrectly handled if the updated columns and the identifier columns
had equivalent keys.

Also, the generated current date and time SQL expressions for SQL Server were fixed.

Total issues resolved: 4

dbal - v2.5.8

Published by Ocramius almost 8 years ago

Build Status

This release fixes some issues around LIMIT/OFFSET handling in DB2, OracleDB, SQL Server:

  • Allowing LIMIT/OFFSET modification without LIMIT on OracleDB
  • Allowing LIMIT/OFFSET modification with OFFSET = 0 on DB2
  • Avoiding an accidental infinite loop in LIMIT/OFFSET modification on SQL Server

Total issues resolved: 4

dbal - v2.5.6

Published by Ocramius almost 8 years ago

Build Status

Total issues resolved: 1

dbal - v2.5.5

Published by Ocramius about 8 years ago

Build Status

Total issues resolved: 40

dbal - v2.5.2

Published by deeky666 about 9 years ago

Build Status

Total issues resolved: 24

dbal - v2.4.4

Published by deeky666 almost 10 years ago

Build Status

Total issues resolved: 9

dbal - v2.5.1

Published by deeky666 almost 10 years ago

Build Status

Total issues resolved: 24

dbal - v2.5.0

Published by beberlei almost 10 years ago

We are happy to announce the immediate availability of Doctrine DBAL 2.5.0 Stable. This release is a landmark in making DBAL more consistent and stable than it ever was.

Starting with 2.5 DBAL will have a new release-master, Steve Müller. Steve has been working on DBAL for the last two years and contributed many of the big features that make up this fantastic release. He will replace Benjamin Eberlei who was the release master since version 2.0.

You can install DBAL through Composer:

{
    "require": {
        "doctrine/dbal": "2.5.0"
    }
}

This version is mostly backwards compatible with only some minor breaks, when using PDO IBM, creating a custom platform or using non-default DateTime formats. You can see the breaks in the UPGRADE.md file. DBAL 2.5 is also compatible with ORM 2.4, there is no need to wait for ORM 2.5 to be released.

The following list contains the major new features of DBAL:

  • Support for SAP Sybase SQL Anywhere versions 10, 11, 12 and 16 (DBAL-475)
  • Support for auto-commit=NO on all drivers and platforms. (DBAL-81)
  • Refactor exceptions to use common error-codes and exception classes that derive from Doctrine\DBAL\DBALException. (DBAL-407)
  • Add support to retry connections with Doctrine\DBAL\Connection#ping() method. (DBAL-275)
  • Add INSERT support to QueryBuilder (DBAL-320)
  • Add Binary type for VARBINARY support (DBAL-714)
  • Add charset and SSL connection support to PostgreSQL (DBAL-567, DBAL-702)
  • Add options support for Myqli (DBAL-643)
  • Add support for using database uris with the url parameter in DriverManager::getConnection() which supports several forms used by PaaS providers out of the box (DBAL-1050).
  • Auto detection of platform to use based on database (DBAL-757)
  • Improved SQL Server LIMIT emulation support. (Multiple tickets)
  • Improvements to HHVM Support (no full support yet)

See all the changes for the 2.5.0 Release on Jira, an amazing total of 316 issues:

If you find any problems or backwards compatbililty breaks with this release please report them on JIRA or open up Pull Requests on Github.

Package Rankings
Top 0.02% on Packagist.org
Top 3.62% on Proxy.golang.org
Related Projects
doctrine-dbal

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

16 May 2017 30
dbal

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

12 Jan 2015 77
PostgreSQLDoctrine

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

18 Dec 2022 2
doctrine-functions-psql

Doctrine DQL Functions for PostgreSQL

22 Oct 2014 6
PostgreSQLDoctrineBundle

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

19 Dec 2022 4
power-lite-pdo

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

23 Mar 2024 10
soluble-dbwrapper

Extra minimalist but universal database wrapper

01 Jan 2016 7