nette/database

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

• 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

• 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