Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Last revisionBoth sides next revision |
| tutorials:mairlistdb:getting-started [2019/07/09 16:18] – external edit 127.0.0.1 | 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), 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. |
| |
