Connecting Sequel Ace to Various Databases
Sequel Ace is a desktop software application for viewing and managing database content and settings. Both local (Docker/Local WP) and remote databases can be connected to help visualize the current state of data.
Helpful Staff for this Topic
Quick Tip!
Be sure to save the connection as a Favorite to avoid having to fill in the connection details each time.
Connecting to a Local Docker database for an Adonis website/API project
After starting Docker and ensuring that a project is running correctly, the database credentials specified in the docker-compose.yml file should be used to initiate a connection in Sequel Ace.
Quick Tip!
To create additional local connections for other projects, duplicate the Favorite and change the credentials.
Connecting to a Remote AWS Database
Digital Corps databases are stored on one of two clusters. One hosts WordPress sites, and another hosts Adonis and non-WP databases. Students should connect to Adonis databases on an as-needed basis to avoid unnecessary security risks. Students needing access to the WordPress databases should talk to a staff member.
The Adonis connection will only work from an on-campus network connection to BSUConnect.
The Adonis cluster is behind SSH authentication, so additional configuration options in Sequel Ace are needed, including the SSH Host, SSH User, and an SSH Key. See a staff for these credentials.
The Key file should be placed in a specific place in the home directory of a laptop: ~/.ssh and should not be shared with anyone outside of the Development Team or staff.
Quick Tip!
Perform as many database operations locally via migrations as possible to avoid needing to work with the live database. If there is starter data in a team member’s local install of a project that needs added to the live site, ask a staff member to upload it instead.
Warning: misuse of Digital Corps database credentials is grounds for immediate termination and could likely result in a hearing with IT staff and University administration.
Access should be treated with utmost seriousness.
