database

• 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

• composer: allows nette/utils 4.0

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

• 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

• 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\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.