Free mysql database hack 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

Media Database is a media database that uses PHP for the GUI and MySQL for data storage.

It has movie, series, and anime listings. Media Database has lending and wishlist capabilities.

Installation:

Unpack mediadb-*.tar.gz to www dir or public_html dir.
Edit config.php, change mysql_user_name, mysql_password and mysql_server_host to match your MySQL database username, password and host.
run url: http://url_to_mediadatabase/install_mediadb.php, and follow the link and log in as admin and make default yourself a user.

*******************************************************************
****** Dont use the admin user for adding films and stuff. ******
*******************************************************************

If there are any problems, please send a short description of where it occurs and the error message to my email addres: marco (at) cakebox (dot) net, marc the topic with [mediadb]: (something you find fitting)

MySQL Abstractor package contains PHP classes that implements a MySQL database abstraction layer.

It provides several classes. There is one for establishing connections and executing SQL queries, another for composing and executing SELECT, INSERT, UPDATE and DELETE queries from a list of parameters, and a wrapper class to simplify the usage of the other two classes.

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.

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.)

MySQLfs is Linux userspace filesystem which stores data in a MySQL database. The project uses FUSE to interface with the kernel.