Free resultset software for linux

Graidle (Graph aid), is a project that is proposed to create an application web for the realization of graph; it comes divided in four parts:
Graidle Fx proposed like didactic instrument for the visualization of diagrams of function to one variable;
Graidle SQL Friendly assists the creation of a graph starting from one query;
Graidle FrontEnd supplies to the user a graph personalized second every own requirement;
Graidle Class is the class that comes supplied for the development;
The realization of the site is apt to the demonstration of the operation of the same application, that it can be more complete visualizing sources releasable liberations in the appropriate Download section. We will have therefore one dedicated section to every part of the plan: In Function the customer will insert the number of functions to visualize, the interval and the quality of the curve and will come created a diagram to the flight; With the FronEnd they will be able to be inserted until to nine series give to you, choosing of the type, the name, the options like the colors, the title it, maximum and minimal, the lines grid etc... the customer will be able to save the just graphical one and to insert it in situated presentations or web; From SQL is a pure demonstrative and educational section, that it concurs to create given diagram of one query SQL; between the multiple usefullnesses there is that one of being able to visualize in realtime the graph of some give you present in database without or that one of being able to enclose to the tables of resultset a diagram that can clarify the visualization of gives to you; the handbook for who is available also wanted to externally use the class to this situated one;
The Graidle project is realized in PHP with the aid of GD2 library.
Enhancements:
- Introducing of Horizontal Histogram graph type;
- Introducing of Extended Legend for Horizontal Histogram;
- Introducing of new legend management system for a better visualization of all type of strings;
- Introducing of Selection standard CSS color on setValue function;
- New setMultiColor() to visualize different color on same value serie ;
- New setColors() to add one or more colors;
- New Bold Font type ;
- New setFontBD() method;
- Modified carry2file() for select patch and filename;

SQLyog is an easy to use tool that lets you manage your MySQL database anywhere in the world. SQLyog is a tool that allows you manage MySQL database.
Main features:
Developer / User Productivity
- HTML Schema Documentation
- Shortcuts to quickly generate SQL statements and paste object names
- Learn MySQL by looking at the SQL generated by SQLyog
- Multi-tab Query Editor and Result-set Editor
- Multiple Query Execution
- Multi-threaded Query execution with option to stop long running queries
- SQL Templates
- Excel-style grid interface to view/update resultsets
- Multi-format Blob editor
- View data in Grid/Text Mode
- ResultSet/Data Export to CSV/XML/HTML
- Full Support from 3.23.38 to the latest 5.x
- Support for all MySQL table handlers
- Excel friendly resultsets/table-data export to clipboard/file
- Dialogless table and resultset editor
DBA Productivity
- Restoring / Importing large SQL dumps
- MySQL 5.x objects support
- User Management
- Managing hosted MySQL
- Connection Manager
- Index Management
- Relationship/Foreign Key Manager
- Reorder Columns
- Copy objects to another Host with single click
- Table diagnostics
- Flush Tools
- Object Browser
- Creating/dropping database
- Optimized for managing Hosted MySQL
- Profiling
- Multiple database connections
Technology
- Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way to communicate with MySQL server
- 100% keyboard friendly
- Small compact binary
- Minimal use of Registry - easy migration of User Preferences by dragging and dropping config files.
- Non-cluttered look and feel, ability to show/hide panes

DBIWrapper is a Perl Module that provides for easier access to databases using DBI. It supports MySQL, PostgreSQL and ODBC DBD modules. High level methods for reading and writing to the database are provided. DBI data structures or XML are returned
Main features:
- The DBIWrapper is a Perl Module which provides easier access to databases using DBI. It currently supports MySQL, PostgreSQL, Sybase and ODBC DBD drivers. High level methods for reading, writing, commiting and rolling back transactions are provided. The DBI data structures can still be used to return the data in.
- XML Support is now available as of DBIWrapper 0.16. Using readXML() you can have the result of your SELECT statement be returned as an XML document (format defined here) which will describe the SELECT statement issued and the rows of data returned from the backend.
- DBIWrapper::XMLParser included in DBIWrapper 0.17! This module parses the XML generated by readXML() and returns a perl data structure in the DBIWrapper::ResultSet module. This makes for extremely easy manipulation of your database data. DBIWrapper::XMLParser relies on XML::LibXML. See README for details.
- HTML Support is now available as of DBIWrapper 0.20. Using readHTML() you can have the result of your SELECT statement returned as an HTML snippet which is fully customizable via CSS. See the man page for more details.
- Sybase Support is now available as of DBIWrapper 0.22!
- Helper methods getDataArray(), getDataHash(), getDataArrayHeader(), getDataHashHeader() do the work of read() and then build up an array with the returned result set. See the man page for more info.
Enhancements:
- DBD::Sybase is now officially supported and the getData... methods (getDataArray, getDataArrayHeader, getDataHash, getDataHashHeader) all know how to properly handle the possible multiple result sets that Sybase can return. getID() was added for returning the ID of the last inserted row.

H2 Database Engine is a free SQL database engine writen in Java.
JDBC and ODBC APIs are supported. Embedded and server modes are available. A Web console application is included. Clustering is supported.H2 Database Engine is a web based java database engine.
Main features:
Fast database engine
- Free, source code is included
- Supports standard SQL
- Written in Java
- Disk based or in-memory databases
- Browser base Console application
- JDBC API
- Limited ODBC support
- Embedded and client/server (network) mode
- High availablility support (clustering / failover)
- Wide range of data types including large objects (BLOB/CLOB)
- Strong security features (SSL, users, roles, encrypted files)
- Multiple connections, table level locking
- Cost based optimizer, using a genetic algorithm for complex queries
- Transaction support (serializable transaction isolation)
- Zero-administration, automatic recovery
- Large resultset, external sorting
- Scrollable and updatable resultset support
- Read only views and inline views
- Inner and outer joins, subqueries
- Many functions already built-in
- Triggers and Java functions / stored procedures
- Referential integrity / foreign key constraints with cascade, check constraints
- Multiple schema support
- Compatibility modes for HSQLDB, MySQL and PostgreSQL
- Sequence and autoincrement columns
- Well tested (high code coverage, randomized stress tests)
- Small footprint (smaller than 1 MB)
- Uses a small number of database files
- Can be compiled to native code using GCJ
- Primary keys, multiple index types (b-tree, linear hash, tree, hash)
- ORDER BY, GROUP BY, HAVING, UNION, LIMIT
- Information Schema
- Multiple connections
- Collation support
- EXPLAIN PLAN support
- The database can generate SQL script files
- Support for linked tables, and a built-in virtual range table
- Automatic re-compilation of prepared statements
- Sophisticated trace options
- Low memory requirements
- Easy to understand exception messages
- Standard handling of NULL values
- Multilanguage console application (at this time, English and German)
Currently, this is not traditional GPL software, but the source code is included. It is free for private and commercial use.
Enhancements:
- H2 now supports the PostgreSQL network protocol, and can be accessed using the PostgreSQL ODBC driver.
- Regular expressions are now supported.
- The per session undo log and referential integrity can be disabled.
- Default settings have been changed to save memory. NOT, boolean columns, and certain joins are optimized now.
- Part of the documentation has been translated to Japanese.

DBIx::Class::LibXMLdoc is a Perl module to create an adjunct "Doc" accessor of a columns data which is automatically parsed into a LibXML documentElement (alpha-software).

SYNOPSIS

package My::DB::thingy;

__PACKAGE__->load_components(qw/ PK::Auto LibXMLdoc Core /);

__PACKAGE__->table(thingy);

__PACKAGE__->add_columns(qw/ id title body created owner whatever /);
__PACKAGE__->set_primary_key(id);

__PACKAGE__->libXMLdoc_columns(qw/ body /);

package main;
use My::DB;

my $schema = My::DB->connect(...);
my $thingy = $schema->resultset("thingy")->find(153);
print $thingy->bodyDoc->toString, "nn";
print $thingy->bodyDoc->textContent, "n";

This DBIx::Class component does not alter your data in any way. It takes column names to get the value from the column, parse it into XML with LibXML and make the documentElement object available via an autogenerated accessor named by affixing the column with "Doc."

The XML parsing is on demand so it doesnt waste time doing it to data you dont use or by doing it more than once to data that is unchanged.

A wrapper XML tag for the mini-document is auto-generated from the table + column name. So-

my $xhmlt =<<less