dbal

Changed since 5.0.0-rc3:

• Support PostgreSQL identity columns by @jiripudil in https://github.com/nextras/dbal/pull/236
• Fix SQL SRV capitalization of schema table names [d04066f0fff52142c22949070f2a81e9e3596a21] #237

Full Changelog: https://github.com/nextras/dbal/compare/v5.0.0-rc3...v5.0.0-rc4

Changes in this release:

• BackedEnum support for i, i[], s, s[] @mrceperka (https://github.com/nextras/dbal/pull/187)

🐛 Bug Fixes

• fix debug panel for PHP 8.1 [closes #166] thanks @radimvaculik for reporting

Full Changelog: https://github.com/nextras/dbal/compare/v4.0.3...v4.0.4

Changes in this release:

🚀 Features

• fixed support for PHP 8.1

New patch version 4.0.2 is out! ❄ What's changed from 4.0.1?

• mysql: fixed PHP 8.0 exception when accessing field during failed connection [3fe70c9e6d510114b61a52e17a9c6371ef8e2f02]

See full commit changelog.

You may support Nextras Orm by giving it a star here on GitHub ⭐ or by Sponsorship.
Thanks to sponsors! 🤗

New patch version 4.0.1 is out! 🎃 What's changed from 4.0.0?

• mysqli: fixed SSL setup to pass empty string instead of null [201a4cd8d7893c4d80d523fcfb005212308c1a15]

See full commit changelog.

You may support Nextras Orm by giving it a star here on GitHub ⭐ or by Sponsorship.
Thanks to sponsors! 🤗

The major 4.0.0 version is out! 🌺

What's new: ✔

• added support for Symfony (Bundle + DataCollector),
• reworked db reflection and added proper multi schema support,
• introduced new Logger for observing Connection events,
• added SSL support to MysqliDriver,
• allow specifying INDEX HINTS for MySQL in QueryBuilder,
• and many more small fixed & tuning.

BC breaks: ❗

• [[ and ]] are considered as escape sequence for ], [ respectively [6330fdd47ad26269d490c39287ff7502d58fe0e5];
• db reflection returns objects instead arrays [acbd9f72aa42bf1a37ca5a1408a1e179944263a7];
• CachedPlatform is moved to new location [bffed89267d39d8d2714c75342111b2fe4b52a04];
• added more native types to interfaces [a69cbafc39ea8f06c0129ec5adf69eda3e35c1ea];
• renamed Connection::getTransactionIndex to getTransactionNextedIndex [2da9cffdaba4553321df973e0f98de4ecfe323fc];
• Result::current() correctly do not return null when in invalid state [7545696d45030db88a5b8cc6a526876587097073];
• query builder has new join methods (with BC functionality) [91ff937306468afb79116cb23fea2a38669fbc7f];
• exceptions are moved to new location (with BC functionality) [bed5fb6a314ef249211e2a605c3a449d82dcfd95];

See full commit changelog since 3.1.2 version. 📃

The work and this release is sponsored - thanks to all donors. 💰

The release candidate of major 4.0.0 version is out!

What's new: ✔

• added support for Symfony (Bundle + DataCollector),
• reworked db reflection and added proper multi schema support,
• introduced new Logger for observing Connection events,
• added SSL support to MysqliDriver,
• allow specifying INDEX HINTS for MySQL in QueryBuilder,
• and many more small fixed & tuning.

BC breaks: ❗

• [[ and ]] are considered as escape sequence for ], [ respectively [6330fdd47ad26269d490c39287ff7502d58fe0e5];
• db reflection returns objects instead arrays [acbd9f72aa42bf1a37ca5a1408a1e179944263a7];
• exceptions are moved to new location [bed5fb6a314ef249211e2a605c3a449d82dcfd95];
• CachedPlatform is moved to new location [bffed89267d39d8d2714c75342111b2fe4b52a04];
• query builder has new join methods [91ff937306468afb79116cb23fea2a38669fbc7f];
• added more native types to interfaces [a69cbafc39ea8f06c0129ec5adf69eda3e35c1ea];
• renamed Connection::getTransactionIndex to getTransactionNextedIndex [2da9cffdaba4553321df973e0f98de4ecfe323fc];
• Result::current() correctly do not return null when in invalid state [7545696d45030db88a5b8cc6a526876587097073];

See full commit changelog since 3.1.2 version. 📃

The work and this release is sponsored - thanks to all donors. 💰

The first RC of 3.2.0 version is out!

What's new:

• reworked fetching foreign keys' in/out FQN table names (Mysql,Postgres); thanks @Matys [bb857851f64d33314fb7770e1bfa6f242e63b2dc][35941fe07c9de9b4385617900a2990e7b2d8dddc][8d93d9e1e529b30335ae1bcb77828ff20998f9eb]
• fixed setting transaction isolation level; thanks @repli2dev [33150ace3f459989d3b11a86bfbdf88a9ffa7da2]
• fixed support for PHP 7.4 & Postgres 12; thanks @HonzaMatosik and @JanTvrdik [9e4022a9d887ce79e6790725d8d33703b381e946][9e4022a9d887ce79e6790725d8d33703b381e946]
• see full commit changelog since version 3.1.

Patch version 3.1.2 is out! ❄️

What's new:

• fixed PostgreSQL 12 support, thanks @HonzaMatosik [884431eb074bebab8dd2bdfb7b68055a78ecabbb]
• see full commit changelog

Patch version 3.1.1 is out! 🌔

What's new:

• fixed PHP 7.4 support, thanks @JanTvrdik [88c8ce8a2c63516b0ce42d01c2e8fa8773dc3380]
• fixed transaction counter overflow, #75 & #76
• see full commit changelog

Next minor version 3.1.0 is out! 🥜

What's new:

• Dbal is now for PHP 7.1+;
• added type hints for interfaces and many user-facing API (BC break!) [77587e7d04b578f09a24061557543785c11df55d];
• Connection::query() always returns a Result object [b2c884ba6d9c1e36382e483ef0c5530f40f3903f];
• added support for Nette 3.0;
• fixed few bugs (caching, setting connectionTz in Postgre) and few more enhancements;

See full commit changelog since version 3.0.

You may support Nextras Dbal & Orm development by attending Akademie42 training.

The new major 3.0.0 version is out! 🎉 🍐

Notable BC breaks:

• Library requires PHP 7.0+ version.
• Date-time fields are converted to DateTimeImmutable instances.
• Date-time changes: %dts does not do any timezone modifications (removed simpleStorageTz), read more in documentation and see the usage matrix.
• Connection::ping() does not connect when there is no connection.

Notable features & changes:

• Connection: added nested transactions & save-points.
• Connection: added setter for transaction isolation level.
• Added %json modifier.
• Added IConnection interface.
• Added factory for SqlProcessor.
• Added SqlSrv driver & MSSQL support.
• Enhanced Tracy's panel - added elapsed time, explain, updated visual design.
• See full commit changelog since 2.1 version.

See 3.0 changes in RC1 release notes.

Changes since RC1:

• CachedPlatform requires IPlatform instead of Connection (BC break!)
• more Connection methods moved to IConnection (BC break!)
• Row: removed numerical array access (BC break!), see #55
• SQL Server: fixed unique constraint violation detection
• SQL Server: disable explain queries for debug panel
• PHPDOC fixes, PHP 7.2 CI testing, aded PhpStan analyzer
• See full commit changelog since 3.0-RC1 version.

I'm really sorry for BC breaks in the RC phase, will do better next time.

The first RC of 3.0.0 is out.

Notable BC breaks:

• Library requires PHP 7.0+ version.
• Date-time fields are converted to DateTimeImmutable instances.
• Date-time changes: %dts does not do any timezone modifications (removed simpleStorageTz), read more in documentation and see the usage matrix.
• Connection::ping() does not connect when connection is not connected.

Notable features & changes:

• Connection: added nested transactions & savepoints.
• Connection: added setter for transation isolation level.
• Added %json modifier.
• Added IConnection interface.
• Added factory for SqlProcessor.
• Added SqlSrv driver & MSSQL support.
• Enhanced Tracy's panel - added elapsed time, explain, updated visual design.
• See full commit changelog since 2.1 version.

Next minor version 2.1.0 is out! 🍓

• enhanced documentation (yay!)
• Connection::transactional() returns callable's returned value, thanks @jakubkulhan [36d2d44031916e9656deb6acf9b4411e6cf101f3]
• added numeric index access for Row [1eb2feec7cc191fa8f8625243bc06625d322e583]
• fixed storing DateInterval value, thanks @f3l1x [21271220538ee191ed4ca0038ca0745e01654cb2]
• See full commit changelog since version 2.0.

Next major version 2.0.0 is out! 🍎 🎉

• BC breaks:
  • minimal PHP version is 5.5 [c6b199b17add9cf4f265e90ca73c0c12898c6307]
  • changed signature of IPlatform [91fe03f5d56e753cf34f01f0fb838847f22af568, fe3f3f815c60e7160915a0b8497086e2f6573fe4]
  • changed signature of IDriver, convertToSql() method was splitted [a28ba0585f32f999558bb5d6ed5d43ae9d4debe9]
  • changed behavior of %column[] and %table[] modifiers, no parenthesis are added, #31 [e433127e0497a0fa4446be58979c039e5f5e643f]
• New features:
  • Nette Extension: added support for multiple instances with autowired [bc406a8989924c52b95e00cb370cefd834d72192]
  • SqlProcessor: added %_like_ placeholder, #9 [00a18336ac4c846853d62bf3382ca42b4fa18ff2]
  • SqlProcessor: added support for insert into table with all default values [96698e0fc8beb7358da537285fc18a4575c0140c]
  • Connection::queryArgs accepts only an array [7a3474a06a865c727a9d361bb1062b1e7ec9ff7f]
  • added QueryBuilder::getLimitOffsetClause() [2a89af20f221d8227ea8b6519abbefb9e032fbce]
  • added IPlatform::getSequenceName() [91fe03f5d56e753cf34f01f0fb838847f22af568]
  • added IPlatform::getName() [fe3f3f815c60e7160915a0b8497086e2f6573fe4]
  • added CachedPlafom [ccbfd487bcbc5a6d5ebbd76e0ded487663e7e29e]
• See full commit changelog since version 1.1.

Next major beta version 2.0.0-rc1 is out!

• No changes since 2.0.0-beta3.
• See full commit changelog since v1.1

Next major beta version 2.0.0-beta2 is out! What's changed?

• additions:
  • added IPlatform::getName();
  • added IPlatform::getPrimarySequenceName();
  • added CachedPlatform class;
• see full commit changelog

Bugfix version 1.1.1 is out! 🍏 : What's new?

• fixes:
  • fixed %i[] placeholder on maps, thanks @Mikulas [bde5971aba2265c079e3b614dad83965ead9e8dd]
• see full commit changelog