MODEL ONE SALE — SAVE $300!
Stock is Limited — Order Soon!

Database Administration

Commandline and GUI

Use command-line and GUI tools to administer MySQL and PostGres databases.

Please read the disclaimer before proceeding. This solution is updated regularly. Please write authorship with suggestions or requests.

CLI - MySQL

Use the official MySQL client, mysql, or consider mycli which provides auto-complete and syntax highlighting. Install the latter by using sudo apt install mycli. It has Vim and Emacs modes, but may be slower in some situations.

CLI - PostGRES

Use official postgres client psql, or consider pgcli which provides auto-complete and syntax highlighting. Install the latter by using sudo apt install pgcli. It has Vim and Emacs modes, but may be slower in some situations.

GUI - DataGrip

A JetBrains IDE such as PyCharm, IntelliJ, and Webstorm include the DataGrip suite of database tools. The visualization and design capabilities are impressive.

Troubleshooting

Content will be added as needed.

Revisions

This is a partial revision history. See the git repository for all entries.

Disclaimer

We try hard to provide a useful solution validated by professionals. However, we cannot anticipate every situation, and therefore cannot guarantee this procedure will work for your needs. Always backup your data and test the solution to determine the correct procedure for you.

THIS SOLUTION IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS “AS IS” AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOLUTION, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

Follow us on Twitter
Like us on FaceBook
Watch us on YouTube
Connect at LinkedIn