tutorials:mairlistdb:getting-started
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
tutorials:mairlistdb:getting-started [2015/03/12 10:42] – [Audio folders] tw | tutorials:mairlistdb:getting-started [2021/05/28 13:06] (current) – [Audio folders] tw | ||
---|---|---|---|
Line 17: | Line 17: | ||
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 '' | + | * **Local database**: All data is stored in a single '' |
- | * **Networked database**: Uses a regular SQL Server, either [[http:// | + | * **Networked database**: Uses a regular SQL Server, either [[http:// |
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. | ||
Line 29: | Line 29: | ||
Once registered as a storage, mAirListDB can '' | Once registered as a storage, mAirListDB can '' | ||
- | 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 (" | + | Unless explicitly requested, mAirlistDB will never perform |
mAirListDB also doesn' | mAirListDB also doesn' | ||
Line 37: | Line 37: | ||
=== Recommended folder layout for new libraries === | === Recommended folder layout for new libraries === | ||
- | If you plan to start a brand new audio library, we recommend that you set up a network share, say '' | + | If you plan to start a brand new audio library, we recommend that you set up a network share, say '' |
M:\Music | M:\Music | ||
Line 44: | Line 44: | ||
... | ... | ||
| | ||
- | (For a local mode mAirListDB installation, | + | (For a local mode mAirListDB installation, |
- | Each of these subfolders | + | Each of these directories |
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.) | 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.) | ||
Line 60: | Line 60: | ||
* [[setup-sqlite|SQLite backend setup (local mode)]] | * [[setup-sqlite|SQLite backend setup (local mode)]] | ||
* [[setup-postgresql|PostgreSQL backend setup (networked)]] | * [[setup-postgresql|PostgreSQL backend setup (networked)]] | ||
- | * Microsoft SQL Server backend setup - no tutorial available at the moment, but similar to PostgreSQL | + | * [[setup-mssql|Microsoft SQL Server backend |
+ | * [[setup-mysql|MySQL server backend setup (networked)]] | ||
Once the SQL backend is set up, and the database connection has been added to mAirList, you will be able to run the // | Once the SQL backend is set up, and the database connection has been added to mAirList, you will be able to run the // | ||
Line 94: | Line 95: | ||
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: |
tutorials/mairlistdb/getting-started.1426156950.txt.gz · Last modified: 2019/07/09 16:19 (external edit)