Babblemind Projects

Music Collection is a small (but not too small) database populated with real data. It is available as an SQLite database and as SQL to populate any database (perhaps with some modification).

Whenever I try out a new framework, library or tool that uses a database, I need some data to run it on and that is why I created Music Collection. The database uses some real artist/album/song data from freedb. I downloaded a few updates to avoid a huge download of the whole database, selected a few artists and wrote a Python parser to create SQL insert statements.

A JPA library is available to allow the database to be used with EJB projects and with tools like my Silk JP/QL browser.

To use the SQLite database you will need to download SQLite from www.sqlite.org or install a package. To use the database with JDBC, downloads the driver from Zentus.

It is very likely that this database will not work with older versions of SQLite, so please make sure you have version 3.