Download the PHP package gonzie/pdoload without Composer
On this page you can find all versions of the php package gonzie/pdoload. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download gonzie/pdoload
More information about gonzie/pdoload
Files in gonzie/pdoload
Package pdoload
Short Description Small PDO wrapper to provide read/write split and load balancing in one line of code.
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 pdoload
[
]()
[
]()
[
]()
PDOLoad
PDOLoad is a small PDO wrapper/abstraction layer to provide read/write endpoints and load balancing capabilities in one line of code. Load balancing is usually include within most major PHP Frameworks however when working with large legacy projects it's hard to come by.
Main Features
- Add multiple read and write endpoints.
- One line implementation. No need to rewrite your PDO queries.
- Transaction aware. Any reads while a transaction is active will be performed on the write connection.
Getting started
- PHP >= 7.0 is required
- Install PDOLoad using composer (recommmended) or manually
- Configure your connections and you're ready to go!
Installing with Composer
How to use
PDOLoad gives you as much choice as possible with little to no modification required. A normal PDO connection would be set like:
(most basic set up)
To use a minimalistic version of PDOLoad you would amend the code as follows:
Alternatively, to use PDOLoad to it's full abilities, and for what it was actually made for, you can set up by passing an array with settings.
Easy right? Here's a breakdown of the settings array:
| Field | Type | Description |
|---|---|---|
| driver | string | Optional, default is mysql. Available options: pdo_mysql, drizzle_pdo_mysql, mysqli, pdo_sqlite, pdo_pgsql, pdo_oci, pdo_sqlsrv, sqlsrv, oci8, sqlanywhere |
| reader | array[connection] | Required. Array of connection arrays. |
| writer | array[connection] | Required. Array of connection arrays. |
| balancer | string | Optional, default is `. Available options:round-robin- go from top to bottom of connection's array,fixed- PDOLoad will pick a connection at random and stick to it,random` - each query will pick a random connection. |
| overwrite_allowed | string | Optional, default is false. Some driver options require additional options other than the ones in the connection array, set this value to true if you need to add custom options to the array otherwise they won't be allowed. |
Connection array
Other options can be added to your liking as long as overwrite_allowed is set to true.
| Field | Type | Description |
|---|---|---|
| host | string | Required. |
| dbname | string | Optional. |
| user | string | Required. |
| password | string | Required. |
| charset | string | Optional, default is utf8mb4. |
Contributing
Any changes to the Project must abide by PSR Standards (PSR 2 - 12, PSR4 and others where applicable).
Please run phpcs before committing any code.
