Free mp3 database creator software for linux

MP3-Database project is a tool to organize your MP3 collection. If you insert a CD with MP3 files in your CDROM drive, MP3DB can read all ID3 tags of the MP3 files.
With this information MP3DB creates a database which can be searched for a specific song, artist, or CD.
A GUI makes it easy to use the program. Any title found in the database can easily be added to a playlist or can instantly be played by XMMS.
Main features:
- MySQL (Is needed as database backend)
- Perl5
- Perl Modules:
- Tk
- Tk-MesgBox
- Tk-LabFrame
- Tk-Pane
- DBI
- MP3-Info
- Msql-Mysql-modules
- To play MP3 files the MP3 player XMMS should be installed on your system. MP3-Database can easily be adapted to other MP3 players
Enhancements:
- NEW Data Structure: The MySQL database is much more complex than before. I used 3 Tables for Artists, Albums and Titles to store the data. This ensures that I have no redundancies in the tables. This has also enabled me to store additional fields in the database (for example the date of birth of an artist, or the release year of an album).
- NEW Temporary Database: I added some tables to store all new artists, albums and titles in a temporary database. This enables the user to check the new entries before adding them to the permanent database.
- NEW FEATURES: Additional Artist and Album information can be stored in the database, MP3DB can now create a random playlist and a playlist with the top 20 MP3 titles, MP3DB can show you a statistic how many artists, albums and titles are stored in the database.

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.

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.

GNUstep Database Library 2 (GDL2) is a set of libraries to map Objective-C objects to rows of relational database management systems (RDBMS).
GNUstep Database Library 2 aims to be compatible with Enterprise Objects Framework (EOF) as released with WebObjects 4.5 from Apple Inc.
Main features:
- EOControl (gnustep-db2control)
- The fundamental abstraction library which includes many non RDBMS related extensions such as KeyValueCoding extensions and other categories. Most importantly it contains the classes which handle the coordination of object graphs namely EOEditingContext.
- EOAccess (gnustep-db2)
- This library implements the underlying mechanism to retrieve and store data in RDBMS. It defines the abstract classes like EOAdaptor which are subclassed to interface with concrete RDBMS implementations.
- EOInterface
- This library implements classes used to synchronize UI components such as NSTextFields, NSButtons and NSTableViews with the state of objects which an EOEditingContext contains.
- EOAdaptors
- This is a collection of concrete EOAdaptor projects needed to connect to specific databases. GDL2 currently only supplies an Adaptor for the PostgreSQL database. Even though the Adaptor is still called Postgres95 we aim to support PostgreSQL 7.2 and higher API. In fact the Adaptor may very soon be renamed to PostgreSQL.
- DBModeler

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.

Online Contact Sheet Creator script that generate stylish contact sheets without any fussing around in Photoshop.
You can use the script to generate contact sheets for clients (great for photographers or graphic designers), or you can use it personally for a small photo album.
You can also add Online Contact Sheet Creator to your web site to add some functionality for your visitors.
Main features:
- Online Contact Sheet Creator is easy to install, just a few simple steps and youre done!
- You select the number of images a visitor can upload for their sheet.
- A temporary file system insures that you wont max out your web hosts file size limits.
- The contact sheets look clean and professional, with each photo numbered for easy reference.

This module enables to listen to mp3-streams according to certain security policies (enabled user). The mp3s do not have to be in the web-servers document root.
Main features:
- XHTML compliant.
- Admin interface allows you to change position, visibility and title of the stream playlist Box.
- You dont have to fiddle around with config files. Interface is provided to configure the paths etc., user access and reset the access counter.
- Dynamic directory parsing for mp3-files
- mp3-file names are not held in a database as the File/Directory names are used to create the displayed Songs, album titles etc. as mp3 tags extraction capabilities are not included in php by default.
- Artist, Album, mp3-file browsable
- Playlist handling capabilities with playlist editor
- Demo mode for guests possible, e.g. streaming not enabled.
- Clicking on a Song will send a mpeg-url type information to the mp3-player application such as winamp or xmms. (Tested under linux with xmms only).
Version restrictions:
- The software only searches through 2 Directory structures. It is meant to go through: $mp3dir/Artist-Name/Album-Name/mp3-files.mp3 It however detects files in the Artist-Directory and shows these accordingly. As I didnt use this function, I dont know what it looks like though.