Free database normalization software for linux

MP3DB2 is a collection of bash scripts for keeping track of large MP3 collections. It will retrieve song information from the filenames and ID3 tags of a directory or CD of MP3s and store them in a local database.
This program is a complete rewrite of my MP3 database version 1. Version 1 only stored the data that was present in the filenames while version 2 actually retrieves information from the ID3 tags of each MP3.
Please note that as of this version the database format is NOT considered carved in stone. I have already added a few fields mid-development and this will continue for a while if I think the format can be made better. See the changelog for a list of changes to the database format since V2.0.
Enhancements:
- mp3dupe: now just displays the name of the directory we are checking not the full path in the host filesystem.

DBSchema::Normalizer is a database normalization. It can convert a table from 1st to 2nd normal form.

SYNOPSIS

# the easy way is to give all parameters to the constructor
# and then call do()
#
use DBSchema::Normalizer;
my $norm = DBSchema::Normalizer->new (
{
DSN => $DSN,
username => $username,
password => $password,
src_table => $sourcetable,
index_field => $indexfield,
lookup_fields => $lookupfields, # comma separated list
lookup_table => $lookuptable,
dest_table => $dest_table,
copy_indexes => "yes",
});
$norm->do(); # Just Do It!

# Alternatively, you can have some more control, by
# creating the lookup table and normalized table separately,
# especially useful if one of them is an intermediate step.
#
use DBSchema::Normalizer qw(create_lookup_table create_normalized_table);
my $norm = DBSchema::Normalizer->new(
{
DSN => $DSN,
username => $username,
password => $password
});
$norm->create_lookup_table (
{
src_table => $tablename,
index_field => $indexfield,
lookup_fields => $lookupfields,
lookup_table => $lookuptable
});
$norm->create_normalized_table (
{
src_table => $tablename,
index_field => $indexfield,
lookup_fields => $lookupfields,
lookup_table => $lookuptable,
dest_table => $dest_table,
copy_indexes => "yes",
});

DBSchema::Normalizer is a module to help transforming MySQL database tables from 1st to 2nd normal form. Simply put, it will create a lookup table out of a set of repeating fields from a source table, and replace such fields by a foreign key that points to the corresponding fields in the newly created table.

All information is taken from the database itself. There is no need to specify existing details. The module is capable of re-creating existing indexes, and should deal with complex cases where the replaced fields are part of a primary key.

Noatun Normalize aims to develop a normalization plugin for the KDE media player Noatun.
It is composed of two parts, an Arts effect that handles the actual normalization of the played samples, and a Noatun plugin, that reads the relative volume adjustments and passes them to the effect. There are two ways the plugin can retrieve the relative volume adjustments:
1. it looks for the respective mp3 id3v2 tags or ogg tags which can be set by tools like normalize and vorbisgain,
2. it runs these tools itself and stores the results in the playlist items meta data. Thus the files wont be changed.
- For ogg vorbis normalization to work you need the latest vorbisgain version (0.36).
- For mp3 or wav normalization you need the normalize program.
- Make sure to install the package under the same prefix as artsd otherwise arts will not find the NoatunNormalize effect.
- If there is popular demand for it I would try to remove the dependency on the external programs and integrate them into the plugin itself.

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

DBPrim project is a library providing basic building blocks for creating in-memory databases.
Main features:
- Linked lists
- Hash tables with optional auto-resize
- Memory-efficient sparse matrices built on hash tables
- Red-black trees.

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)

Hello! Thank you for donating your knowledge and time to our cause. Pariahware, Inc. is currently working on a Bible trivia game that is a cross between the TV game show "Who Wants to be a Millionaire?" and the electronic game series "You Dont Know Jack!" As one might imagine, this can be a daunting task.
That is why we are asking for your help in coming up with some GREAT Bible questions in order to make this game even more fun than we could do by ourselves! When you are finished submitting all of your questions, please e-mail the "qanda.rsd" file back to submissions@pariahware.com. By submitting the questions that you come up with, you agree to the following:
The Legal:
1. You expect no royalty fees or other payment for Pariahware, Inc. using your questions in the game.
2. Any parts of the questions you submit may be altered at will by the members of Pariahware, Inc.
3. Even though you submit a question for the game, that does not necessarily mean it will appear in the game.
4. If your name is included in your e-mail, Pariahware, Inc. has the right to add it as an acknowledgement, unless otherwise noted. You will not be paid as a result of having your name listed.
The How To:
1. Make sure that the Got Word DB Maker application and the "qanda.rsd" file are in the same folder or the program will not work.
2. Double-click the Got Word DB Maker application icon.
3. Select the radio button in the lower-left-hand corner that says "Add new question".
4. There are five text fields. The large one on the top is for the question. The other four are for potential answers. All of these need to be filled.
5. The correct answer needs to be selected by the "drop down" in the upper-right-hand corner.
6. The book of the Bible, in which the question is referencing, needs to be selected in the upper-left-hand corner.
7. Below the book selection is value (points) for the question. This needs to be selected as well.
8. When all of this has been done, the "Save New Question" button will activate. Click it to save your question.
Word of Caution:
To make changes to question that you have already entered, click the "edit existing questions" radio button.
Enhancements:
- Bug Fixes.