Services/SQL

From DcUsers
Revision as of 06:38, 8 April 2020 by Duck (talk | contribs)
Service 'SQL'
Description SQL Databases, for websites and various applications.
Prerequisite None
Account Global (registration required) IPv6 Ready Yes
Security Notes Access to the databases is secure.


Access

Command Line Interface

PostgreSQL

You need a client CLI tool to connect to the database. On Debian you can install it easily using:

apt-get install postgresql-client

You can login to the following nodes:

  • db-postgresql-1.duckcorp.org

To learn how to use this tool, please look at the [1].

MariaDB (MySQL-compatible)

You need a client CLI tool to connect to the database. On Debian you can install it easily using:

apt-get install mariadb-client

(on older systems you can install the _mysql-client_ package instead)

You can login to the following nodes:

  • db-mysql-1.duckcorp.org
mysql -u <user> <database>

To learn how to use this tool, please look at the documentation.

Web SQL Manager

Each database can be accessed and managed using a (simpler) web interface: https://db.duckcorp.org/

User Accounts

User Accounts are handy to manage your databases. This is handy to prepare and alter schema, repair problems, and do operations the application accounts are not allowed to do.

You need to ask an administrator to create your account.

PostgreSQL

You can connect using your LDAP credentials.

MariaDB (MySQL-compatible)

You need separate credentials to log into your account. We plan to add LDAP support.

Application Accounts & Databases

To ensure security each project of one or more related database will use a specific account to connect. You need to ask an administrator to create application accounts.

It is recommended, if the application support it, to restrict the application account permissions on the database; for example to disallow modification of the database schema. These operations are only meant for migrations and maintenance and should be done using your user account, or a dedicated administration application account.

Technical Details

This service is made using: