Free graphical database query software for linux

PHP MySQL Database Layer Class is a php class providing some very useful methods to work with a mySQL database.
Main features:
- connects you to a mySQL host and select a database in a single call (opposed to PHPs native functions which requires two steps)
- has a "query" method that has the same role as PHPs mysql_query but this one will tell you about the affected rows (through the "affectedRows" property) when executing an INSERT, UPDATE, DELETE query and about the found rows (through the "foundRows" property) when executing a SELECT query - the "foundRows" property tells you how many records would the query return if there was no LIMIT applied to it - very useful when creating listing so you dont have to do a query to determine how many records you have in a database and the again a query to show only the records from a page
- has an "escape_string" method that will "mysql_real_escape_string" your string weather the magic_quotes are on or not
- has a "dlookup" method that i am sure you will find VERY useful once you get to know it: it return data from a single table cell based on standard mySQL WHERE criteria - see the manual for detailed info! (yes, it acts exactly like the function with the same name from microsft access)
- provides you with a very useful debug interface which shows you each query your script is running, for how long, the total number of queries made, the total execution time of your queries, errors of your queries and what are the values of $_GET, $_POST, $_COOKIES and $_SERVER superglobal variables. The debug interface is template driven and supports localisation.
- it will notify you if a specific query is executed more than once and will advise you to optimize the script
- you can instruct it to send you an email if a query runs longer then a specified time
- the code is heavily documented so you can easily understand every aspect of it and even maybe use it as a php tutorial
Enhancements:
- the state of $_FILES and $_SESSION superglobals are now also shown in the debug window
- better integration with XTemplate (previously, there was a variable assigned to each entry in the language file now the XTemplates feature to handle arrays is used)
- properties will now have default values in PHP 4

Practical Query Analyzer produces HTML reports on the most frequent queries, slowest queries, queries by type (select/insert/update/delete), and more for both PostgreSQL and MySQL log files.

Database Functions is a PHP class that can be used to build and execute MySQL database queries.

It can build SELECT, INSERT, UPDATE and DELETE queries from lists of parameters and values.

The class can also execute the generated queries and retrieve the SELECT query results into associative arrays.

Simple C++ ODBC Database API is designed to encapsulate the ODBC API functionality in an object oriented manner.
The API was created due to an absence of any other such API that was database independent. The database independence is achieved using the ODBC (Open DataBase Connectivity) API.
The API provides a Database object that can be used to create instances of Query objects. The Query objects are used to query a database and allow columns to be bound for the query.
The flowing column objects are currently available (as of Jan 2005): a boolean column, a long column and a string column. The string column makes use of the libstdc++ string class so you dont have to mess around with malloc.
The Database object also has some convenience member functions that allow queries that return a single integer or string to be executed without having to create a query object or bind columns.
The API has been tested to work with both MySql and PostGreSQL on a Debian Linux platform.
Enhancements:
- DoubleColumn, IntColumn, and BigintColumn were added.
- The LongColumn is deprecated.

Aqua Data Studio program is a database query tool and administration tool that allows developers to easily create, edit, and execute SQL scripts, as well as browse and visually modify database structures.
Aqua Data Studio provides an integrated database environment with a single consistent interface to all major relational databases. This allows the database administrator or developer to tackle multiple tasks simultaneously from one application.
Main features:
Query Analyzer/Window
- Aqua Data Studios sophisticated Query Analyzer allows users to work on database scripts with specific RDBMS syntax highlighting and auto-completion to develop and test SQL scripts. Other features to speed up development include SQL automation, auto-describe and sortable multi-grid results. The query analyzer also provides client side variable binding, allowing a user to execute stored procedures or functions with local variables binded to receive out parameters. The query window also provides two modes of operation, using a SplitPane View or a MultiTab View for the editor and the query results.
Schema Browser & Visual Editing
- Its graphical browsing capabilities allow you to understand the structure and dependencies of the database schema with a single mouse click. The schema browser also allows you to visually edit any schema object with a graphical design form to CREATE, ALTER or DROP the object. Visual editing supports Tables, Indexes, Procedures, Data Types and other schema objects. The visual editors also provides an SQL preview of all the commands to be executed to commit the operation.
Schema Extraction & DDL Scripting
- Its graphical browsing allows you to extract the structure definition of all schema objects and to script the SQL DDL and DML (eg CREATE, ALTER, DROP, SELECT, INSERT, UPDATE and DELETE) syntax for database schema objects (including Tables, Views, Triggers, Stored Procedures and Functions).
Table Data Editor
- A powerful Table Data Editor allows you to modify your results graphically and save them. By writing a single table SELECT statement in the Query Analyzer and clicking on the Execute Edit button, a separate window is opened with the query results for you to edit and save. You may also browser to a table in the schema browser and select the Edit Table from the popup menu to edit the first 1000 records in a table.
Enhancements:
- Enhancements in this release include OS X Integration, Windows integration, complete and customizable keymapping, a schema difference tool, a directory difference tool, a file difference tool, a tab difference tool, a copy history difference tool, SQL Server DBA tools, and Sybase DBA tools.
- In total, there were over 100 new features.

Class::DBI::Query is a Perl module with deprecated SQL manager for Class::DBI.

SYNOPSIS

my $sth = Class::DBI::Query
->new({
owner => $class,
sqlname => $type,
essential => @columns,
where_columns => @where_cols,
})
->run($val);

This abstracts away many of the details of the Class::DBI underlying SQL mechanism. For the most part you probably dont want to be interfacing directly with this.

The underlying mechanisms are not yet stable, and are subject to change at any time.

Relations is a Perl module with functions to use with databases and queries.

SYNOPSIS

use Relations;

$as_clause = as_clause({full_name => "concat(f_name, ,l_name)",
{status => "if(married,Married,Single)"})

$query = "select $as_clause from person";

$avoid = to_hash("virustbug","t");

if ($avoid->{bug}) {

print "Avoiding the bug...";

}

unless ($avoid->{code}) {

print "Not avoiding the code...";

}