This is an old revision of the document!
Table of Contents
mAirListDB Networked SQL Connection Setup
This tutorial shows how to set up the connection to an SQL server and initialize an empty mAirListDB database on that server.
This article only covers the “true” (networked) SQL backends: PostgreSQL, MSSQL, MySQL. For the “local mode” database (SQlite), setup instructions are available in a separate tutorial.
Server Setup
You must prepare your SQL server for use with mAirListDB first. In particular we will need:
- An empty database (no tables created yet!)
- A user + password to access that database, with sufficient credentials (often the owner of the database)
Setup instructions are very similar for each SQL server type, but we have separate tutorials available for that:
Please set up the server first according to your particular SQL flavor, then return to this article to see instructions for the client setup. In this tutorial we will use PostgreSQL as an example.