amphp/mysql

What's Changed

• Add MariaDB CI job and integration test for native UUID column by @webpatser in #144
• Silence PHP 8.5 chr() deprecation in encodeInt8 by @webpatser in #145
• Added compatibility for amphp/[email protected]

Full Changelog: v3.1.0...v3.1.1

What's Changed

• Added a parameter for the default transaction isolation to MysqlConnectionPool to set the default transaction level when constructing the pool
• Fixed setting NULL for JSON typed columns (#136)
• Fixed decoding MEDIUMINT columns using the binary protocol (#140)
• Use VarString for string parameter encoding in binary protocol by @webpatser in #142

New Contributors

• @webpatser made their first contribution in #143

Full Changelog: v3.0.1...v3.1.0

• Fixed PHP 8.5 deprecations.

Full Changelog: v3.0.0...v3.0.1

Stable release compatible with AMPHP v3 and fibers! 🎉

As with other libraries compatible with AMPHP v3, most cases of parameters or returns of Promise<ResolutionType> have been replaced with ResolutionType.

• Classes and interfaces now are prefixed with Mysql to avoid collisions with similar names from other libraries.
• Marked most classes as internal, leaving only interfaces and concrete implementations required to use the API or create a custom connector.
• MysqlTransaction now extends MysqlLink instead of MysqlExecutor to support nested transactions.
• MysqlDataType is now an enum of MySQL data type codes and methods to decode data based on type.
• Result set field data is now available from MysqlResult::getColumnDefinitions() which returns an array of MysqlColumnDefinition objects corresponding to the result set rows.
• The second param of MysqlStatement::bind() now requires a string. Binding only makes sense with long strings anyway.
• MysqlConnection is now an interface extending SqlConnection, with SocketMysqlConnection being the implementation.
• Removed MysqlConnector since the interface was replaced by template types on SqlConnector, i.e. SqlConnector<MysqlConfig, MysqlConnection>

What's Changed

• Fixed support for binding to JSON columns
• Fixed connecting with TLS.
• Add support for sql_mode and fix set charset by @ruifil in #128

New Contributors

• @ruifil made their first contribution in #128

Full Changelog: v3.0.0-beta.8...v3.0.0-beta.9

What's Changed

• Compatibility with amphp/[email protected].
• Forbid cloning and serialization of most class instances.

Full Changelog: v3.0.0-beta.7...v3.0.0-beta.8

What's Changed

Nested transactions have been refactored to be created simply with MysqlTransaction::beginTransaction() instead of needing to wrap a MysqlTransaction into a MysqlNestableTransaction. If you did not use savepoints or nested transactions, you likely will be able to upgrade to this version without any code changes.

• Updated transactions for amphp/[email protected] and amphp/[email protected]. Removed MysqlNestableTransaction.
• MysqlConnection interface now extends the base interface Connection from amphp/sql.
• Added MysqlEncodedValue, replacing MysqlDataType::encodeValue().
• Renamed SocketMysqlConnection::initialize() to connect(). The first parameter now accepts an instance of SocketConnector instead of a Socket.
• MysqlColumnDefinition now defines a set of getter methods instead of using public properties.

Full Changelog: v3.0.0-beta.6...v3.0.0-beta.7

• Added MysqlNestableTransaction which may be optionally used to create a MysqlLink from a MysqlTransaction object. Nested transactions are implemented using savepoints.

• Compatibility with v2.0 of amphp/socket