Writing Sql Queries

As part of the DataMan series, The Query Manager allows you to construct and test your sql queries. If you a happy with the result, you can store the query for later use. A useful tool to create and manager reports.

MySQL for PHP is connection to a database host can be established and SQL queries can be executed.Key Features of MySQL for PHP:- Retrieve query results into arrays- Retrieve the number of result set rows and the last inserted identifier

Mysql Database Functions is a wrapper around MySQL database access functions that can execute SQL queries, retrieve data from tables, list tables, list table fields and optimize or truncate tables.


Platforms: PHP

Operaciones Database can be used to compose and execute SQL queries to a PostgreSQL database.It provides several functions that can build SQL INSERT, UPDATE, DELETE queries from a list or arguments that define the fields and values used in the queries.


Platforms: PHP

The DB cron module allows you to create and manage a set of SQL queries. Each query is run at a regular interval using the cron system, and you can specify a different interval for each query.


Platforms: PHP

StelsCSV is a CSV JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on text files (comma-separated, delimiter-separated, fixed-length, etc). Also, the driver can be used for writing data importing applications and migration tools. Here are some key features of...


Platforms: *nix

ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code and database tables with ease. It can format and refactor code directly in SSMS or VS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused...


Platforms: Windows 7, Windows Server, Windows

MySQL Query Browser is the easiest visual tool for creating, executing, and optimizing SQL queries for your MySQL Database Server. The MySQL Query Browser gives you a complete set of drag-and-drop tools to visually build, analyze and manage your queries.


Platforms: Windows, *nix

An ideal solution for Oracle administration and development which lets you create, edit databases, run SQL queries and connect to remote Oracle in an easier way. It features an intuitive GUI and offers powerful visual tools such as Query Editor with syntax highlight capability, SQL Preview, SQL...


Platforms: Mac

Reverse Snowflake Joins (abbreviated as revj) is a tool to understand SQL and document SQL queries. This is especially good for maintaining big queries written by somebody else. "Big SQL" can be as many as 20 tables, joined by multiple fields.


Platforms: Mac

Features Available: - Create unlimited databases with unlimited tables, fields, and rows - Access any ODBC compatible database of any size, from 1 Kilobyte to 1 Terabyte - Filter tables instantly - Run SQL statements with the SQL query engine - Create custom reports for all your databases - Full...


Platforms: Windows

A bunch of PHP functions that allows to manipulate data on plain text files through typical SQL queries.


Platforms: Windows, Mac, Linux

JdbcBrowser displays database metadata, records of tables and result of SQL queries. JDBC driver is required.


Platforms: Windows, Mac, Linux

This class provides some methodts - to easily get results forom SQL-Queries as Array, Hashtable or Value (e.g. SELECT MAX(..) FROM ..) - To insert, update or delete records - It works together with my other Library stdfuncs (PHPCoreStdFuncs in SF)


Platforms: Windows, Mac, Linux

Externalized Queries - a Java framework for externalizing SQL queries from source code. Query descriptor supports conditional logic and configurable caching. Custom taglib simplifies data display on JSPs.


Platforms: Windows, Mac, Linux

SqlBuilder is a library which attempts to take the pain out of generating SQL queries within Java programs. Using one programming language (Java) to generate code for another language (i.e. SQL) is always a challenge. There are always issues with escaping characters within string literals,...


Platforms: Windows, Mac, *nix, Java, BSD Solaris

TAS (Transcription Analysis System) is a multi-tier framework for running parameterized SQL queries. Users can analyze new data or new combinations of data with a few clicks in a GUI. Potentially complex/repetitive database interaction is all automated


Platforms: Windows, Mac, Linux

An Ant task for generating property files with testsets based on the results of SQL queries and validation plug-ins. Very usefull when building unit tests that make use of changing datasets.


Platforms: Windows, Mac, Linux

The Product Query Factory class generates all the product related sql queries dynamically. This makes it much easier to modify the source tables (especially column names) that OSC reads and writes to. For example, I plan to use it to make OSC reads it's products from an already existing product...


Platforms: Windows, *nix, PHP, BSD

It can also optionally generate SQL queries to input the data into a database.


Platforms: Windows, Mac, *nix, PHP, BSD Solaris