php-anydataset-db

What's Changed

• Don't throw an error if moveNext has no Records by @byjg in https://github.com/byjg/php-anydataset-db/pull/20
• Tests for getScalar() by @byjg in https://github.com/byjg/php-anydataset-db/pull/21

Full Changelog: https://github.com/byjg/php-anydataset-db/compare/4.9.4...4.9.5

What's Changed

• Fix the ORACLE OCI Interface by @byjg in https://github.com/byjg/php-anydataset-db/pull/19
• Add tests for Oracle OCI by @byjg in https://github.com/byjg/php-anydataset-db/pull/19
• Create a Mutex to store and get from cache query results by @byjg in https://github.com/byjg/php-anydataset-db/pull/19
• Review the database transaction methods by @byjg in https://github.com/byjg/php-anydataset-db/pull/19

Full Changelog: https://github.com/byjg/php-anydataset-db/compare/4.9.3...4.9.4

What's Changed

• Adjusts on PDO SqlSrv Driver and Fix it tests. by @byjg in https://github.com/byjg/php-anydataset-db/pull/18

Full Changelog: https://github.com/byjg/php-anydataset-db/compare/4.9.2...4.9.3

What's Changed

• Internal Code Refactor, splitting DbDriver object into 2 traits (plus object)
• TransactionTrait and important refactor in the Database Transaction management
• Added PdoObj to allow handle the PDO connection string and instance in a separated object
• Update Route.php
• Fix deprecation warning
• Add test unix_socket
• Enable SQLServer tests
• Several Fix MSSQL.

Full Changelog: https://github.com/byjg/php-anydataset-db/compare/4.9.1...4.9.2

What's Changed

• Add the methods to reconnect, disconnect and verify if isConnected. by @byjg in https://github.com/byjg/php-anydataset-db/pull/15
• Change Cache

Full Changelog: https://github.com/byjg/php-anydataset-db/compare/4.9.0...4.9.1

What's Changed

• Fix sql functions by @byjg in https://github.com/byjg/anydataset-db/pull/10
• Add github actions and upgrade code by @byjg in https://github.com/byjg/anydataset-db/pull/11
• 4.1.3 Add dont_bind_param to ignore binding by @byjg in https://github.com/byjg/anydataset-db/pull/12

Full Changelog: https://github.com/byjg/anydataset-db/compare/4.1.2...4.9.0

Added Microsoft Sql Server driver using the connector sqlsrv_connect https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-ver15 to support PR https://github.com/byjg/migration/issues/33

sqlsrv://username:password@hostname:port/database

Dblib still can be used as:

dblib://username:password@hostname:port/database 

Fix escaping single-quote regular expression.

Thanks to PR #6

• Upgrade URI component;
• No treatment from the empty database result - null is null.

That version makes Statement Cache disabled by default. Statement Cache was introduced in 4.0.1 and 4.0.2 releases. That can cause issues in some cases.

To enable Statement Cache just add to your URI the property stmtcache=true as you can see below.

mysql://host/database?stmtcache=true

Upgrade URI Component

Anydataset DB uses PDO prepared statements. That is a good practice because avoid security issues e.g. SQL Injection and can improve the execution performance if the prepared statement is reused.

This PR enables to cache the prepared statements and reuse it. It means that Anydataset DB can benefit from the execution performance.

Thanks to Florian Levis on issue #1

Initial version from splitting Anydataset project.

Matching version with Anydataset Major version