| Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision |
| tutorials:mairlistdb:getting-started [2017/09/19 06:30] – [SQL setup] tw | tutorials:mairlistdb:getting-started [2021/05/25 16:11] – [SQL database] ulinobbe |
|---|
| mAirListDB uses an SQL backend to store the library and playlists. There are two kinds of backends available: | 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 [[http://www.sqlite.org|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. | * **Local database**: All data is stored in a single ''*.mldb'' file on your local harddisk, using an "embedded" SQL database called [[http://www.sqlite.org|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 [[http://www.postgresql.org|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. | * **Networked database**: Uses a regular SQL Server, either [[http://www.postgresql.org|PostgreSQL]] (recommended), MySQL 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. | 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. |
| 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.) | 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. | Unless explicitly requested, mAirlistDB will never perform 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. | 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. |
| When you add more files to your audio folder, you can return to the Synchronize dialog at any time and repeat the steps. If you happened to delete files, they will appear in the right-hand side list, and you have the option to remove them from the Library. | When you add more files to your audio folder, you can return to the Synchronize dialog at any time and repeat the steps. If you happened to delete files, they will appear in the right-hand side list, and you have the option to remove them from the Library. |
| |
| | ===== What's Next? ===== |
| |
| | Once you have added your audio files to the library, you can start setting up the scheduler: |
| | [[tutorials:mairlistdb:music-scheduling|Music Scheduling with mAirListDB]] |
