library mysql {🖫 2,554, ⚐ 19, ★ 133}

amphp/mysql

Asynchronous MySQL client for PHP based on Amp.

Thursday, June 28, 2018
by bwoebi
Repository
19 Watchers
133 Stars
2,554 Installations

PHP
1 Dependents
0 Suggesters
34 Forks
7 Open issues
19 Versions
29 % Grown

The README.md

, _(*1)

, _(*2)

Async MySQL client built with Amp., _(*3)

amphp/mysql is an asynchronous MySQL client built on the Amp concurrency framework. The library exposes a Promise-based API to dynamically query multiple MySQL connections concurrently. The client transparently distributes these queries across a scalable pool of available connections and does so using 100% userland PHP; there are no external extension dependencies (e.g. ext/mysqli, ext/pdo, etc)., _(*4)

Features

Asynchronous API exposing full single-threaded concurrency
Transparent connection pooling to overcome MySQL's fundamentally synchronous connection protocol
MySQL transfer encoding support (gzip, TLS encryption)
Support for all MySQL commands^†

^{† As documented in official Mysql Internals Manual}, _(*5)

Project Goals

Expose a non-blocking API for issuing multiple MySQL queries in parallel
Support the full MySQL protocol and all available commands asynchronously

Installation

This package can be installed as a Composer dependency., _(*6)

composer require amphp/mysql

Requirements

PHP 7.1+
Amp framework (installed via composer)

Documentation & Examples

More extensive code examples reside in the examples directory., _(*7)

Amp\Loop::run(function() {
    $config = Amp\Mysql\ConnectionConfig::fromString(
        "host=127.0.0.1 user=username password=password db=test"
    );

    /** @var \Amp\Mysql\Pool $pool */
    $pool = Amp\Mysql\pool($config);

    /** @var \Amp\Mysql\Statement $statement */
    $statement = yield $pool->prepare("SELECT * FROM table_name WHERE id = :id");

    /** @var \Amp\Mysql\ResultSet $result */
    $result = yield $statement->execute(['id' => 1337]);
    while (yield $result->advance()) {
        $row = $result->getCurrent();
        // $row is an associative array of column values. e.g.: $row['column_name']
    }
});

Versioning

amphp/mysql follows the semver semantic versioning specification like all other amphp packages., _(*8)

Security

If you discover any security related issues, please email contact@amphp.org instead of using the issue tracker., _(*9)

License

The MIT License (MIT). Please see LICENSE for more information., _(*10)

The Versions

28/06 2018

dev-master

9999999-dev

Asynchronous MySQL client for PHP based on Amp.

library mysql

Asynchronous MySQL client for PHP based on Amp.

amphp/mysql

The README.md

Features

Project Goals

Installation

Requirements

Documentation & Examples

Versioning

Security

License

The Versions

dev-master

The Requires

The Development Requires

by Bob Weinand

by Aaron Piotrowski

dev-travis

The Requires

The Development Requires

by Bob Weinand

by Aaron Piotrowski

v0.3.1

The Requires

The Development Requires

by Bob Weinand

by Aaron Piotrowski

v0.3.0

The Requires

The Development Requires

by Bob Weinand

by Aaron Piotrowski

dev-mariadb

The Requires

The Development Requires

by Bob Weinand

by Aaron Piotrowski

dev-refactor

The Requires

The Development Requires

by Bob Weinand

v0.2.3

The Requires

The Development Requires

by Bob Weinand

v0.2.2

The Requires

The Development Requires

by Bob Weinand

v0.2.1

The Requires

The Development Requires

by Bob Weinand

v0.2.0

The Requires

The Development Requires

by Bob Weinand

0.1.x-dev

The Requires

The Development Requires

by Bob Weinand

v0.1.6

The Requires

The Development Requires

by Bob Weinand

dev-amp_v2

The Requires

The Development Requires

by Bob Weinand

v0.1.5

The Requires

The Development Requires

by Bob Weinand

v0.1.4

The Requires

The Development Requires

by Bob Weinand

v0.1.3

The Requires