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`.

Go to Download

optiwariindia/database

1 Favers
290 Downloads

A library to connect database and use basic activities in database like create,select,insert,update,delete and drop using predefined methods

Go to Download

mtkocak/basicdb

1 Favers
50 Downloads

A BasicDB implementation using PDO. Select, Insert, Update and Delete operations in an OOP way.

Go to Download

gonzalo123/sql-string-generator

0 Favers
4 Downloads

Write a DSL to generate valid SQL statements for SELECT, INSERT, UPDATE and DELETE

Go to Download

coco-project/sql-cache

0 Favers
23 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.

Go to Download