Free postgres database jdbc software for linux

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)

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.

PostgreSQL is a highly-scalable, SQL compliant, open source object-relational database management system. With more than 15 years of development history, it is quickly becoming the de facto database for enterprise level open source solutions.
PostgreSQL is an object-relational database management system (ORDBMS) based on POSTGRES, Version 4.2, developed at the University of California at Berkeley Computer Science Department. POSTGRES pioneered many concepts that only became available in some commercial database systems much later.
PostgreSQL is an open-source descendant of this original Berkeley code. PostgreSQL supports SQL92 and SQL99.
Main features:
- complex queries
- foreign keys
- triggers
- views
- transactional integrity
- multiversion concurrency control
Additionally, PostgreSQL can be extended by the user in many ways, for example by adding new:
- data types
- functions
- operators
- aggregate functions
- index methods
- procedural languages
And because of the liberal license, PostgreSQL can be used, modified, and distributed by everyone free of charge for any purpose, be it private, commercial, or academic.

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

Firebird is a relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms.

Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. Firebird Relational Database has been used in production systems and under a variety of names since 1981.

Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000 under the InterBase Public License v.1.0.


New code modules added to Firebird are licensed under the Initial Developers Public License. (IDPL). The original modules released by Inprise are licensed under the InterBase Public License v.1.0. Both licences are modified versions of the Mozilla Public License v.1.1.

Installing:

In order to install the firebird version of IB 6.0 you will need to perform the following steps:

1. Get the required packages:

Get the glibc update from RedHat, the one I used
was from ftp://updates.redhat.com/7.0/i386/glibc-2.2-5.i386.rpm

Get ncurses4 from
ftp://carrier.ision.net/pub/ftp.redhat.com/i386/en/RedHat/RPMS/ncurses4-5.0-2.i386.rpm
or another redhat mirror.

Get Firebird from
ftp://firebird.sourceforge.net/pub/firebird/release/FirebirdSS-0.9-1.i386.rpm

2. Prepare the installation:

Log in as root.
Use a plain text console to do this and be sure
that all Gnome desktops are closed.
(One user reported that the Gnome desktop
(apparently ICEwm)
blocked port 3050. I could not reproduce this
here, but it seems that it uses port numbers
that arent assigned in /etc/services for own
purposes)

3. Add localhost.localdomain to /etc/hosts.equiv:
echo localhost.localdomain >>/etc/hosts.equiv

4. Change to the directory where you have placed
the downloaded packages.

5. Install the glibc update:
rpm --install --force glibc-2.2-5.i386.rpm

6. Install libncurses.so.4:
rpm --install --force ncurses4-5.0-2.i386.rpm

7. Install Firebird:
rpm --install --force FirebirdSS-0.9-1.i386.rpm

8. Add /opt/interbase/bin to your path:
You can either change /etc/profile
or do
export PATH=$PATH: /opt/interbase/bin
or
change the profiles in your users home directories

9. Check that all went well:

Read /opt/interbase/SYSDBA.password
to get your SYSDBA password.

gsec -display
should display the list of known users
(SYSDBA only after a fresh install)

isql /opt/interbase/examples/employee.gdb
SQL> SHOW TABLES;
should display all tables from this database
SQL>quit;