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

Database Package 1.4.2

This release fixes one bug:

• c8e6bf9 - Missing global namespace declarations for PDO MySQL driver

Database Package 1.4.1

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

Database Package 1.4.0

The following are pertinent changes made with this release:

• #24 - Add missing method in MySQL importer
• #25 - Remove hardcoded default character set in MySQL importer
• #32 - Remove duplicate connection error checks
• #36 - Don't set the sql_mode to empty in MySQLi
• #37 - Add support for MySQL's utf8mb4 charset
• 02fe110 - Move tests to autoload-dev in Composer
• 327f6f0 - Deprecated the singleton instance of DatabaseFactory
• 38e3e73 - Improve database collation checks for MySQL drivers
• 1b0e757 - Fix handling for some comment types in splitSql(), backports joomla/joomla-cms#9137
• d82d629 - Additional comment handling in splitSql(), backports joomla/joomla-cms#9369
• 007fafb - Added server type detection

Database Package 1.3.0

The following are pertinent changes made with this release:

• #21 - Use existing API to replace table prefix in the database importer
• #22 - Use logging from the database driver in the database importer
• #27 - Make sure the database exporter's __toString() method doesn't throw an Exception
• #31 - Add logging on database connection errors
• #35 - Add andWhere, orWhere, and extendWhere methods to DatabaseQuery
• 663b594 - Made mergeStructure() method of the database importer public

Database Package 1.2.1

This release fixes one bug:

• 775d5c0 - Missing truncateTable() implementation for SQLite driver

Database Package 1.2.0

The following are pertinent changes made with this release:

• #13 - Fix PHP warning in MySQLi driver's destructor
• bad8825 - Cleaning up duplicated logic in the database importers, deprecated PostgresqlImporter::getIdxLookup() in favor of PostgresqlImporter::getKeyLookup() for API consistency

Database Package 1.1.2

The following are pertinent changes made with this release:

• #6 - Skip fields in an object that aren't part of a table in insertObject and updateObject methods
• #7 - PostgreSQL driver's insertObject method will now ignore primary keys with a zero value
• #8 - PostgreSQL driver's getTableColumns return now emulates the return from the MySQL drivers
• a745ad0 - PDO MySQL driver's lockTable() method issued an empty query

Database Package 1.1.1

The following are pertinent changes made with this release:

• Restructure package for PSR-4 support