Free mp3 database software for linux

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.

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.

Gnome/Mono application to copy mp3 files to mp3 player

Stereo is a GTK/mono application for copying MP3 files (either from a 3mu type playlist or database search onto an MP3 player than can be seen by Linux as a USB hard drive.

This is the initial alpha release - 0.0.1.

Cactus is just an audio file player. But it has some features that makes it different from other players.
There are music databases and there are players like xmms with a small and leightweight, skinable GUI.
Cactus combines these two types in one player! With Cactus you can read your music collection into a database, create a playlist by browsing/searching it and finally switch to player view(F2-Key).
Main features:
- Plattform independent
- Browse your music collection by artist, albums and titles
- Tiny lightweight player combined with a powerful database for organizing mp3-files
- Save and Load m3u Playlists
- Supports ID3v1(read/write) and ID3v2(read)
- Easy tagging of mp3-files
Enhancements:
- Some bugs concerning the playlist/tag-editing now fixed...

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.

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

MP3 Jukebox-Tk is an organizer/jukebox for local mp3 collections. MP3 Jukebox-Tk sorts your mp3 files by band and presents a jukebox style interface to let you choose which ones to play.

It then passes these off to XMMS for playing. It also keeps stats on what you listen to, and can use those stats to generate a weighted random playlist for you. Non-weighted (truly random) playlists are also available.

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.