Free graphical database software for linux

myDVDs project is a complete personal Web-based graphical DVD inventory database based fully upon PHP with a MySQL backend and the master Region1 DVD database.
Additionally, it makes use of the :CueCat: barcode reader for database Adds and Searches. It represents an easy and efficient way of managing that ever-growing collection of DVDs.
Enhancements:
- The install script was rewritten.
- The upgrade script now handles nearly all of the manual steps.
- The HTML code has been tweaked.
- Images are now in the themes CSS.
- The login form has been reworked. XML and PDF generation have been fixed.
- The documentation has been updated.

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.

Graphical editor for creating GStreamer media pipelines

Lets you quickly assemble and test various GStreamer pipelines to make audio and video players, transcoders and so on.

SDB is an utility for traders to manage a collection of live shows.
SDB is an utility for traders to manage a collection of live shows. It currently features various export formats (txt, html) and a gui to browse, add, edit your shows.
Main features:
Currently implemented features
- runs on Linux and Windows (should even run on MacOS, but I cant test this...)
- export options:
- HTML
- plain text
- PHP
- XML
Open tasks
- create lists of shows you dont have (ISO)
- import your lists in various formats (etrees CSV format)
- additional export formats (PDF/PS/DVI, CSV for etree.org)
- BitTorrent features (create .torrent files from your data)

ROX Filer is a fast and powerful graphical file manager.

It has full drag-and-drop support and background file operations, and is highly configurable.

PHP Database Interface is an easy to use PHP database interface meant to give applications universal support across many databases, including several flat file formats.
Installation
These are just a few notes installation notes regarding DBi and using it with your project
txtSQL support requires the following files from the release archive (currently 3.0 Beta is Supported) :
txtSQL.class.php, txtSQL.parser.php & txtSQL.core.php To be placed in the 3rdparty/txtsql/ directory or the location of your choice
fileSQL support requires the the following file from the release archive (currently 1.0 RC4 is Supported) :
fileSQL.php To be placed in the 3rdparty/fql/ directory of the location of your choice
Test data and a demo script is available in the demo/ directory
Simple Example
// The filesystem root path to DBi needs to be defined before the include
define(PHP_DBI_ROOT, C:/program files/apache group/apache2/htdocs2/modules/dbi/);
define(PHP_DBI_FQL, PHP_DBI_ROOT.3rdparty/fql/fileSQL.php); //Required for FQL Support
define(PHP_DBI_TXTSQL, PHP_DBI_ROOT.3rdparty/txtsql/); //Required for txtSQL Support
include_once("../dbi.php");
$interface = dbi::factoryControllerConstruction(); //create a new dbi object
// open a connection to the database (this will example will work with any
// of the interfaced databases
$interface->open_connection_now_persistent("fql&".PHP_DBI_ROOT."3rdparty/fql/data&demo");
//Select the entire contents of test2 table and store the first row
$inteface->ExecuteQueryAndReturnRow?(array(select => *, from => test2));
$results = $interface->fetchRowThenGetAnotherrow();
//Display the first row of results
print "First Row: ";
print_r($results);
print "< br >";
$interface->disconnect_fromDatabase(); // Closes connection to the database
Enhancements:
- The tableInfo function was added to return the schema.
- LIMIT was added to select functions for supporting databases.
- LIMIT emulation is available to all database types.
- Support for the Firebird database was added.

MirrorMed is a friendly fork of ClearHealth. MirrorMed project uses the same codebase with slower releases, further testing, and additional forms, reports, and other small improvements. As with ClearHealth, MirrorMed also borrows from FreeMed and OpenEMR.
Installation:
The installation of mirrormed is now accomplished through a graphical installer.
Untar the mirrormed tgz file into your web directory and rename it to "mirrormed". Then point your browser to the mirrormed directory.
The installer will check your dependancies, what directory permissions need to be changed, create the configuration files and install the database.
Enhancements:
- Changes allow for the correct printing of the HCFA 1500 (CMS 1500) medical billing form.

Druid project is a tool that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard.
In addition to sql options, the user can document each table and each field with HTML information. Once the database is created, the druid can generate:
- HTML documentation: for all tables, with browsing facilities
- PDF documentation: for all tables
- Java classes: (one class for each table) that contain tables constants (such as fields size) plus java code added by the user
- A data dictionarythat contains all tables and fields present in the database
- SQL script which contains all table definitions that can be piped to the DBMS
- And much more info...
Main features:
- Graphical editing
- Tables groupable in a hierarchy
- Extended generation capabilities including HTML documentation, Data Dictionary, SQL script, Java classes
- Custom datatypes for the database that are mapped into real DBMS datatypes
- Revision history and automatic build increment
- Custom java code for each table
- Table summary
- Table editing facility
- Automatic table localization for multi-language applications
- Cut & Paste
Enhancements:
- The Oracle and Postgres SQL generation modules were improved.
- The passwords in the configuration file were scrambled.
- A NoClassDefFoundError was fixed in the OJB module.
- A problem with CREATE OR REPLACE TRIGGER was fixed.