Download the PHP package jeremiah-shaulov/pdoi without Composer

On this page you can find all versions of the php package jeremiah-shaulov/pdoi. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package pdoi

Pdoi - The Improved PDO

This library provides class whose API matches PDO API, and can be used as PDO replacement with little application changes. This class is called Pdoi. It supports most (but not all) PDO features. For drivers other than MySQL, it works exactly like PDO (function calls are forwarded to internal PDO instance), and for MySQL it explicitly uses mysqli extension.

This is to achieve 2 goals:

  1. Saner connections pooling.
  2. Access to mysqli-specific features.

About database connections pooling

As of January 2021, my eyes don't see usable database connections pooling solution in PHP world.

Persistent connections can be created with mysqli using "p:" prefix for hostname. And with PDO they can be created with help of PDO::ATTR_PERSISTENT attribute. Together with PHP-FPM process pool this can build up the true database connections pooling system.

This worked even on PHP4, but nobody practically used them, because there are problems reusing a dirty connection.

  1. SET @flag=1 issued once, will be initially set on next connection usage.
  2. Started and not committed transactions will hold locks on touched rows.
  3. SELECT Get_lock('Busy', 10) will prevent other parallel connections in pool from entering critical section.

Current persistent connections implementation in mysqli and PDO, as of January 2021, resets connection state by calling mysqli_change_user() function. But my experience reveals that user-locks are not released. I suppose that this function is called when a connection is picked up from pool, before using it. So whole time period since the connection was left alone, and till it's new usage (that can not happen at all), locks are locking what they want to lock.

Each connection should be reset immediately at script end. This library calls mysqli_change_user() in destructor of Pdoi object. What i love in PHP is reference-counting objects, and that destructors are called immediately when the object is not in use.

Installation

Create a directory for your application, cd to it, and issue:

Example

Running this example from CLI will show different Connection_id() each time, because there will be only 1 connection in process lifecycle. But running from PHP-FPM will show that the same connection numbers appear many times.


All versions of pdoi with dependencies

PHP Build Version
Package Version
Requires php Version >=7.4
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package jeremiah-shaulov/pdoi contains the following files

Loading the files please wait ....