This article is an introduction to the mAirList audio and scheduling database, mAirListDB, and will help you to make the first steps with mAirListDB

mAirListDB (mAirList Database) is the audio and scheduling database built into mAirList. It is made up of three parts:

• Audio Library - keeps a list of your audio files, lets you edit their metadata and organize the audio items in a virtual folder structure.
• Playlist Editor - a place where you can create and edit hourly playlists that are later grabbed by the playout application.
• Mini Scheduler - a music scheduling function built into mAirListDB that allows you to generate hourly playlists based on configurable hour and music templates, or import music from 3rd party schedulers.

mAirListDB is built into mAirList (except Home Player), so you don't have to install any other software. It's designed as an add-on for mAirList though, so mAirList can operate without any database backend, and even when you have a mAirListDB set up, you can still play audio files straight from any Windows folder without adding them to the mAirListDB library or playlist first.

mAirListDB uses an SQL backend to store the library and playlists. There are two kinds of backends available:

• Local database: All data is stored in a single *.mldb file on your local harddisk, using an “embedded” SQL databae called SQLite. The setup is very easy because SQLite is built into mAirList, and you don't have to worry about an SQL server installation. However SQLite will not work well over a network, so this type of installation is only recommended if you use mAirList on a single, standalone computer.
• Networked database: Uses a regular SQL Server, either PostgreSQL (recommended) or Microsoft SQL Server. Setup is more difficult because you have to install the SQL server first, but the network capabilities of these SQL products will allow you to access the database from any number of mAirList computers on your LAN simultaneously.

Note that the SQL database only stores the metadata of the audio items in your library, not the actual audio files - the files will be located in a regular harddisk folder or network share.

Unlike other radio automation products, mAirListDB does not organize your audio files in a cryptic folder structure, or reencodes them to any particular audio format. Instead it works on existing audio folders located on your harddisk or a network share. (Future versions might support additional storage locations such as HTTP servers or cloud services - that's why we use the general term “storage” to refer to your audio folders.)

Once registered as a storage, mAirListDB can synchronize your audio folder: It scans the folder recursively and creates a new data record in its library for all files found. (If you deleted any files since the last sync, it can also delete the data records for that files in the same step.)

Unless explicitly requested, mAirlistDB will never make any write operations on your audio folders (delete, change or copy files). It tries to be as unobtrusive as it gets - it just scans (“synchronizes”) the folders and adds a list of the files to its library, where you can start editing metadata and organize the files in virtual folders.

mAirListDB also doesn't care about the format your file are in. When it scans the folder, it will find all audio files supported by the BASS audio library and any installed BASS add-on. Mixed content is no problem at all. File tags (like ID3 tags) are automatically imported when possible.

So when you're migrating from another radio automation software to mAirList, you can usually just add the existing audio folder as a mAirListDB storage and use it. This makes the migration very easy. (In fact it should be possible to use both products at the same time.) For some third-party automation software, we have also import filters available that import the existing metadata from the third-party database once the files have been sync'd into mAirListDB.

If you plan to start a brand new audio library, we recommend that you set up a network share, say M:\ (UNC paths like \\server\audio will also work), and make separate subfolders for music, jingles and other content:

M:\Music
M:\Jingles
M:\News
...

(For a local mode mAirListDB installation, you could create a folder C:\Audio and then use subfolders like C:\Audio\Music etc. instead.)

Each of these subfolders will then be registered as a storage in mAirListDB and can synchronized with the Library. Inside the subfolders, you can organize the files however you like, e.g. create a subfolder for each artist in the Music folder. mAirListDB will recursively scan each storage during the synchronization process, so it will find the files in any subfolder further down the tree.

However it is very important that you do not rename or move the files around once they have been added to the Library, otherwise the file will show up as missing (under the old name) and new (with the new name) at the same time. (Note: The Sync dialog has a Fix renamed files function to handle this situation, but generally all files should stay in their location and keep their names all the time.)

As mAirListDB is an optional add-on for any mAirList installation, you must set up the database before you can start using it.