Libraries tagged by SQL Delete

The ability to transfer data from sql db to any project use doctine.

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

MyBatis-style SQL mapper: mark an interface #[Mapper] and its methods #[Select]/#[Insert]/#[Update]/#[Delete] with the SQL. A build-time processor compiles a reflection-free Cache\ implementation (prepared statements, #{name} bound params, optional row->object hydration) and registers it as a container bean keyed by the interface. Self-contained: a bundled DatabaseConfig provides the 'PDO' bean from a [database] group in the app's app.ini, so you only edit config. Runtime is PHP 5.3-safe.

Go to Download

SqlMigration is a Laravel package that allows you to execute custom SQL migrations directly within your Laravel application. Instead of writing SQL queries manually or relying only on Laravel's built-in migrations, this package enables you to create and run .php migration files containing custom SQL commands like INSERT, DELETE, UPDATE, CREATE TABLE, and more.

Go to Download

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

Go to Download

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

Go to Download

Object-oriented query builders for MySQL, Postgres, SQLite, and SQLServer; can be used with any database connection library.

Go to Download

Datalayer is a Datalayer-based SQL Server database abstraction component

Go to Download

Quick sql builder

Go to Download

Laravel 5.* package for quick developer protection functions

Go to Download

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

Go to Download

Arpon Database - Advanced PHP Database Abstraction Layer with Laravel-compatible ORM, Schema Builder, Query Builder for MySQL and SQLite. Features 25+ column types, foreign key CASCADE support, advanced relationships, soft deletes, enhanced scopes system, and high-performance database operations.

Go to Download

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

Go to Download

Stash Queries - PHP SQL library providing an easy, eloquent, and fluent yet expressive way to select, create, update, and delete SQL records.

Go to Download

Utility for create SQL insert, update and delete

Go to Download