Libraries tagged by sql insert

Simple CLI tool for validating SQL files before inserting them into DB.

Go to Download

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

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

Queue any Laravel write query (delete/update/insert) across parallel batched jobs.

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

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