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.
Platforms: PHP
License: Freeware | Size: 10 KB | Download (47): DataMan Query Manager Download |
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
Platforms: PHP
License: Freeware | Size: 10 KB | Download (43): MySQL for PHP Download |
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
License: Freeware | Size: 10 KB | Download (44): Mysql Database Functions Download |
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
License: Freeware | Size: 10 KB | Download (44): Operaciones Database Download |
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
License: Freeware | Size: 10 KB | Download (51): DB Cron Download |
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
License: Freeware | Size: 1.31 MB | Download (33): StelsCSV for linux Download |
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
License: Freeware | Size: 5 MB | Download (66): ApexSQL Refactor Download |
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
License: Freeware | Size: 4.8 MB | Download (769): MySQL Query Browser Download |
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
License: Freeware | Size: 21.5 MB | Download (49): Navicat for Oracle for Mac OS Download |
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
License: Freeware | Size: 81.92 KB | Download (50): Reverse Snowflake Joins Download |
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
License: Freeware | Size: 9.32 MB | Download (537): SSuite Office - MonoBase Download |
A bunch of PHP functions that allows to manipulate data on plain text files through typical SQL queries.
Platforms: Windows, Mac, Linux
License: Freeware | Size: 18.52 KB | Download (48): fileSQL Download |
JdbcBrowser displays database metadata, records of tables and result of SQL queries. JDBC driver is required.
Platforms: Windows, Mac, Linux
License: Freeware | Size: 82.65 KB | Download (48): JdbcBrowser Download |
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
License: Freeware | Size: 21.64 KB | Download (46): PDO Access Download |
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
License: Freeware | Size: 408.7 KB | Download (47): ShiftOne ExQ Download |
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
License: Freeware | Download (62): SqlBuilder Download |
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
License: Freeware | Size: 4.15 MB | Download (48): TAS - Transcription Analysis System Download |
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
License: Freeware | Size: 384.08 KB | Download (50): TestSetGenerator Ant task Download |
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
License: Freeware | Download (57): Product Query Factory Download |
It can also optionally generate SQL queries to input the data into a database.
Platforms: Windows, Mac, *nix, PHP, BSD Solaris
License: Freeware | Download (50): form_handler Download |