Community News: Latest PECL Releases (02.01.2022)

Latest PECL Releases:

sqlsrv 5.10.0
[Added]

Support for PHP 8.1
Support for macOS Monterey, Debian 11, Ubuntu 21.04 and 21.10, Alpine 3.13, 3.14 and 3.15
Support for Apple M1 ARM64 hardware — requires MS ODBC Driver 17.8+

Adjusted connection keyword and value validation for more flexibility
Feature Request #795 – adding support for Table-valued parameters
[Removed]
Support for PHP 7.3
Support for Ubuntu 16.04, Alpine 3.11 and Alpine 3.12
[Fixed]
Pull request #1260 – cleaned up redundant code
Issue #1261 – simplified get_field_as_string and made it more robust – pull request #1265

Pull request #1262 – simplified parse_param_array in sqlsrv
Pull request #1267 – replaced the obsolete MACRO ZVAL_NEW_ARR with array_init
Pull request #1275 – fixed warning compiling core_stmt.cpp by mlocati
Pull request #1290 – updated list of supported processor architecture
Issue #1307 – added TVP support to non-procedure statements
Issue #1310 – adjusted sql_data_type and column size for NULL parameters – pull request #1311 by gjcarrette
Pull request #1326 – php drivers simply pass Azure AD Authentication to ODBC driver, which will verify the settings
Issue #1329 – reset sql type and column size for input params
[Limitations]
No support for inout / output params when using sql_variant type
No support for inout / output params when formatting decimal values
In Linux and macOS, setlocale() only takes effect if it is invoked before the first connection. Attempting to set the locale after connecting will not work
Always Encrypted requires MS ODBC Driver 17+

Only Windows Certificate Store and Azure Key Vault are supported. Custom Keystores are not yet supported
Issue #716 – With Always Encrypted enabled, named parameters in subqueries are not supported
Issue #1050 – With Always Encrypted enabled, insertion requires the column list for any tables with identity columns

Always Encrypted limitations
[Known Issues]

This release requires ODBC Driver 17.4.2 or above. Otherwise, a warning about failing to set an attribute may be suppressed when using an older ODBC driver.
Connection pooling on Linux or macOS is not recommended with unixODBC < 2.3.7
When pooling is enabled in Linux or macOS

unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostic information, such as error messages, warnings and informative messages
due to this unixODBC bug, fetch large data (such as xml, binary) as streams as a workaround. See the examples here

pdo_sqlsrv 5.10.0
[Added]
– Support for PHP 8.1
– Support for macOS Monterey, Debian 11, Ubuntu 21.04 and 21.10, Alpine 3.13, 3.14 and 3.15
– Support for Apple M1 ARM64 hardware — requires [MS ODBC Driver 17.8+](https://docs.microsoft.com/sql/connect/odbc/linux-mac/install-microsoft-odbc-driver-sql-server-macos?view=sql-server-ver15)
– Adjusted connection keyword and value validation for more flexibility
– Feature Request [#795](https://github.com/microsoft/msphpsql/issues/795) – adding support for [Table-valued parameters](https://github.com/Microsoft/msphpsql/wiki/Features#tvp)
– Feature Request [#1320](https://github.com/microsoft/msphpsql/issues/1320) – allow PDO::ATTR_EMULATE_PREPARES to be set at the connection level
[Removed]
– Support for PHP 7.3
– Support for Ubuntu 16.04, Alpine 3.11 and Alpine 3.12
[Fixed]
– Issue [#1244](https://github.com/microsoft/msphpsql/issues/1244) – use lower case for object names for PDO::lastInsertId() – pull request [#1245](https://github.com/microsoft/msphpsql/pull/1245) by morozov
– Pull request [#1251](https://github.com/microsoft/msphpsql/pull/1251) – simplified implementations of last insert id and quote
– Issue [#1258](https://github.com/microsoft/msphpsql/issues/1258) – updated pdo_sqlsrv_get_driver_methods as per documentation – pull request [#1259](https://github.com/microsoft/msphpsql/pull/1259)
– Pull request [#1260](https://github.com/microsoft/msphpsql/pull/1260) – cleaned up redundant code
– Issue [#1261](https://github.com/microsoft/msphpsql/issues/1261) – simplified get_field_as_string and made it more robust – pull request [#1265](https://github.com/microsoft/msphpsql/pull/1265)
– Pull request [#1267](https://github.com/microsoft/msphpsql/pull/1267) – replaced the obsolete MACRO ZVAL_NEW_ARR with array_init
– Pull request [#1275](https://github.com/microsoft/msphpsql/pull/1275) – fixed warning compiling core_stmt.cpp by mlocati
– Pull request [#1288](https://github.com/microsoft/msphpsql/pull/1288) – applied mask to pdo quote for binary inputs
– Pull request [#1290](https://github.com/microsoft/msphpsql/pull/1290) – updated list of supported processor architecture
– Issue [#1307](https://github.com/microsoft/msphpsql/issues/1307) – added TVP support to non-procedure statements
– Issue [#1310](https://github.com/microsoft/msphpsql/issues/1310) – adjusted sql_data_type and column size for NULL parameters – pull request [#1311](https://github.com/microsoft/msphpsql/pull/1311) by gjcarrette
– Pull request [#1326](https://github.com/microsoft/msphpsql/pull/1326) – php drivers simply pass Azure AD Authentication to ODBC driver, which will verify the settings
– Issue [#1329](https://github.com/microsoft/msphpsql/issues/1329) – reset sql type and column size for input params
– Issue [#1331](https://github.com/microsoft/msphpsql/issues/1331) – restore PDO::ATTR_ERRMODE if calling PDO::lastInsertId() call fails – pull request [#1330](https://github.com/microsoft/msphpsql/pull/1330) by mpyw and pull request [#1332](https://github.com/microsoft/msphpsql/pull/1332)
[Limitations]
– No support for inout / output params when using sql_variant type
– No support for inout / output params when formatting decimal values
– In Linux and macOS, setlocale() only takes effect if it is invoked before the first connection. Attempting to set the locale after connecting will not work
– Always Encrypted requires [MS ODBC Driver 17+](https://docs.microsoft.com/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server)
– Only Windows Certificate Store and Azure Key Vault are supported. Custom Keystores are not yet supported
– Issue [#716](https://github.com/Microsoft/msphpsql/issues/716) – With Always Encrypted enabled, named parameters in subqueries are not supported
– Issue [#1050](https://github.com/microsoft/msphpsql/issues/1050) – With Always Encrypted enabled, insertion requires the column list for any tables with identity columns
– [Always Encrypted limitations](https://docs.microsoft.com/sql/connect/php/using-always-encrypted-php-drivers#limitations-of-the-php-drivers-when-using-always-encrypted)
[Known Issues]
– This release requires ODBC Driver 17.4.2 or above. Otherwise, a warning about failing to set an attribute may be suppressed when using an older ODBC driver.
– Connection pooling on Linux or macOS is not recommended with [unixODBC](http://www.unixodbc.org/) < 2.3.7
– When pooling is enabled in Linux or macOS
– unixODBC <= 2.3.4 (Linux and macOS) might not return proper diagnostic information, such as error messages, warnings and informative messages
– due to this unixODBC bug, fetch large data (such as xml, binary) as streams as a workaround. See the examples [here](https://github.com/Microsoft/msphpsql/wiki/Features#pooling)
gRPC 1.44.0RC2
– gRPC Core 1.44.0 update
teds 0.9.2
* Make SortedStrictSet/SortedStrictMap use a red-black tree that is rebalanced on insertions and removals, guaranteeing worst-case logarithmic time for insertions/removals/lookups.
teds 0.9.1
* Make SortedStrictSet/SortedStrictMap use a binary search tree (not yet a balanced tree).
* Associate iterators on SortedStrictSet/SortedStrictMap with nodes of the tree.
Invalidate iterators pointing to a node when that node of the set/map is removed.
* Fix sorting order when instantiating StableSortedListSet/SortedStrictSet/SortedStrictMap from unsorted arrays.
protobuf 3.19.4
* Fixed a data loss bug that could occur when the number of optional fields in a message is an exact multiple of 32. (#9440).
teds 0.9.0
* Migrate `TedsStrictSet`, `TedsStrictMap`, and `Tedsunique_values` implementation to use an actual hash table instead of a list of unique values.
dio 0.2.1
– fix windows build

PHPDeveloper.org
Read More

Latest News

PHP-Releases

PHP 8.0.19 released!

PHP 7.4.29 released!