Services/SQL: Difference between revisions
mNo edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{Template:Service |
{{Template:Service |
||
| description = SQL Databases, for websites and various applications. |
| description = SQL Databases, for websites and various applications. |
||
| prerequisite = |
| prerequisite = none |
||
| account = global-reg |
| account = global-reg |
||
| ipv6 = true |
| ipv6 = true |
||
Revision as of 09:04, 8 April 2020
| 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:
