Libraries tagged by insert select
coco-project/sql-cache
19 Downloads
Based on the lexical analysis of "update," "select," "insert," and "delete" SQL statements, an automatic caching strategy is implemented. The strategy involves caching the data when executing a select operation and associating the table name contained in the SQL statement with the corresponding cached records. When executing update, insert, or delete operations, the table name from the SQL statement is extracted, and any cached records containing this table name from previous select operations are deleted. This strategy enables seamless caching without delay and eliminates the need to worry about data synchronization issues. It is particularly effective for tables with infrequent data modifications. For tables with frequent modifications, they can be ignored by configuring the strategy accordingly.
thipages/quicksql
35 Downloads
Quick sql builder
i-nocturne/swoole-sql-query
14 Downloads
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
bronos/php-sql-query-builder
5867 Downloads
Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.
hamaryuginh/meekrodb-bundle
76 Downloads
A Symfony2 Bundle for MeekroDB
leandroip/modelclass
4 Downloads
A class to implement PHP Models and handle basic MySql operations like insert, select, update, delete and perform search by keywords.
or81/eloquent
0 Downloads
A lightweight and versatile PHP database class that supports both MySQL and SQLite, providing an easy-to-use interface for common database operations such as `SELECT`, `INSERT`, `UPDATE`, and `DELETE`.
mtkocak/basicdb
48 Downloads
A BasicDB implementation using PDO. Select, Insert, Update and Delete operations in an OOP way.
gonzalo123/sql-string-generator
4 Downloads
Write a DSL to generate valid SQL statements for SELECT, INSERT, UPDATE and DELETE
geovanirangel/modellayer
25 Downloads
O ModelLayer é um componente baseado em PDO que abstraí operações de CRUD(Select, Insert, Update e Delete) no seu banco de dados.
taeluf/lildb
147 Downloads
A simple PDO wrapper with convenience methods for common SQL verbs like insert, update, delete, select
lyhiving/mmodel
21 Downloads
PHP mini model.Fast MySQL select/insert/update/delete actions.
nicklewis/phalcon-db-mock
110 Downloads
Db Mock adds a mock database that you can insert into, delete, and select from for phpunit mocks
codestepsbd/historykeeper
7 Downloads
This will capture data for selected table for insert, update and delete
yiisoft-custom/yii2-model-attribute-convert
43 Downloads
Base on Yii2 BaseActiveRecord. Converts column from db format to model format while SELECT,oppositely way while INSERT or UPDATE