php mysql redis orm_开源C扩展轻量级PHP数据库ORM框架ycdatabase : 构建稳定的PHP数据库连接池...

ycdatabase

Catalogue

Instruction

Requirement

Create test table

Compire ycdatabase in linux

Start ycdatabase

Init ycdb connection

Native SQL query

Error Info

Where statement

Select statement

Insert statement

Replace statement

Update statement

Delete statement

Whole Example

Database Transaction

Data Caching

PHP Database Connection Pool

Redis Connection Pool

Instruction

1、Fast : ycdb is an mysql database ORM written in c, built in php extension, as we known, database ORM is a very time-consuming operation, especially for interpretive languages such as PHP, and for a project, the proportion of ORM is very high,so here I will implement the MySQL ORM operation in C language, and use the performance of C language to improve the performance of ORM.

2、Safe : ycdb can solve SQL injection through parameter binding.

3、Powerful : concise and powerful usage , support any operation in database.

4、Easy : Extremely easy to learn and use, friendly construction.

5、Data-cache : ycdb supports data caching. You can use redis as a medium to cache database data, but remember that when the update, insert, and delete operations involve caching data, you need to delete your cache to ensure data consistency.

6、Connection-pool : ycdb uses a special way to establish a stable connection pool with MySQL. performance can be increased by at least 30%, According to PHP's operating mechanism, long connections can only reside on top of the worker process after establishment, that is, how many work processes are there. How many long connections, for example, we have 10 PHP servers, each launching 1000 PHP-FPM worker processes, they connect to the same MySQL instance, then there will be a maximum of 10,000 long connections on this MySQL instance, the number is completely Out of control! And PHP's connection pool heartbeat mechanism is not perfect

1、快速 - ycdb是一个为PHP扩展写的纯C语言写的mysql数据库ORM扩展，众所周知，数据库ORM是一个非常耗时的操作，尤其对于解释性语言如PHP，而且对于一个项目来说，ORM大多数情况能占到项目很大的一个比例，所以这里我将MySQL的ORM操作用C语言实现，利用C语言的性能，提升ORM的性能。

2、安全 - ycdb能通过参数绑定的方式解决SQL注入的问题。

3、强大 - 便捷的函数，支持所有数据库操作。

4、简单 - 使用和学习非常简单，界面友好。

5、数据缓存 - ycdb支持数据缓存，你可以采用redis作为介质来缓存数据库的数据，但是记得在update、insert、delete 操作涉及到与缓存数据相关的数据修改时，需要按key删除您的缓存，以保证数据一致性。

6、连接池 - ycdb通过一种特殊的方式来建立一个稳定的与MySQL之间的连接池，性能至少能提升30%，按照 PHP 的运行机制，长连接在建立之后只能寄居在工作进程之上，也就是说有多少个工作进程，就有多少个长连接，打个比方，我们有 10 台 PHP 服务器，每台启动 1000 个 PHP-FPM 工作进程，它们连接同一个 MySQL 实例，那么此 MySQL 实例上最多将存在 10000 个长连接，数量完全失控了！而且PHP的连接池心跳机制不完善。

Requirement

PHP 7.0 +

need support PDO for mysql

Create test table

CREATE TABLE `user_info_test` (

`uid` int(11) NOT NULL COMMENT 'userid' AUTO_INCREMENT,

`username` varchar(64) NOT NULL COMMENT 'username',

`sexuality` varchar(8) DEFAULT 'male' COMMENT 'sexuality：male - 男性 female - 女性',

`age` int(11) DEFAULT 0 COMMENT 'age',

`height` double(11,2) DEFAULT 0 COMMENT 'height of a person, 身高',

`bool_flag` int(11) DEFAULT 1 COMMENT 'flag',

`remark` varchar(11) DEFAULT NULL,

PRIMARY KEY (`uid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='userinfo';

Compire ycdatabase in linux

path to is your PHP install dir

$cd ~/ycdatabase/ycdatabase_extension

$/path/to/phpize

$chmod +x ./configure

$./configure --with-php-config=/path/to/php-config

$make

$make install

Start ycdatabase

new ycdb()

$db_conf = array("host" => "127.0.0.1",

"username" => "root",

"password" => "test123123",

"dbname" => "userinfo",

"port" => '3306',

"option" => array(

PDO::ATTR_CASE => PDO::CASE_NATURAL,

PDO::ATTR_TIMEOUT => 2));

$ycdb = new ycdb($db_conf);

we can start by creating a ycdatabase object (ycdb) from the obove code, db_conf include host,username,password,dbname,port and option, option is a pdo attribution, you can get the detail from http://php.net/manual/en/pdo.... For example, PDO::ATTR_TIMEOUT in the above code is specifies the timeout duration in seconds, and PDO::ATTR_CASE is forcing column names to a specific case.

Init ycdb connection

we need to init pdo connection before we use ycdatabase.

try{

$ycdb->initialize();

} catch (PDOException $e) {

echo "find PDOException when initialize\n";

var_dump($e);

exit;

}

Native SQL query

We can directly execute the sql statement through the exec() function,the return value is the number of rows affected by the execution, or return insert_id if it is insert statement, when the table has not AUTO_INCREMENT field, the insert_id should be zero, and execute select statement through the query() function, If $ret = -1 indicates that the sql execution error occurs, we can pass $ycdb->errorCode(), $ycdb- >errorInfo() returns the error code and error description respectively.

insert data

$insert_id = $ycdb->exec("insert into user_info_test(username, sexuality, age, height)

values('smallhow', 'male', 29, 180)");

if($insert_id == -1) {

$code = $ycdb->errorCode();

$info = $ycdb->errorInfo();

echo "code:" . $code . "\n";

echo "info:" . $info[2] . "\n";

} else {

echo $insert_id;

}

update data

if we execute the following update statement, $ret returns 3 if the current data is the above image.

$ret = $ycdb->exec("update user_info_test set remark='test' where height>=180");

echo $ret; //ret is 3

select data

$ret = $ycdb->query("select * from user_info_test where bool_flag=1");

echo json_encode($ret);