Free database persistence software for linux

subPersistence is an abstract, light-weight yet flexible framework for working with O/R persistence mappers. It provides for independence of a specific O/R mapper such as Hibernate or Castor.
While you can use Hibernate or Castor (or other O/R mappers) directly, coupling your application too tightly to those can be a bad thing. subPersistence makes it easy to switch underlying O/R mappers, thereby decoupling the application layer from those.
It abstracts away differences between the mappers, while still making it possible to use their specific features if needed.
Enhancements:
- This version updates to Java 5 features such as Generics and is the first version to require Hibernate 3.

Lexical::Persistence is a Perl module for persistent lexical variable values for arbitrary calls.

SYNOPSIS

#!/usr/bin/perl

use Lexical::Persistence;

my $persistence = Lexical::Persistence->new();
foreach my $number (qw(one two three four five)) {
$persistence->call(&target, number => $number);
}

exit;

sub target {
my $arg_number; # Argument.
my $narf_x++; # Persistent.
my $_i++; # Dynamic.
my $j++; # Persistent.

print "arg_number = $arg_numbern";
print "tnarf_x = $narf_xn";
print "t_i = $_in";
print "tj = $jn";
}

Simple persistence for Java is an object/relation mapping framework for Java. It is designed to be easy to use.
There are no XML files to write, no tables to create, no IDs to generate, and no primary keys to fiddle with; just point it to the database, check the API documentation for three basic methods, and code away.
Simple persistence for Java supports transactions, has its own simple query language (very similar to SQL), and can handle object references, lists, and maps.
You may ask: Why another O/R mapping library? Well.. Ive searched the net for a suitable O/R tool for a long time now, also tried a few in live projects, but each time, at the end of the project, I had always had a few thoughts to simplify the database interaction code. Ive started with EJB around 2000. Now, I think everyone who used EJBs also at least once wondered why saveing a friggin object requires a separate server installation, the extensive knowledge of a 200+ page documentation, generating 3 classes/interfaces per object, installing stubs, rmi, and other things I dont even want to know about. Lets just skip this chapter of my life directly to my last experience with an O/R library: pbeans. This library is generally good, I can recommend it for those, who want a stable O/R mapping tool, but it was not the one for me. I found a few points I couldnt get over:
- Save and insert should be one method. I usually dont care if an object is inserted or saved phisically, as long as its saved.
- It should handle Lists and Maps. Well, "Lists should be enough for everybody", but sometimes Maps are handy too. Lists are used very often, I think it should be handled automatically.
- The query code is too difficult, and at the same time does not offer enough features.
- The code you have to write wont be "pretty". It requires classes to be parameters, at least for queries, and I cant read the query itself.
- The Id handling is not transparent.
Enhancements:
- A major scalability feature has been added: the library is now capable of working in a distributed environment, such as load-balanced Web server clusters.
- All the library nodes connected to the same database will form a self-regulating, self-organizing, failure-tolerant network to manage exclusive resources (such as locks, etc).
- The documentation and site were updated accordingly.

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.

Database Fishing Tool is short DaFT is a front-end to any database that can be connected to with an ODBC driver. DaFT allows you to browse the database objects, view data in tables and views, and create and execute SQL statements, also as a script, including variable scanning.
DaFT contains a database objects list (tables and views), list of columns and column properties, a table for data snapshots, detailed data view, a notepad, a table for viewing the outcome of select statements, T-SQL or PL/SQL statements, a SQL statement editor with syntax highlighting, and a screen to follow all ODBC driver messages (errors etc.).
All selected data can be saved into a file. The supported file formats are HTML, XLS, CSV, SyLK, and DIF. The SQL statements can be saved into a text file.
Enhancements:
- Handle Tables, Views, and colums with names (partly) in capitals with surrounding quotes.
- Some bug fixes...

Persistent::Base is an Abstract Persistent Base Class.

SYNOPSIS

### we are a subclass of ... ###
use Persistent::Base;
@ISA = qw(Persistent::Base);

ABSTRACT

This is an abstract class used by the Persistent framework of classes to implement persistence with various types of data stores. This class provides the methods and interface for implementing Persistent classes. Refer to the Persistent documentation for a very thorough introduction to using the Persistent framework of classes.

This class is part of the Persistent base package which is available from:

http://www.bigsnow.org/persistent
ftp://ftp.bigsnow.org/pub/persistent

Before we get started describing the methods in detail, it should be noted that all error handling in this class is done with exceptions. So you should wrap an eval block around all of your code. Please see the Persistent documentation for more information on exception handling in Perl.

ABSTRACT METHODS THAT NEED TO BE OVERRIDDEN IN THE SUBCLASS

datastore -- Sets/Returns the Data Store Parameters

eval {
### set the data store ###
$person->datastore(@args);

### get the data store ###
$href = $person->datastore();
};
croak "Exception caught: $@" if $@;

Returns (and optionally sets) the data store of the object. This method throws Perl execeptions so use it with an eval block.

Setting the data store can involve anything from initializing a connection to opening a file. Getting a data store usually means returning information pertaining to the data store in a useful form, such as a connection to a database or a location of a file.

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)

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