User Tools

Site Tools


tutorials:mairlistdb:getting-started

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
tutorials:mairlistdb:getting-started [2018/02/13 18:03] twtutorials: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 ''*.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), 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.   * **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.
  
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 ''M:\'' (UNC paths like ''<nowiki>\\server\audio</nowiki>'' will also work), and use subfolders for music, jingles and other content:+If you plan to start a brand new audio library, we recommend that you set up a network share, say ''M:\'' (UNC paths like ''<nowiki>\\server\audio</nowiki>'' will also work), and create directories for music, jingles and other content:
  
   M:\Music   M:\Music
Line 44: Line 44:
   ...   ...
      
-(For a local mode mAirListDB installation, you could create a folder ''C:\Audio'' and then use subfolders like ''C:\Audio\Music'' etc. instead.)+(For a local mode mAirListDB installation, you could create a directory ''C:\Audio'' and then use subdirectories 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.+Each of these directories will then be registered as a storage in mAirListDB and can synchronized with the Library. Inside the directories, you can organize the files however you like, e.g. create a subdirectories for each artist in the ''Music'' directory. mAirListDB will recursively scan each storage during the synchronization process, so it will find the files in any subdirectory 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.) 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.)
tutorials/mairlistdb/getting-started.1518545025.txt.gz · Last modified: 2019/07/09 16:19 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki