Free mysql graphical database designer 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

MySQL table patcher is a patch that reads table creation file (tables.sql) and compares it to what mysqldump gives. It creates SQL clauses to update the database to match the creation file.

MySQL wrapped is a C++ wrapper for the MySQL database C application programming interface.
Examples:
The following example should be linked with the mysqlclient library from the MySQL distribution / build.
#include
#include
#include
#include
#include "Database.h"
#include "Query.h"
int main()
{
Database db("localhost","dbuser","","testdb");
Query q(db);
q.execute("delete from user");
q.execute("insert into user values(1,First Person)");
q.execute("insert into user values(2,Another Person)");
q.get_result("select num,name from user");
while (q.fetch_row())
{
long num = q.getval();
std::string name = q.getstr();
printf("User#%ld: %sn", num, name.c_str() );
}
q.free_result();
}
Enhancements:
- This release adds methods to access fields by name.

Quill is a visual Web interface designer based on QuiX, Porcupines integrated XML User interface Language.

It took us quite longer than we expected but here it is. Quill is a visual web interface designer based on QuiX, Porcupines integrated XML User-Interface Language. We believe this is a major leap for the web interface design process, as it has become almost identical to this of a common desktop application.

This is an alpha release and as such there are a lot of missing features, but generally you can get things done a lot faster and easier than before. This release supports almost every QuiX widget, giving you full control over it, exhibiting all of its editable properties.

DB Designer Fork is a fork of the fabFORCE DBDesigner 4. DBDesigner is a visual database design system that integrates entity relationship design and database creation.

The project generates SQL scripts for Oracle, SQL Server, MySQL, and FireBird.

PyDBDesigner is a free relational database modeling tool that is planned to be able to design both logical and physical models similarly to Erwin(c) and PowerDesigner.

Its goal is to provide a useful toolset that allows developers analysts and database designers to design and develop databases from the verbal model to the schemas and SQL scripts.

There is no such a tool is available as a freeware. There is a project called DbDesigner, but it seems to be discontinued and its functionality is not enough for modeling (and the concept behind it seems to be weak).

The concept is to implement ER logical and physical modeling paradigm as correctly as possible, meanwhile creating a tool that is useful as soon as it is possible. So the development concept is that features are added rapidly, but carefully (trying to leave space to the features that come later).

For example, the "type" class is good enough to implement data domains, however, the code that actually creates domains using GUI is not implemented. The "type" attribute of the properties uses this object, so adding domains to attribute types is easy.

PHP Database Access Through Arrays project can be used to access data stored in MySQL tables like accessing arrays. It uses SPL to implement several classes and iterators interfaces to access MySQL databases.

Examples:

$DB[test_table][] = array(
name => first,
value => the first row
);

foreach ($DB[test_table] as $i => $row) {
...
}

$DB[test_table][first][value] = 1st;

unset($DB[test_table][first]);