Download the PHP package sue/async-mysql without Composer
On this page you can find all versions of the php package sue/async-mysql. 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 async-mysql
sue\async-mysql
提供基于Illuminate\Database包的异步执行SQL的组件，具体使用可以参考：使用手册
需求
php >= 5.6.4 ext-pdo ext-mysqli
安装方法
强烈推荐配合sue\coroutine协程组件来避免回调地狱
内容列表
- 注意事项
- Quickstart example
- [使用方式]
- laravel框架
- 其他框架
- [功能列表]
- 数据库事务
- 读写分离
- 设置SQL超时时间
- unprepared方法
- 连接资源回收
- ping
- Tests
- License
注意事项
Illuminate\Database\Eloquent以及Illuminate\Database\Migrations暂时不支持- 重写了Illuminate\Database\Connection类，DB::pretend()方法暂时也无法使用
Quickstart example
laravel框架
- 在
config/app.php中引入service-providerSue\Async\Mysql\AsyncMysqlServiceProvider -
在
config/database.php中的connections直接复制现有的配置，然后修改driver为async-mysql - 使用方法
其他框架
-
先在合适的地方添加以下代码， 比方说
index.php等入口文件 - 使用方法
数据库事务
sue\async\mysql由于采用了连接池，数据库事务跟链接绑定，所以要在事务中执行SQL的话需要使用指定的链接
暂时不支持事务嵌套以及savepoint
读写分离
sue/async-mysql会自行判断使用主库还是从库，也可以使用方法setUseWrite()方法来指定强制用主库执行SQL
SQL超时
[SQL超时时间] = [SQL执行时间] + [等待列表时等待数据库连接分配时间] 设置SQL执行超时时间有两种方式
-
在
config中配置全局的SQL最大执行时间 - 针对单个SQL设置超时时间
unprepared
unprepared()方法现在接受一个额外参数QueryOption, 可以设置超时时间 / 主从配置 / 数据库事务配置
连接资源回收
async-mysql默认不回收资源，原因如下
- php-fpm方式中没必要
- 在常驻进程中加定时器可能导致
loop()->run()无法自动退出 - 如有需要可以用以下方式手动开启
ping
async-mysql默认不开启ping功能，原因跟连接资源回收一致，如有需要可以手动开启
tests
-
先拉取项目
-
然后再phpunit.xml.dist里配置数据库连接
- 最后执行单元测试
License
The MIT License (MIT)
Copyright (c) 2023 Donghai Zhang
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
All versions of async-mysql with dependencies
ext-mysqli Version *
sue/event-loop Version ^1.1
sue/coroutine Version >=1.2.1
psr/log Version ^1.1
illuminate/database Version >=5.4.0