Free database querying software for linux

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.

DBPrim project is a library providing basic building blocks for creating in-memory databases.
Main features:
- Linked lists
- Hash tables with optional auto-resize
- Memory-efficient sparse matrices built on hash tables
- Red-black trees.

Mckoi SQL Database is a full featured SQL-92 relational database management system written in Java.

The software can operate as either a dedicated multi-client, multi-threaded database server, or can be used as an embedded database inside a Java application.

The engine is designed to be easy to use and maintain and versatile for sophisticated database development tasks. The software provides a JDBC 2.0 driver.

To use Mckoi SQL Database, you will need a JavaTM runtime environment version 1.2 or greater. Sun provides Java runtimes for Win32, Solaris and Linux from their website at http://www.javasoft.com/j2se/. IBM also provides various Java runtimes for a number of platforms at http://www.ibm.com/java/jdk/download/.

When Java has been installed on your system, unpack the mckoi distribution file to a directory in your file system. Then you are ready to create a database and develop your database application.

Creating A Database

Before you can begin development of your database application, you will need to create and configure a blank database. The database configuration file describes all of the configurable properties of the database (details of the database configuration file are covered in the next section). The software ships with a default configuration that looks for a database at path ./data in your filesystem.

To create a database using the default configuration with an admin username of admin_user and password aupass00, go to a prompt, change to the Mckoi Database distribution directory and type:

java -jar mckoidb.jar -create "admin_user" "aupass00"

We do not advise using either this username or password in a production system. The user created here has full control over every aspect of the database so choose a username / password carefully.

When the command has completed, a sub-directory called data will have been generated. This directory is used to store data from the database. A sub-directory called log is also generated which stores debugging and query log information.

Database Configuration

When you run the mckoidb.jar package, it looks for a file named db.conf in the current directory. This file contains a number of variables that determine where the database looks for information, as well as other user-definable properties. The configuration file can be renamed and copied to a different location. If you change the configuration file location, you must supply the location when you run the database;

java -jar mckoidb.jar -conf [location of conf file] .....

You can edit the configuration file with a text editor. The default configuration file that ships with the software contains extensive comments on what each variable does.

Used Textbook Database provides a database for listing used textbooks.

Used Textbook Database is a Web-based textbook database that lets users to create an account and list their used textbooks or books.

It is very modular and customizable and allows for easy integration into an existing Web site.

PHP mySQL Database Wrapper Class provides a set of methods for interacting with a MySQL database easily and securely. Most of the methods are extended versions of PHPs native functions, but providing a lot more functionality and powerful debugging features.
There are also new methods that greatly simplify the process of executing specific queries like returning specific rows or even single values from specific rows, SUM(), COUNT(), and MAX() queries.
Enhancements:
- The result of select queries can now be cached.
- All records returned by SELECT queries were shown in the debug window, which would crash the script if there were lots of rows.
- The "showMaxRows" allows you to restrict this number.
- A bug when working with queries using replacements and having apostrophes in the replacements was fixed.
- Due to a typographical error, no error message was shown if a database could not be selected.
- New methods were added: "delete", "truncate", "insert", and "update" which are all shorthand for performing the respective SQL tasks.

Haskell Database Connectivity project provides an abstraction layer between Haskell programs and SQL relational databases. This lets you write database code once, in Haskell, and have it work with any number of backend SQL databases (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)
HDBC is modeled loosely on Perls DBI interface http://search.cpan.org/~timb/DBI/DBI.pm, though it has also been influenced by Pythons DB-API v2, JDBC in Java, and HSQL in Haskell.
HDBC is a from-scratch effort. It is not a reimplementation of HSQL, though its purpose is the same.
Main features:
- Ability to use replacable parameters to let one query be executed multiple times (eliminates the need for an escape function)
- Ability to access returned rows by column number
- Ability to read data from the SQL server on-demand rather than reading the entire result set up front
- HUnit testsuite for each backend driver
- Well-defined standard API and easy backend driver implementation
- Lazy reading of the entire result set (think hGetContents, but for the results of SELECT) (see sFetchAllRows)
- Support for translation between Haskell and SQL types
- Support for querying database server properties
- Add-on package (hdbc-missingh) to integrate with MissingH, providing a database backend for AnyDBM.
- Support for querying metadata such as column names.
- Support for querying additional metadata (column types, etc.)

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.

MySQL Query Browser is a database querying tool.

MySQL Query Browser combines the simplicity of a Web-browser-like interface with powerful features like multiple result sets on tab sheets, query history, storing query "bookmarks", editing and comparing resultsets, SQL script debugging, and more.

MySQL Query Browser is available under the MySQL AB "dual licensing" model. Under this model, users may choose to use MySQL products under the free software/opensource GNU General Public License (commonly known as the "GPL") or under a commercial license.