joomla/database-3.1.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: 3.0.0...3.1.0

joomla/database-3.0.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: 2.1.1...3.0.0

joomla/database-2.1.1

What's Changed

• Drone by @nibra in #269

Full Changelog: 2.1.0...2.1.1

joomla/database-2.1.0

What's Changed

• Fix deprecated null parameter for string functions in the escape method of the drivers by @richard67 in #260
• Introduce DatabaseAware trait and interface by @laoneo in #262

Full Changelog: 2.0.2...2.1.0

joomla/database-2.0.2

What's Changed

• Only check types of postgres default values if set by @wilsonge in #259
  Fix preg_match gives a PHP deprecation warning in PHP 8.1, when a PostgreSQL column's default is null

Full Changelog: 2.0.1...2.0.2

Version 1.8.0

• 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

Database Package 1.7.1

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

Database Package 1.7.0

The following are pertinent changes made with this release:

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

Database Package 1.6.0

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
• #84 - Correct loading of table columns in MySQL import class
• #89 - Add ability to clear offset from query builder
• a332b87 - Fix issue with updating rows when using DatabaseDriver::updateObject()
• Miscellaneous code structure improvements and optimizations

Database Package 1.5.0

The following are pertinent changes made with this release:

• [META] Added AppVeyor CI support for the repository
• #38 - Prepared statement support for MySQLi
• #39 - Prepared statement support for PostgreSQL
• #40 - New PostgreSQL driver supporting PDO
• #78 - Prepared statement support for SQL Server
• 66035e4 - Prepared statement support for the PDO MySQL driver
• 3cb4670 - Allow defining a custom port and socket for MySQLi
• b5746dc - Extended group() function for the SQL Server query object
• 1234283 - Fix handling of default values in SqlsrvDriver::getTableColumns()
• 48e5395 - Escape comments in MySQL exporters
• 2ad24c1 - Fix limit handling in MySQL query objects
• 2533e8c - 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
• 5cc71aa - Correct error code detection for SQL Server driver