NewYour coding agent can read the release notes before it upgrades.Set up the MCP server β
Packagist
Packagist, #2315 most downloaded on Packagist
πΎ Nette Database: layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle.
Latest stable
v3.2.10
Last release 25 days ago
27 Oct 2026
Ships fairly regularly
a new release about every 5 months
Nearly every release is documented
notes for 55 of 57 stable releases
Nothing withdrawn
no release was ever pulled
13 years old
58 releases Β· first in 2014
Drag across the ruler to compare, or tap a release to open it.
Ability to create drivers for additional PHP database extensions, not just PDO
convertBoolean, convertDateTime, and convertDecimalConnection::getInsertId() now returns integersconvertBoolean and newDateTime (returns date as Nette\Database\DateTime) are enabled by defaultIRow and IRowContainerConnection::getPdo() and getDsn()insert([]) now inserts a row of database defaults on PostgreSQL, SQLite and MS SQL too, not only on MySQL, so saving an empty form works on every engi
1/3 or 1e-11 reach the database exactly as they are in PHPint (#330)?and / ?or no longer leave their parameters behindwhere() identical to an existing JOIN condition is no longer dropped, and binary parameters no longer make distinct conditions collideisset() and offsetExists() give correct answers, including for falsy valuessearch_path (PostgreSQL)[ or ] are escaped correctly, and offset-only or zero-limit queries generate valid SQLpage() with less than one item per page, related() on a composite primary key, getInsertId() on a failed lazy connection, an unknown table in Reflection on SQLite, an unknown constant in the DI options; the ambiguous-reference message names the table, key and candidatesdsn, so key order in the config no longer mattersYour coding agent can read these notes before it upgrades. Set up the MCP server β
This release brings a set of focused exception types that let you catch specific database failure modes (deadlocks, lock timeouts, check constraint vi
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.
ActiveRow and Selection now expose the underlying Explorer instance, no more jumping through hoops to get back to itgetIndexes SQL, parameterized SQLite PRAGMA queries, and ForeignKey::$name is now a non-nullable stringOciDriver: in case of applyLimit with different offset returns always the same result
SqlPreprocessor: IN() inserts parameters directly and bypasses binding
IN() inserts parameters directly and bypasses bindingGroupedSelection::refreshData()deprecated Driver::SupportSubselect
Selection::fixedAssoc() silently deprecatedResultSet: added fetchList() as alias for fetchFields() & shortcuts
fetchList() as alias for fetchFields() & shortcutsResultSet::fetchAssoc() returns associative array by default, added shortcutsfetchList() as alias for fetchFields() & shortcutsResultSet::fetchAssoc() returns associative array by default, added shortcutsResultSet, Selection: fetchPairs() accepts callback
fetchPairs() accepts callbacknormalizeRow(): removed extra float handling #307Helpers::detectType() supports 'INT UNSIGNED'MySqlDriver::initialize() removed support for 'utf8' charset before 5.5.3SqlsrvDriver::applyLimit() removed support for SQL Server < 2012added reflection for Table, Column, Index, ForeignKey
added PHP 8 typehints, uses PHP 8.1 features
used PhpStorm Language attribute
composer: allows nette/utils 4.0
ConnectionPanel: detecting source without filesystem check
SqlTranslator: convert BackedEnum to scalar (thanks @milo)
normalizeRow() don't return small float as string #289getForeignKeys() #281ConnectionPanel::initialize() replaces Helpers::initializeTracy()getColumns() for materialized view tooqueryArgs() & ResultSet::getConnection() are silently deprecated
queryArgs() & ResultSet::getConnection() are silently deprecatedConnection, ResultSet: added custom row normalizer #138
Helpers::initializeTracy() does not create a panel in production modeConnection, Explorer: beginTransaction(), commit() & rollBack() calls are forbidden in transaction()
beginTransaction(), commit() & rollBack() calls are forbidden in transaction()Explorer::transaction() call can be nestedExplorer::transaction(): pass self as a callback argumentHelpers::initializeTracy() replaces createDebugPanel()SqlPreprocessor: default array mode is 'set' #268
For the details you can have a look at the diff.
deprecated interfaces IRow & IRowContainer
ConnectionPanel: added data-order to be sortable by time
@Tracy\BlueScreen nette/di#245For the details you can have a look at the diff.
Helpers: Fix dumpSql() for bool parameters
dumpSql() for bool parameters (#251)For the details you can have a look at the diff.
ConnectionPanel: params are useless for EXPLAIN
For the details you can have a look at the diff.
SqlPreprocessor: INSERT with multiple arrays is key-dependent #238
For the details you can have a look at the diff.
SqlPreprocessor: fixed casting to string
For the details you can have a look at the diff.
ResultSet: added workaround for PDO bug #38546
getBelongsToReference() return value fixFor the details you can have a look at the diff.
DatabaseExtension: uses configuration Schema
For the details you can have a look at the diff.
uses PHP 7.1 scalar and return type hints
::intNothing published for this version
Nothing published for this version
Fixed Selection::insert spoiling PDO:lastInsertId
For the details you can have a look at the diff.
Revert "DatabaseExtension: better detection of single/multiple definitions" #219
For the details you can have a look at the diff.
SqlBuilder: fixed compatiblity with PCRE2 used in PHP 7.3 #208 #210
getColumnTypes() to avoid excessive number of queries #212quote() 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
fetchFields()bindValue() (possible BC break)quote() returns false for ODBC driver #202getLastQueryString()For the details you can have a look at the diff.
Helpers::detectTypes() added support for TIMESTAMP WITH TIME ZONE in PostgreSQL #163
detectTypes() added support for TIMESTAMP WITH TIME ZONE in PostgreSQL #163 (#198)For the details you can have a look at the diff.
SqlBuilder: UPDATE supports ORDER BY
For the details you can have a look at the diff.
SqlPreprocessor: workaround for PDO bug #74996 when looking for ? in prepared query #177
? in prepared query #177For the details you can have a look at the diff.
fetchPairs() supports floats in keys
fetchPairs() supports floats in keysgetColumns() fix regexp for autoincrement recognition (#168)For the details you can have a look at the diff.
Insert to table with multi primary or without autoincrement primary
getInsertId() is normalized to stringformatLike() uses quote()For the details you can have a look at the diff.
SqlPreprocessor: escapes primary value of IRow #144
For the details you can have a look at the diff.
Connection: fifth argument is deprecated
page() for $page < 1 returns no rowsHelpers::detectType() uses more strict type patternsPgSqlDriver::getTables() returns materialized views (#136)SqlsrvDriver::formatDateTime(): format datetime by ISO 8601For the details you can have a look at the diff.
MySqlDriver: formatLike() uses quote()
formatLike() uses quote()For the details you can have a look at the diff.
SqlPreprocessor: escapes primary value of IRow #144
For the details you can have a look at the diff.
Helpers::detectType() detects DATERANGE as text
detectType() detects DATERANGE as textanalyzeForeignKeys() fixed lowercased name #122For the details you can have a look at the diff.
Selection::insert() fixed delimiting of FQN sequence name like 'aaa.bbb' #108
insert() fixed delimiting of FQN sequence name like 'aaa.bbb' #108For the details you can have a look at the diff.
Selection: Fixed infinite loop when accessing to deleted row
applyLimit() throws exception for negative values (but not when you use page())For the details you can have a look at the diff.
Row, ActiveRow: shows suggestions for undeclared columns
applyLimit(): supports keywords DISTINCT and ALL after SELECTFor the details you can have a look at the diff.
Selection: emptyResultSet invalidates referenced cache
fetchField()For the details you can have a look at the diff.
Helpers::loadFromFile() uses native exec() without logging and creating result set
loadFromFile() uses native exec() without logging and creating result setFor the details you can have a look at the diff.
Selection: Related prototype depends on specific cache key
For the details you can have a look at the diff.
ResultSet: parameters are passed to statement via bindValue with correct type #63
For the details you can have a look at the diff.
ActiveRow: added support to update primary columns via update() #57 #58
update() #57 #58formatDateInterval() #56getReferencedTable() always refetching when primary is NULLFor the details you can have a look at the diff.
Connection: undeprecated some methods
DriverException, ConnectionExceptionConstraintViolationException, ForeignKeyConstraintViolationException, NotNullConstraintViolationException and UniqueConstraintViolationException?and ?or ?set ?values ?order ?nameIRowContainer::fetchAssoc(), ISupplementalDriver::convertException() (BC break)Helpers::loadFromFile() uses native exec() without logging and creating result set
loadFromFile() uses native exec() without logging and creating result setgetReferencedTable() always refetching when primary is NULLFor the details you can have a look at the diff.
Connection: undeprecated some methods, partially reverts commit 88184104
formatLike() #46For the details you can have a look at the diff.
Helpers::dumpSql() quotes strings using connection
Helpers::dumpSql() quotes strings using connectionFor the details you can have a look at the diff.
DI: fixed autowiring for multiple connections
For the details you can have a look at the diff.
ResultSet: fix, empty keys are not converted to properties
For the details about the changes you can have a look at the Github diff.
The first standalone release. For more information see readme.md.
The first standalone release. For more information see readme.md.
One column per quarter.