Libraries tagged by sql statement

An immutable API on top of PDO to compose and execute SQL statements

Go to Download

API that generates SQL statements programmatically based on official standards or their vendor-specific derivation

Go to Download

SQL database definition differencing tool. Structure and data is defined in a DTD-enforced, human-readable XML format. Outputs transactional SQL statement files to apply your changes.

Go to Download

Use SQL statements to query elasticsearch

Go to Download

A PHP class to log all changes of table data from raw SQL or with PDO statement

Go to Download

This package contains classes useful to generate SQL statements such as SELECT queries, etc...

Go to Download

A powerful PHP SQL template composer library which can significantly reduce the number and complexity of the SQL statement in the project. Reference to the ibatis implementation.

Go to Download

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

A very lightweight PHP class that reformats unreadable and computer-generated SQL query statements to human-friendly, readable text.

Go to Download

Check SQL performance

Go to Download

Library for creating DML (Data Manipulation Language) SQL statements.

Go to Download

Thinkphp use SQL statements to query elasticsearch

Go to Download

Use SQL statements to query elasticsearch

Go to Download

A dead simple PHP class for building SQL statements. No manual string concatenation necessary.

Go to Download

A very simple and safe PHP library to execute SQL Queries as Prepared Statements on MySQL Database, in an asynchronous & non-blocking way. Methods are provided to prepare a SQL Statement & it's execution separately as different methods (to facilitate caching of prepared statements) as well as together in a single method too, all basing upon Amphp, an event driven concurrent framework in php and its Amphp\Mysql package.

Go to Download