Database setup

Supysonic needs a database to run. It can either be a SQLite, MySQL-compatible or PostgreSQL database.

If you absolutely have no clue about databases, you can go with SQLite as it doesn’t need any setup other than specifying a path for the database in the configuration.

Note

SQLite, while being a viable option, isn’t recommended for large installations. First of all its performance might start to decrease as the size of your library grows. But most importantly if you have a lot of users reaching the instance at the same time you will start to see the performance drop, or even errors.

Please refer to the documentation of the DBMS you’ve chosen on how to create a database. Once it has a database, Supysonic will automatically create the tables it needs and keep the schema up-to-date.

The PostgreSQL case

If you want to use PostgreSQL you’ll have to add the citext extension to the database once created. This can be done when connected to the database as the superuser. How to connect as a superuser might change depending on your PostgreSQL installation (this is not the same thing as the OS superuser known as root on Linux systems).

On a Debian-based system you can connect as a superuser by invoking psql while being logged in as the postgres user. The following commands will install the citext extension on the database named supysonic assuming you are currently logged as root.

# su - postgres
$ psql supysonic
supysonic=# CREATE EXTENSION citext;