Libraries tagged by sql insert

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

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

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

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

Go to Download

My personal SQL friend

Go to Download

6-way converter: CSV ↔ XLSX ↔ JSON ↔ MySQL. Import/export data between any format, generate SQL INSERTs, or connect directly via PDO.

Go to Download

Extract table names from SQL queries (SELECT, INSERT, UPDATE, JOIN, subqueries)

Go to Download

This package provides a simple utility to convert data from a CSV file into SQL queries for database insertion and Create table.

Go to Download

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

Go to Download

Simple OOP system to query data from database and insert and create tables.

Go to Download

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

Go to Download

Simple DB layer for mysqli extension and PDO class. It is based on mappers, files holding database table fields, primary key and auto_increment properties, which is helpful to compare fields for CRUD or select operations, and to provide better way to prevent SQL injections (only existing fields are selected, or inserted, ...)

Go to Download

Load data into the database and cache with raw sql inserts

Go to Download

Utility for create SQL insert, update and delete

Go to Download

Create table from insert sql

Go to Download