tag:github.com,2008:https://github.com/nette/database/releasesRelease notes from database2025-10-30T22:07:14Ztag:github.com,2008:Repository/17713908/v3.2.82025-10-30T22:07:24ZReleased version 3.2.8<ul>
<li>support for PHP 8.5</li>
<li>OciDriver: in case of applyLimit with different offset returns always the same result</li>
</ul>dgtag:github.com,2008:Repository/17713908/v3.2.72025-06-03T05:03:09ZReleased version 3.2.7<ul>
<li>SqlPreprocessor: <code>IN()</code> inserts parameters directly and bypasses binding</li>
<li>added <code>GroupedSelection::refreshData()</code></li>
<li>Reflection: added comment to Column and Table</li>
<li>Structure: removed unused parameter</li>
</ul>dgtag:github.com,2008:Repository/17713908/v3.2.62025-01-12T15:40:49ZReleased version 3.2.6<ul>
<li>fixed performance issue of ActiveRow <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="2492544231" data-permission-text="Title is private" data-url="https://github.com/nette/database/issues/312" data-hovercard-type="issue" data-hovercard-url="/nette/database/issues/312/hovercard" href="https://github.com/nette/database/issues/312">#312</a></li>
<li>ConnectionPanel: added whole stack trace listing</li>
<li>ConnectionPanel: fixed source resolution</li>
<li>ConnectionPanel: table does not exceed the window</li>
<li>ConnectionPanel: convert templates to Latte-like syntax</li>
<li>Selection: factory methods moved to Explorer</li>
<li>SqlPreprocessor: added braces around where conditions</li>
<li>SqlPreprocessor: fixed bugs in WHERE</li>
<li>big refactoring of SqlPreprocessor</li>
<li>deprecated Driver::SupportSubselect</li>
<li><code>Selection::fixedAssoc()</code> silently deprecated</li>
<li>SQLite: column type can be omitted <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="2755832295" data-permission-text="Title is private" data-url="https://github.com/nette/database/issues/315" data-hovercard-type="issue" data-hovercard-url="/nette/database/issues/315/hovercard" href="https://github.com/nette/database/issues/315">#315</a></li>
</ul>dgtag:github.com,2008:Repository/17713908/v3.2.52024-12-18T19:14:21ZReleased version 3.2.5<ul>
<li>ResultSet: added <code>fetchList()</code> as alias for <code>fetchFields()</code> & shortcuts</li>
<li><code>ResultSet::fetchAssoc()</code> returns associative array by default, added shortcuts</li>
<li>removed dead code</li>
</ul>dgtag:github.com,2008:Repository/17713908/v4.0.0-RC12024-08-29T05:10:49ZReleased version 4.0.0 RC 1<h2>Main Features</h2>
<ul>
<li>Ability to create drivers for additional PHP database extensions, not just PDO</li>
<li>Merging of Connection & Explorer</li>
<li>Improved control over data type transformation with options <code>convertBoolean</code>, <code>convertDateTime</code>, and <code>convertDecimal</code></li>
</ul>
<h2>Changes</h2>
<ul>
<li><code>Connection::getInsertId()</code> now returns integers</li>
<li>The options <code>convertBoolean</code> and <code>newDateTime</code> (returns date as <code>Nette\Database\DateTime</code>) are enabled by default</li>
<li>Removed interfaces <code>IRow</code> and <code>IRowContainer</code></li>
<li>Removed methods <code>Connection::getPdo()</code> and <code>getDsn()</code></li>
</ul>dgtag:github.com,2008:Repository/17713908/v3.2.42024-08-28T01:03:46ZReleased version 3.2.4<ul>
<li>ResultSet, Selection: <code>fetchPairs()</code> accepts callback</li>
<li>Selection: support for generics</li>
<li>drivers: improved getting db structure</li>
<li>Reflection improvements</li>
<li><code>normalizeRow()</code>: removed extra float handling <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="2279432887" data-permission-text="Title is private" data-url="https://github.com/nette/database/issues/307" data-hovercard-type="issue" data-hovercard-url="/nette/database/issues/307/hovercard" href="https://github.com/nette/database/issues/307">#307</a></li>
<li><code>Helpers::detectType()</code> supports 'INT UNSIGNED'</li>
<li>md5 replaced with xxHash</li>
<li>removed return type 'never' to allow inheritance <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="2043141207" data-permission-text="Title is private" data-url="https://github.com/nette/database/issues/303" data-hovercard-type="issue" data-hovercard-url="/nette/database/issues/303/hovercard" href="https://github.com/nette/database/issues/303">#303</a></li>
<li>MySQL: supportBooleans renamed to convertBoolean</li>
<li>PascalCase constants</li>
<li><code>MySqlDriver::initialize()</code> removed support for 'utf8' charset before 5.5.3</li>
<li>Selection: fixed type error on empty aggregations <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="2463257410" data-permission-text="Title is private" data-url="https://github.com/nette/database/issues/309" data-hovercard-type="pull_request" data-hovercard-url="/nette/database/pull/309/hovercard" href="https://github.com/nette/database/pull/309">#309</a></li>
<li><code>SqlsrvDriver::applyLimit()</code> removed support for SQL Server < 2012</li>
<li>support for PHP 8.4</li>
</ul>dgtag:github.com,2008:Repository/17713908/v3.2.12024-05-07T19:29:25ZReleased version 3.2.1<ul>
<li>added reflection for Table, Column, Index, ForeignKey</li>
<li>returns date-time as immutable Nette\Database\DateTime (when 'newDateTime' is enabled) <a class="issue-link js-issue-link" data-error-text="Failed to load title" data-id="809621995" data-permission-text="Title is private" data-url="https://github.com/nette/database/issues/270" data-hovercard-type="issue" data-hovercard-url="/nette/database/issues/270/hovercard" href="https://github.com/nette/database/issues/270">#270</a></li>
</ul>dgtag:github.com,2008:Repository/17713908/v3.2.02023-12-14T20:03:49ZReleased version 3.2.0<ul>
<li>requires PHP 8.1</li>
<li>added PHP 8 typehints, uses PHP 8.1 features</li>
<li>MySqlDriver: DECIMAL with precision=0 is returned as int (BC break)</li>
<li>normalizeRow: converts zero-date 0000-00-00 to NULL (BC break)</li>
<li>normalizeRow: time columns resets date to 0001-01-01 (BC break)</li>
<li>Numeric/decimal data type is detected as FIELD_DECIMAL</li>
<li>MySqlDriver: TINYINT(1) is returned as bool (when 'supportBooleans' is enabled)</li>
</ul>dgtag:github.com,2008:Repository/17713908/v3.1.92023-11-05T19:45:35ZReleased version 3.1.9<ul>
<li>support for PHP 8.3</li>
<li>used PhpStorm Language attribute</li>
</ul>dgtag:github.com,2008:Repository/17713908/v3.1.72023-02-02T10:58:59ZReleased version 3.1.7<ul>
<li>composer: allows nette/utils 4.0</li>
</ul>dg