Astrosorting Music Organization Database
(AMODB)

Welcome to the official home page of the Astrosorting Music Organization Database (AMODB), which I wrote in mainly PHP with much smaller amounts of MySQL, and a dash of JavaScript. It is free, open source, public domain software.

Basically, if allows you to easily search your music collection for songs matching lots of different criteria, as well as instantly create a Winamp playlist and/or web page (with local links to the song files on your hard drive, or web links to their location on the internet) out of the results. It also stores the URLs of musicians and bands you like.

You can either input search queries in the simple custom search engine querying language (which I pretentiously call AMODBQL - for AMODB Query Language), or, if you want to do something really complicated or not yet possible in AMODBQL, you can use your own SQL queries.

Some of the search criteria include: the file name, the file extension (MP3, MID, or whatever), the folder on your hard drive it's in, the title of the song, the genre, the length of the song, various attributes (such as whether it has vocals, male or female singing, dangerous volume levels, etc., or not), what album or video game a song is from, who performed, remixed, composed, and/or sang it.

And, you can search for songs based on what astrosorting labels you've assigned to a song, and optionally, the strength ratings you've assigned to those labels. (You can go here for a description of my astrosorting system of music organization).

It can also output files exactly like my Astrosorted Music List and page of Musician Links.


The Astrosorting Music Organization Database (AMODB) isn't software which is limited to any particular standard computer platform (like Windows, MacOS, or Linux) - the interface can be accessed by any common web browser. You just need some web server software to run on your own computer - or you could even conceivably upload the AMODB to a web server, though it's not designed for use over the web or by more than one person.

To develop and use it, I've been using the Windows version of xampp, an easily-installed distribution of the Apache web server software, bundled with PHP, Perl, MySQL, and other stuff, which is available for Linux, MacOS, Windows, and Solaris. I've provided some instructions on how to hopefully get that running, at least on Windows.

For more details, see the Readme file. The Readme file is also included in the AMODB's zip file.


Last modified: May 16, 2008
This page uploaded to web: Apr. 4, 2008