Database Laravel Package

What's Changed

• Remove escape when not with string by @kamil-tekiela in https://github.com/joomla-framework/database/pull/353
• Fix MysqliStatement to work with named params by @kamil-tekiela in https://github.com/joomla-framework/database/pull/351
• Add mysqli exception mode by @kamil-tekiela in https://github.com/joomla-framework/database/pull/349
• Remove all redundant references by @kamil-tekiela in https://github.com/joomla-framework/database/pull/350
• [3.x] fix unit tests MSSQL (Windows) by @heelc29 in https://github.com/joomla-framework/database/pull/359

New Contributors

• @kamil-tekiela made their first contribution in https://github.com/joomla-framework/database/pull/353

Full Changelog: https://github.com/joomla-framework/database/compare/3.4.3...3.4.4

Minimum requirement was raised to PHP 8.3 PHPUnit has been updated to version 12 Minimum supported database versions raised Removed quoteNameStr DatabaseInterface: createQuery method Removed deprecated LimitableInterface and PreparableInterface Removed deprecated DatabaseQuery::castAsChar()

Full Changelog: https://github.com/joomla-framework/database/compare/3.4.3...4.0.0

What's Changed

• Switching to Github Actions for CI by @Hackwar in https://github.com/joomla-framework/database/pull/341
• Remove developer only files from build by @richard67 with commit https://github.com/joomla-framework/database/commit/6a8aedaea444cd78912153c4d8361eb06ba2a9cd

Full Changelog: https://github.com/joomla-framework/database/compare/3.4.2...3.4.3

What's Changed

• [3.x] mysqli::ping is deprecated since php8.4 by @AkameOuO in https://github.com/joomla-framework/database/pull/324

Full Changelog: https://github.com/joomla-framework/database/compare/3.4.1...3.4.2

What's Changed

• [3.x] Fix undefined property error from PR #335 by @richard67 in https://github.com/joomla-framework/database/pull/337
• [3.x] Use $this->quoteNameString instead of quoteNameString by @Hackwar in https://github.com/joomla-framework/database/pull/338

Full Changelog: https://github.com/joomla-framework/database/compare/3.4.0...3.4.1

What's Changed

• [2.x] Use $this->quoteNameString() instead of quoteNameString() by @Hackwar in https://github.com/joomla-framework/database/pull/339

Full Changelog: https://github.com/joomla-framework/database/compare/2.2.0...2.2.1

What's Changed

• Update SqlsrvDriver.php by @Kenneth202212 in https://github.com/joomla-framework/database/pull/281
• add .git-blame-ignore-revs file for coding style commits by @AkameOuO in https://github.com/joomla-framework/database/pull/323
• Don't include .git-blame-ignore-revs file in distribution package by @AkameOuO in https://github.com/joomla-framework/database/pull/334
• [2.x] Replace incorrect working quoteNameStr method by @HLeithner in https://github.com/joomla-framework/database/pull/328
• [2.x] PR 281 follow up - cast boolean option and fix code style by @richard67 in https://github.com/joomla-framework/database/pull/333
• [3.x] Replace incorrect working quoteNameStr method by @HLeithner in https://github.com/joomla-framework/database/pull/329
• [3.x] Add collation to getAlterDbCharacterSet method of MySQLi and MySQL (PDO) drivers by @richard67 in https://github.com/joomla-framework/database/pull/331
• [3.x] PR 300 follow up - Use ROW_NUMBER() windows function whenever supported by @richard67 in https://github.com/joomla-framework/database/pull/335
• [3.x] Upmerge changes from 2.0-dev 2025-03-30 by @richard67 in https://github.com/joomla-framework/database/pull/336

New Contributors

• @Kenneth202212 made their first contribution in https://github.com/joomla-framework/database/pull/281
• @AkameOuO made their first contribution in https://github.com/joomla-framework/database/pull/323

Full Changelog: https://github.com/joomla-framework/database/compare/3.3.1...3.4.0

What's Changed

• Fix PHPDoc return by @janschoenherr in https://github.com/joomla-framework/database/pull/272
• php 8.2 - dynamic property deperecation by @alikon in https://github.com/joomla-framework/database/pull/273
• Properly defining variable by @Hackwar in https://github.com/joomla-framework/database/pull/275
• Replace getQuery(true) with createQuery(), deprecate $new parameter by @HLeithner in https://github.com/joomla-framework/database/pull/274
• Exporter: Handle NULL values properly by @Hackwar in https://github.com/joomla-framework/database/pull/286
• Add option "trust_certificate" to SqlsrvDriver.php by @Kenneth202212 in https://github.com/joomla-framework/database/pull/281
• [2.x] Replace incorrect working quoteNameStr method by @HLeithner in https://github.com/joomla-framework/database/pull/328
• [2.x] PR 281 follow up - cast boolean option and fix code style by @richard67 in https://github.com/joomla-framework/database/pull/333

Changes only relevant in development environment

• Fix composer setup for Drone by @Hackwar in https://github.com/joomla-framework/database/pull/276
• Cleanup of Appveyor configuration by @Hackwar in https://github.com/joomla-framework/database/pull/277
• Drone: Fixing MSSQL, removing phpcpd & phpmd by @Hackwar in https://github.com/joomla-framework/database/pull/288

New Contributors

• @janschoenherr made their first contribution in https://github.com/joomla-framework/database/pull/272
• @Kenneth202212 made their first contribution in https://github.com/joomla-framework/database/pull/281

Full Changelog: https://github.com/joomla-framework/database/compare/2.1.1...2.2.0

Fix [@since](https://github.com/since) tag for new method extractHostPortSocket from version 3.3.0.

Full Changelog: https://github.com/joomla-framework/database/compare/3.3.0...3.3.1

What's Changed

• [3.x] Allow to specify port number or UNIX socket in host option also for MySQL (PDO) and PostgreSQL (PDO) by @richard67 in https://github.com/joomla-framework/database/pull/310
• [3.x] Use directory Tests/Sqlsrv in phpunit.appveyor_sql2017.xml.dist to fix failing AppVeyor by @richard67 in https://github.com/joomla-framework/database/pull/319
• [3.x] Remove square brackets from ipv6 host on PostgreSQL, refactor changes from PR 310 and move options modifications to constructor by @richard67 in https://github.com/joomla-framework/database/pull/317

Full Changelog: https://github.com/joomla-framework/database/compare/3.2.1...3.3.0

What's Changed

Fix error unrecognized configuration parameter "lc_collate" on PostgreSQL >= 16

Full Changelog: https://github.com/joomla-framework/database/compare/3.2.0...3.2.1

What's Changed

• Use row_number window function on MariaDB >= 11
• Adding ability to zip export of multiple tables
• Cleanup non-release related files
• Improve PHP 8.4 compatibility
• Add testcoverage for PHP 8.3

Full Changelog: https://github.com/joomla-framework/database/compare/3.1.0...3.2.0

What's Changed

• getTableList() return only tables not views
• Add support for duplicate named query parameters for the mysqli and sqlsrv driver

Full Changelog: https://github.com/joomla-framework/database/compare/3.0.0...3.1.0

What's Changed

• Raised minimum PHP version to 8.1
• Switched to PSR-12 codestyle
• add createQuery() as replacement for getQuery(true)
• DatabaseExporter/Importer: handle NULL values properly

Full Changelog: https://github.com/joomla-framework/database/compare/2.1.1...3.0.0

What's Changed

• Drone by @nibra in https://github.com/joomla-framework/database/pull/269

Full Changelog: https://github.com/joomla-framework/database/compare/2.1.0...2.1.1

What's Changed

• Fix deprecated null parameter for string functions in the escape method of the drivers by @richard67 in https://github.com/joomla-framework/database/pull/260
• Introduce DatabaseAware trait and interface by @laoneo in https://github.com/joomla-framework/database/pull/262

Full Changelog: https://github.com/joomla-framework/database/compare/2.0.2...2.1.0

What's Changed

• Only check types of postgres default values if set by @wilsonge in https://github.com/joomla-framework/database/pull/259 Fix preg_match gives a PHP deprecation warning in PHP 8.1, when a PostgreSQL column's default is null

Full Changelog: https://github.com/joomla-framework/database/compare/2.0.1...2.0.2

• Reliable Camel Case of function variables for PHP 8
• Bug Fix for for the database importer
• DatabaseQuery::castAsChar now has a len param that allows defining the length of the char
• PHP 7.4 fixes for the Oracle Driver
• Allow other schema than "public" on PostgreSQL databases

• Fixed PHP 7.4 compatibility
• Improve return type hints that previously documented mixed to be more specific
• Various test setup improvements

The following are pertinent changes made with this release:

• [META] Added test coverage with MariaDB as a backend MySQL server
• https://github.com/joomla-framework/database/pull/138 - Remove explicit quoting of values given to DatabaseQuery::dateAdd()
• https://github.com/joomla-framework/database/pull/142 - Add QueryElement::getName() method
• https://github.com/joomla-framework/database/pull/149 - Add support for quoting binary values
• Miscellaneous code structure improvements and optimizations

The following are pertinent changes made with this release:

• [META] Expanded test integrations for additional platform coverage
• Deprecated PDO Oracle Driver
• Deprecated native PostgreSQL Driver, use PDO PostgreSQL instead
• https://github.com/joomla-framework/database/pull/84 - Correct loading of table columns in MySQL import class
• https://github.com/joomla-framework/database/pull/89 - Add ability to clear offset from query builder
• https://github.com/joomla-framework/database/commit/a332b876a14f01b64878c8774e55e91860c87b27 - Fix issue with updating rows when using DatabaseDriver::updateObject()
• Miscellaneous code structure improvements and optimizations

The following are pertinent changes made with this release:

• [META] Added AppVeyor CI support for the repository
• https://github.com/joomla-framework/database/pull/38 - Prepared statement support for MySQLi
• https://github.com/joomla-framework/database/pull/39 - Prepared statement support for PostgreSQL
• https://github.com/joomla-framework/database/pull/40 - New PostgreSQL driver supporting PDO
• https://github.com/joomla-framework/database/pull/78 - Prepared statement support for SQL Server
• https://github.com/joomla-framework/database/commit/66035e44f523bb0259aadb0e544fc8cf63e686d2 - Prepared statement support for the PDO MySQL driver
• https://github.com/joomla-framework/database/commit/3cb4670ab1a9992dcaad6f12550efe8994bd6326 - Allow defining a custom port and socket for MySQLi
• https://github.com/joomla-framework/database/commit/b5746dcf6f8a5a22bc533418620d253232b42e9e - Extended group() function for the SQL Server query object
• https://github.com/joomla-framework/database/commit/12342836bec1bbfd286e53bdb15af5822bcdbcaf - Fix handling of default values in SqlsrvDriver::getTableColumns()
• https://github.com/joomla-framework/database/commit/48e5395d773d45042d57961a8faafe0a2da68c21 - Escape comments in MySQL exporters
• https://github.com/joomla-framework/database/commit/2ad24c11a8dd2708b0a59a6810051d3026f55ccb - Fix limit handling in MySQL query objects
• https://github.com/joomla-framework/database/commit/2533e8cb62c9dbccc078bd48e98f906ee2baf83d - Add Exception subclasses for different error conditions (NOTE: This removes the failed SQL query from the Exception message; if it is needed check either the log attached to your database driver or call the getQuery() method of the thrown ExecutionFailureException object
• https://github.com/joomla-framework/database/commit/5cc71aa2a128a3dd389082cf0067e5f9142b1fe6 - Correct error code detection for SQL Server driver

The following are pertinent changes made with this release:

• Restructure package for PSR-4 support

The following are pertinent changes made with this release:

• https://github.com/joomla-framework/database/pull/6 - Skip fields in an object that aren't part of a table in insertObject and updateObject methods
• https://github.com/joomla-framework/database/pull/7 - PostgreSQL driver's insertObject method will now ignore primary keys with a zero value
• https://github.com/joomla-framework/database/pull/8 - PostgreSQL driver's getTableColumns return now emulates the return from the MySQL drivers
• https://github.com/joomla-framework/database/commit/a745ad02f18f1ff7afb2b6ae0418af31cbb1b096 - PDO MySQL driver's lockTable() method issued an empty query

The following are pertinent changes made with this release:

• https://github.com/joomla-framework/database/pull/13 - Fix PHP warning in MySQLi driver's destructor
• https://github.com/joomla-framework/database/commit/bad8825c32de50430884b96a059515a45c034fbd - Cleaning up duplicated logic in the database importers, deprecated PostgresqlImporter::getIdxLookup() in favor of PostgresqlImporter::getKeyLookup() for API consistency

This release fixes one bug:

• https://github.com/joomla-framework/database/commit/775d5c058f4d17fb3de64750167bb6f19ec70bef - Missing truncateTable() implementation for SQLite driver

The following are pertinent changes made with this release:

• https://github.com/joomla-framework/database/pull/21 - Use existing API to replace table prefix in the database importer
• https://github.com/joomla-framework/database/pull/22 - Use logging from the database driver in the database importer
• https://github.com/joomla-framework/database/pull/27 - Make sure the database exporter's __toString() method doesn't throw an Exception
• https://github.com/joomla-framework/database/pull/31 - Add logging on database connection errors
• https://github.com/joomla-framework/database/pull/35 - Add andWhere, orWhere, and extendWhere methods to DatabaseQuery
• https://github.com/joomla-framework/database/commit/663b59491212fcf953801fe7dd47fedc5b9215da - Made mergeStructure() method of the database importer public

The following are pertinent changes made with this release:

• https://github.com/joomla-framework/database/pull/24 - Add missing method in MySQL importer
• https://github.com/joomla-framework/database/pull/25 - Remove hardcoded default character set in MySQL importer
• https://github.com/joomla-framework/database/pull/32 - Remove duplicate connection error checks
• https://github.com/joomla-framework/database/pull/36 - Don't set the sql_mode to empty in MySQLi
• https://github.com/joomla-framework/database/pull/37 - Add support for MySQL's utf8mb4 charset
• https://github.com/joomla-framework/database/commit/02fe1106c960a4ed288d16e5dd27fe20bfef1ef5 - Move tests to autoload-dev in Composer
• https://github.com/joomla-framework/database/commit/327f6f0ec103a5fea13c1eec09b4261e8203a19f - Deprecated the singleton instance of DatabaseFactory
• https://github.com/joomla-framework/database/commit/38e3e738bd8d35af9d9b9248527446bbf6de1fcd - Improve database collation checks for MySQL drivers
• https://github.com/joomla-framework/database/commit/1b0e757bbf57657fb7a4e99199c42e45a354611f - Fix handling for some comment types in splitSql(), backports https://github.com/joomla/joomla-cms/pull/9137
• https://github.com/joomla-framework/database/commit/d82d629615b4e607d264a235818d8db5ad1f7e6c - Additional comment handling in splitSql(), backports https://github.com/joomla/joomla-cms/pull/9369
• https://github.com/joomla-framework/database/commit/007fafb4123e4021e1d184d67df498381ad7c9b7 - Added server type detection

This release fixes one bug:

• https://github.com/joomla-framework/database/commit/c8e6bf9b3c7ad04d205b563d6e5f012ec5cb9a9b - Missing global namespace declarations for PDO MySQL driver

This version is identical to 1.4.0 and was mistagged due to an integration server error.