Download the PHP package flyokai/laminas-db-driver-async without Composer
On this page you can find all versions of the php package flyokai/laminas-db-driver-async. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download flyokai/laminas-db-driver-async
More information about flyokai/laminas-db-driver-async
Files in flyokai/laminas-db-driver-async
Package laminas-db-driver-async
Short Description Async driver for laminas db
License MIT
FAQ
Example:
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 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.
Informations about the package laminas-db-driver-async
flyokai/laminas-db-driver-async
User docs →
AGENTS.mdTwo-strategy async database driver for Laminas DB: AsyncPdo (AMPHP worker pools, process-isolated) and AsyncMysqli (Revolt event loop +
MYSQLI_ASYNC, in-process cooperative).
Pick whichever fits your workload — both implement Laminas DB's DriverInterface. AsyncMysqli is the default ConnectionPool in Flyokai.
Features
- AsyncPdo — strong process isolation via AMPHP
Parallelworkers (default 32). True server-side prepared statements. - AsyncMysqli — in-process cooperative concurrency via
MYSQLI_ASYNCandEventLoop::onMysqli(). Auto-retry on connection errors and deadlocks. ConnectionPoolinterface — factory contract used by Flyokai'sAmpConnectionPool,AsyncPdoConnectionPool,AsyncMysqliConnectionPool- FiberLocal state — transaction level / pdo resource isolated per fiber
CreateSqlTrait— convenience for building LaminasSqlinstances from pool connections
Installation
When to use which
| Aspect | AsyncPdo | AsyncMysqli |
|---|---|---|
| Isolation | Strong (separate processes) | Weak (same process) |
| Overhead | Higher (serialization, IPC) | Lower (in-process) |
| Statements | True server-side prepared | Client-side parameter interpolation |
| Scalability | CPU-bound work | I/O-bound work |
| Transactions | Full nesting via level tracking | Basic begin/commit/rollback |
| Fiber-aware state | FiberLocal |
Implicit via the event loop |
AsyncPdo
Architecture
Quick start
PdoTask operations: connect, execute, prepare, statement:execute, statement:fetch, statement:fetchAll, … each routes to a cached PDO/PDOStatement in the worker via spl_object_id().
AsyncMysqli
Architecture
Quick start
The Connection delegates to ParentConnection for raw mysqli operations and adds queryWithRetry():
- Automatic reconnect on errors
2006(gone away) and2013(lost during query) - Retry on deadlock
1213 - Up to 10 retries
Parameter binding
There are no prepared statements — parameters are interpolated client-side via Platform::quoteValue(). Named parameters are sorted by length (longest first) to avoid partial replacement.
In Flyokai
AsyncMysqliConnectionPool is the default ConnectionPool configured via the DI alias in the application's diconfig.php. Switch to AsyncPdoConnectionPool or AmpConnectionPool by overriding the alias.
Gotchas
PendingOperationError(PDO) — cannot start a new operation while another is in flight on the same resource. Await before issuing the next call.fiber_mode=trueisolates state per fiber.fiber_mode=falseshares global state — race-condition risk.- Process serialization (PDO) — only scalars and arrays cross worker boundaries. Closures, resources, complex objects don't.
- No prepared statements (MySQLi) — parameters are interpolated. Safety relies entirely on
quoteValue(). - Pool starvation — if all workers/links are occupied, subsequent requests block until one returns.
- Auto-retry hides failures (MySQLi) — connection errors and deadlocks are retried up to 10 times before giving up.
- Worker cache pollution (PDO) —
LocalCachein workers persists across executions. Long-running workers may leak memory if you forget to release statements. - Requires active EventLoop — both strategies need a Revolt event loop context.
See also
flyokai/laminas-db— base abstractionflyokai/laminas-db-driver-amp— alternative driver usingamphp/mysqlflyokai/revolt-event-loop—onMysqli()is the AsyncMysqli primitiveflyokai/application— wires the connection pools into DI
License
MIT
All versions of laminas-db-driver-async with dependencies
amphp/amp Version ^3.0.2
amphp/parallel Version ^2.3.1
laminas/laminas-db Version ^2.5
flyokai/revolt-event-loop Version ^1
ext-pdo Version *