Free graphical database designer software for linux

The IceWM Control Panel (IceWMCP) IcePref2 Theme Designer tool allows you to easily create and modify themes for IceWM.
IceWM Control Panel (IceWMCP) is the first full-featured, Gtk-based control panel for IceWM. It is meant to run in IceWM, but can be used in ANY window manager as a general-purpose control panel.
IceWMCP is multi-lingual. Currently, the following languages are supported: English, Spanish, Russian, Traditional Chinese, French (partial), and Finnish (IceWMCP-IceMe only).
Developers: If you would like to use IceWMCP as the foundation for a new control panel (for a new window manager, etc.), see the developers release of IceWMCP. IceWMCP was inspired by the Qt-based application called IceCC, but includes many more tools, a more familiar Windoze Control Panel-like interface, and uses the MUCH faster Gtk user interface (Who runs a fast Window Manager like IceWM, to launch SLOW-running, memory-intensive Qt/KDE-based applications?? I sure dont).
Lets face it: IceWM and fast Gtk interfaces work well together. In addition, because IceWM Control Panel is written with a TRUE open source widget set, Gtk+, you dont have to worry about the licensing problems associated with proprietary QT-based applications. IceWM Control Panel is TRUE open source, through and through.
Version restrictions:
- Access to a Bash shell (very important)
- Python (2.2 or better), PyGtk-2 (1.9.9/2.0.0 or better)
- Gtk+ 2.0.6 or better - neither Gnome nor PyGnome is required
- (IceWMCP versions 2.5 and earlier require Gtk+1 and PyGtk-1 0.6.9)
- Your version of PyGtk should have the Gdk-Pixbuf modules on your system
- Please run ALL IceWMCP programs from a BASH shell: Using other shells such as ksh, pdksh, csh, tcsh, etc. is likely to cause problems.
- If your IceWMCP programs have trouble launching other applications, it is most likely because you are using something other than a Bash (/bin/bash) shell.
- Run the programs from Bash...period!

General Graphics User Interface is an effort to produce a common graphical user interface for any command-line program.

It uses a wizard-like input front end to collect the information needed. It then calls the desired program automatically with all the necessary options.

The user is able to point&click on various options and select them in a convenient way. In order to create a new user-interface, a user doesnt need to know a programming language, since there is a graphical editor for new GGUI "scripts".

Zild Database Library implements a small and easy to use database API with an easy to use API.
Main features:
- ability to connect to multiple database systems
- zero runtime configuration
- ability to connect using a URL scheme
- thread-safe connection pooling.

Valentina is cross-platform DBMS that makes it easy to switch between a local embedded database and server using the same sources. It supports disk and in-memory databases, field types from Bit to BLOB, and both a SQL92(99) and non-SQL API.
Valentina supports Relational, Extended Navigational, and Object-Relational data models. It introduces a revolutionary model abstraction "Link". It works natively in UTF-16, can accept 270 encodings, and features advanced features such as regular expressions, XML, full-text search, pictures, functions, and calculated fields. It offers triggers, views, and stored procedures.
Enhancements:
- Valentina Studio now has a Diagrams panel for database schema.
- There are new examples on the usage of Link refactorings API and SQL commands.
- There are about 40 bugfixes over the entire product line (kernel, PHP, REALbasic, Director, VCOM, and VStudio).

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.

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.

The Program Database Toolkit (PDT) is a powerful tool infrastructure that provides access to the high-level interface of source code for analysis tools and applications.
Many tasks in an integrated programming environment require access to program information for their implementation. Program Database Toolkit (PDT) is a framework for analyzing source code written in several programming languages and for making rich program knowledge accessible to developers of static and dynamic analysis tools.
PDT implements a standard program representation, the program database (PDB), that can be accessed in a uniform way through a class library supporting common PDB operations. Software tools can use this library to accomplish tasks such as
- documentation of program components
- creation of graphic program browsers that show class hierarchies, function call graphs, and template instantiations
- insertion of instrumentation for performance profiling and tracing; andgeneration of interface details for calling library routines or buildinginterlanguage bindings.
Enhancements:
- Assorted minor bugfixes.

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]);