Related Projects

Sql Script Generator


Sql Script Generator is a tool for generate INSERT/UPDATE statement sql script. With Sql Script Generator you can create script to copy data from one database to another. In current version there are this feature: - Generate only INSERT and UPDATE statements; - Run in transa...

sqldelight - Generates Java models from CREATE TABLE statements.


SQLDelight generates Java models from your SQL CREATE TABLE statements. These models give you a typesafe API to read & write the rows of your tables. It helps you to keep your SQL statements together, organized, and easy to access from Java.To use SQLDelight, put your SQL statements in a .sq file, like src/main/sqldelight/com/example/HockeyPlayer.sq. Typically the first statement creates a table.

Broadcast Oracle SQL


Broadcast Oracle Sql is an useful script/library due to run a sql statement to several oracle instances. It can also generate several charts (bar, line,..) from the results of the select statements...

generate_inserts - Generate SQL Insert Statements from your existing data


Generate SQL Insert Statements from your existing data

Run SELECT, INSERT, UPDATE, DELETE statements against DataSet and DataTable.


QueryAnything allows user to run SQL statements against any data files that can be read into DataSet and DataTable objects. Currently support XML and CSV files. And more to come...



RMTrev-mysqldb


A hackish set of libraries written in PHP for my old job to simplify the use of MySQL and speed up projects. Very minimalistic, as I only implemented what I needed. The InsertQuery class speeds up the construction of insert query statements in SQL using method chaining. For example, $q->f("name","foo")->f("age",20)->exec(); constructs an insert query with fields "name" and "age", and executes the query all in one statement.

sqlautoreview


automatic review database dml sql(select,insert,update,delete),build create index script for every SQL statment,and merge all create index script with exist indexes on these tables.

PHPMyAdmin


phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

export-accessdb - A java app to export the data from an Access Database as SQL insert statements.


A java app to export the data from an Access Database as SQL insert statements.

sqlStringGenerator


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

slammer - A database load testing utility for MySQL, MemSQL, and Postgres


Slammer is a simple utility using Moldova, for load testing a database. You can give it a template SQL query, most likely an INSERT statement, and use that to generate a large volume of traffic, each request having a different set of values placed into it. In this way, the Slammer makes an excellent tool for massively loading fake data into a database for load testing.Since Slammer does not generate SQL, it is agnostic to what kind of database is being used.

squalor - Go SQL utility library


Squalor is a library of SQL utilities for marshalling and unmarshalling of model structs into table rows and programmatic construction of SQL statements. It is a combination of the functionality in ORM-like libraries such as gorp, SQL utility libraries such as sqlx and SQL construction libraries such as sqlbuilder. Squalor helps ensure your programs don't contains SQL injection (SQLi) bugs.While squalor uses the database/sql package, the SQL it utilizes is MySQL specific (e.g. REPLACE, INSERT ON DUPLICATE KEY UPDATE, etc).

SprigGen - Generate SQL Create statements from Sprig models


Generate SQL Create statements from Sprig models

SQL Parser for Delphi


Develope a string parser that is capable to parse SQL statements into tokens, allows changing theese tokens and rebuilding (modified) SQL statement

querify - Generate simple SQL statements from Python native data types


Generate simple SQL statements from Python native data types

rqlite-js - Javascript client library for rqlite, the lightweight, distributed database built on SQLite


A promise based client library for rqlite, the lightweight, distribubted database built on SQLite, that will work in the browser and in NodeJS. This package is designed to provide a javascript interface that communicates with rqlite API endpoints. Please note that there is no code in this package for writing SQL queries. There are other Javascript SQL generator libraries such as sequel which can be used to create the SQLite query strings. You are welcome to use one of those libraries or write your own SQL queries directly in your code.The data API will allow you to access the basic CRUD operations of rqlite such as SELECT, INSERT, UPDATE, DELETE, CREATE TABLE and DROP TABLE. To begin using the data API methods you will first want to use the connect function in lib/api/data/client which returns a promise. When the connection is successful the promise will resolve with an data API object.

GetMsSqlDump - a mysqldump-like tool for MSSQL


GetMsSqlDump is the mssql counterpart (or something similar) of mysqldump, written for Microsoft SQL Server, in PowerShell. I'd call it mssqldump if it weren't in use. Using this script you can dump your database content into a file in a form of INSERT INTO statements.

sql-xplat-cli - Repository for the new SQL cross-platform command line tools


We’re excited to introduce mssql-scripter, a multi-platform command line experience for scripting SQL Server databases.mssql-scripter is the multiplatform command line equivalent of the widely used Generate Scripts Wizard experience in SSMS. You can use mssql-scripter on Linux, macOS, and Windows to generate data definition language (DDL) and data manipulation language (DML) T-SQL scripts for database objects in SQL Server running anywhere, Azure SQL Database, and Azure SQL Data Warehouse. You can save the generated T-SQL script to a .sql file or pipe it to standard nix utilities (for example, sed, awk, grep) for further transformations. You can edit the generated script or check it into source control and subsequently execute the script in your existing SQL database deployment processes and DevOps pipelines with standard multiplatform SQL command line tools such as sqlcmd.

SQL Database script generation for Visual Studio 2008


This project host a Visual Studio Add-In for creating schema scripts, stored procedures and views from SQL Server. Basically, with a couple of clicks you can generate all your tables, stored procedures, and views as individual scripts with DROP/Add statements for foreign keys...

SQL-Builder - Sql builder is a library that helps you create SQL statement in a simpler style.


Sql builder is a library that helps you create SQL statement in a simpler style.