Download the PHP package antevenio/pdo-mysql-select-iterator without Composer
On this page you can find all versions of the php package antevenio/pdo-mysql-select-iterator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
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 pdo-mysql-select-iterator
pdo-mysql-select-iterator
PHP PDO Mysql select statement iterator implemented as multiple queries using LIMIT clauses.
What is this thing
So, you want to iterate through millions of table rows coming as a result of some MySQL select query because you want to do your thingie with them, but alas!, your lovely database admin doesn't like queries that stay for too long running in his server, or even worse, the server itself isn't able to hold them!. What do we do?, we do issue several queries that would fetch smaller blocks of rows in place.
This is an just a PHP iterator based on this concept. Upon receiving a SELECT query and a PDO database connection, an iterator is built so you can seamlessly traverse results without having to worry about anything else.
Install
To add as a dependency using composer:
composer require antevenio/pdo-mysql-select-iterator
Usage example
Notes
The factory will throw a InvalidQueryException on non "select" queries.
The factory will only return a LimitIterator when:
- The blockSize is > 0
- The query has an "order by" clause
- The query is not using any "rand()" functions
If any of the previous conditions is NOT met, the factory will return a non limit based iterator called "NativePDOIterator".
To ensure consistency among results, you might want to get the whole iteration and count inside a database transaction. The most suitable isolation level would be REPEATABLE-READ:
