Database Laravel Package

This release brings a set of focused exception types that let you catch specific database failure modes (deadlocks, lock timeouts, check constraint violations, lost connections) instead of wrestling with generic driver errors. ActiveRow and Selection now expose getExplorer() for direct access to the underlying Explorer, and the reflection layer has been refactored for more consistent metadata across drivers.

✨ New Features

• getExplorer() – ActiveRow and Selection now expose the underlying Explorer instance, no more jumping through hoops to get back to it
• DeadlockException – catch deadlocks and serialization failures distinctly from other driver errors, so retry logic can stay surgical
• LockTimeoutException – a dedicated exception for lock wait timeouts
• CheckConstraintViolationException – check constraint violations now get their own class instead of being lumped with generic constraint errors
• ConnectionLostException – distinguish dropped connections from other driver failures, making reconnect strategies much cleaner
• Docker Compose setup – a ready-to-run Compose configuration for spinning up test databases locally

♻️ Code Refactoring

• Drivers reflection output – unified FK row shape across drivers, simplified MsSql getIndexes SQL, parameterized SQLite PRAGMA queries, and ForeignKey::$name is now a non-nullable string

📦 Maintenance

• Improved PHPDoc descriptions, phpDoc types, and native type declarations across the codebase

• support for PHP 8.5
• OciDriver: in case of applyLimit with different offset returns always the same result

• SqlPreprocessor: IN() inserts parameters directly and bypasses binding
• added GroupedSelection::refreshData()
• Reflection: added comment to Column and Table
• Structure: removed unused parameter

• fixed performance issue of ActiveRow #312
• ConnectionPanel: added whole stack trace listing
• ConnectionPanel: fixed source resolution
• ConnectionPanel: table does not exceed the window
• ConnectionPanel: convert templates to Latte-like syntax
• Selection: factory methods moved to Explorer
• SqlPreprocessor: added braces around where conditions
• SqlPreprocessor: fixed bugs in WHERE
• big refactoring of SqlPreprocessor
• deprecated Driver::SupportSubselect
• Selection::fixedAssoc() silently deprecated
• SQLite: column type can be omitted #315

• ResultSet: added fetchList() as alias for fetchFields() & shortcuts
• ResultSet::fetchAssoc() returns associative array by default, added shortcuts
• removed dead code

Main Features

• Ability to create drivers for additional PHP database extensions, not just PDO
• Merging of Connection & Explorer
• Improved control over data type transformation with options convertBoolean, convertDateTime, and convertDecimal

Changes

• Connection::getInsertId() now returns integers
• The options convertBoolean and newDateTime (returns date as Nette\Database\DateTime) are enabled by default
• Removed interfaces IRow and IRowContainer
• Removed methods Connection::getPdo() and getDsn()

• ResultSet, Selection: fetchPairs() accepts callback
• Selection: support for generics
• drivers: improved getting db structure
• Reflection improvements
• normalizeRow(): removed extra float handling #307
• Helpers::detectType() supports 'INT UNSIGNED'
• md5 replaced with xxHash
• removed return type 'never' to allow inheritance #303
• MySQL: supportBooleans renamed to convertBoolean
• PascalCase constants
• MySqlDriver::initialize() removed support for 'utf8' charset before 5.5.3
• Selection: fixed type error on empty aggregations #309
• SqlsrvDriver::applyLimit() removed support for SQL Server < 2012
• support for PHP 8.4

• added reflection for Table, Column, Index, ForeignKey
• returns date-time as immutable Nette\Database\DateTime (when 'newDateTime' is enabled) #270

• SqlTranslator: convert BackedEnum to scalar (thanks @milo)
• normalizeRow() don't return small float as string #289
• drivers: updated getForeignKeys() #281
• ConnectionPanel::initialize() replaces Helpers::initializeTracy()
• DatabaseExtension: creates service '.explorer' as alias to '.context'
• PgSqlDriver: support for partitioned tables (#286)
• PgSqlDriver: getColumns() for materialized view too
• coding style

• requires PHP 8.1
• added PHP 8 typehints, uses PHP 8.1 features
• MySqlDriver: DECIMAL with precision=0 is returned as int (BC break)
• normalizeRow: converts zero-date 0000-00-00 to NULL (BC break)
• normalizeRow: time columns resets date to 0001-01-01 (BC break)
• Numeric/decimal data type is detected as FIELD_DECIMAL
• MySqlDriver: TINYINT(1) is returned as bool (when 'supportBooleans' is enabled)

• support for PHP 8.3
• used PhpStorm Language attribute

• composer: allows nette/utils 4.0

• support for PHP 8.2
• ConnectionPanel: detecting source without filesystem check
• used #[\SensitiveParameter] to mark sensitive parameters
• cs

• support for PHP 8.1
• Fixed aggregations when group by and having conditions are used (#284)
• queryArgs() & ResultSet::getConnection() are silently deprecated

• Connection, ResultSet: added custom row normalizer #138
• Added support to PostgreSQL identity column (#277)
• Helpers::initializeTracy() does not create a panel in production mode

• Connection, Explorer: beginTransaction(), commit() & rollBack() calls are forbidden in transaction()
• Connection, Explorer::transaction() call can be nested
• Connection, Explorer::transaction(): pass self as a callback argument
• Revert "MySqlDriver driver uses subqueries (#265)"
• SqlPreprocessor: fixed handling 'IN (?)' #273
• fixed compatibility with Symfony DebugClassLoader #272
• improved phpDoc
• readme: updated badge
• Helpers::initializeTracy() replaces createDebugPanel()
• compatibility: improved code hinting

• SqlPreprocessor: default array mode is 'set' #268
• events: added default values & removed magic

For the details you can have a look at the diff.

• requires PHP 7.2
• SqlPreprocessor: support for IN ? and IN (?) [Closes #256]
• SqlPreprocessor::formatValue() rejects array unless they are explicitly allowed (possible BC break)
• Connection, Explorer: added transaction()
• MySqlDriver driver uses subqueries (#265)
• removed I from interface prefixes, ISupplementalDriver -> Driver
• renamed Nette\Database\Context -> Explorer
• deprecated interfaces IRow & IRowContainer

compatible with PHP 8.0

• compatible with PHP 8.0
• ConnectionPanel: added data-order to be sortable by time
• ConnectionPanel: Added performance colors (#258)
• DatabaseExtension: detects Tracy by presence of service [@Tracy](https://github.com/Tracy)\BlueScreen nette/di#245
• ConnectionPanel: bypasses SqlPreprocessor for explain to avoid double processing #259

For the details you can have a look at the diff.

• Fixed Selection::insert spoiling PDO:lastInsertId (#253)
• DatabaseExtension: better detection of single/multiple definitions vol 2 #219

For the details you can have a look at the diff.

• Helpers: Fix dumpSql() for bool parameters (#251)
• SqlPreprocessor: recoginzes (SELECT) UNION (SELECT) as parameteric command #248
• SqlPreprocessor: correctly escapes scalars when parameters are not used
• ConnectionPanel: uses capturing
• Revert "ConnectionPanel: params are useless for EXPLAIN"
• SqlPreprocessor: multi-insert accepts Row objects #247
• ResultSet: muted warnings
• Row: compatibility with operator ??

For the details you can have a look at the diff.

• ConnectionPanel: params are useless for EXPLAIN
• DriverException: added params, ConnectionPanel shows them
• DriverException: mimics original file&line of PDOException
• PgSqlDriver: stop using adsrc column (#242)

For the details you can have a look at the diff.

• supports PHP 7.4
• SqlPreprocessor: INSERT with multiple arrays is key-dependent #238
• ConnectionPanel - highlight INSERT|UPDATE|DELETE (#237)

For the details you can have a look at the diff.

• SqlPreprocessor: fixed casting to string
• Structure: foreign keys with less columns have bigger priority (#170)
• Structure tests: driver should return also name of foreign key constraint
• fixed typehint (#236)

For the details you can have a look at the diff.

• supports PHP 7.4
• Revert "DatabaseExtension: better detection of single/multiple definitions" #219

For the details you can have a look at the diff.

• ResultSet: added workaround for PDO bug #38546 (#231)
• SqlPreprocessor: generates IS NOT NULL (#226)
• Revert "Table: moved caching related functionality to separate classes (#185)"
• Structure::getBelongsToReference() return value fix
• Selection: typefix for referencing table primary key
• ResultSet: only format strings as floats (#228)
• SqlBuilder: Fixed loading arguments for left join conditions (#224)
• Use phpstan callable format (#220)

For the details you can have a look at the diff.

• DatabaseExtension: uses configuration Schema
• Revert "DatabaseExtension: better detection of single/multiple definitions" #219
• ConnectionPanel: fixed bad source file nette/tracy#346

For the details you can have a look at the diff.

Features

• requires PHP 7.1
• uses declare(strict_types=1)
• uses PHP 7.1 scalar and return type hints
• Helpers::loadFromFile added $onProgress
• SqlBuilder::tryDelimite() ignores casting ::int
• MsSql support for tables, columns, indexes, foreign keys (#215)
• Selection: fixed insert spoiling PDO:lastInsertId (#217)
• SqlBuilder: fixed compatiblity with PCRE2 used in PHP 7.3 [Closes #210]

Changes

• SqlPreprocessor: scalar are always passed via bindValue() (BC break)
• ResultSet: changed empty result return type of fetch() and fetchField() methods from FALSE to NULL [BC Break]
• removed unused ISupplementalDriver::normalizeRow() (BC break)
• removed unused ISupplementalDriver::formatBool()
• ISupplementalDriver: uncommented formatDateInterval() & getPrimaryAutoincrementKey()
• added ISupplementalDriver::initialize(), is used instead of constructor (BC break!)
• IRowContainer: Added method fetchField() (BC break)
• remove old sqlite2 driver (#155)
• removed meta info unsigned, onDelete, onUpdate
• Table: moved caching related functionality to separate classes (#185)

• SqlBuilder: fixed compatiblity with PCRE2 used in PHP 7.3 #208 #210
• PgSqlDriver: uses cache for getColumnTypes() to avoid excessive number of queries #212
• SqlPreprocessor: enables database parameters only for SELECT, INSERT, UPDATE, DELETE, REPLACE and EXPLAIN #211
• Connection::quote() throws exception on error (related to #202)

For the details you can have a look at the diff.

• Selection: Fixed accidental deletion of referenced cached rows when emptyResultSet is called (#187)(#207)
• SqlBuilder: added method resetSelect (#146)
• Fixed Helpers::dumpResult with non-string values (#204)
• Connection, Context: added fetchFields()
• SqlPreprocessor: strings are always passed via bindValue() (possible BC break)
• SqlPreprocessor: PDO::quote() returns false for ODBC driver #202
• OdbcDriver: doesn't support meta
• MySqlDriver: Fix PDO::ATTR_CASE (#199)
• added Connection::getLastQueryString()
• appveyor: is unable to start MSSQL 2008, 2012 & 2014 together

For the details you can have a look at the diff.