tutorials:mairlistdb:getting-started
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
tutorials:mairlistdb:getting-started [2014/10/14 10:25] – [Setup] tw | tutorials:mairlistdb:getting-started [2018/02/03 11:17] – [SQL database] tw | ||
---|---|---|---|
Line 18: | Line 18: | ||
* **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 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 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 // |
tutorials/mairlistdb/getting-started.txt · Last modified: 2021/05/28 13:06 by tw