Services/SQL
From DcUsers
| 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/
Technical Details
This service is made using:
- [PostgreSQL https://www.postgresql.org/]
- [MariaDB https://mariadb.org/]
