Set Up a Local Database

Set Up a Local Database

There are plenty of ways to set up a database for local development. You can use Docker containers, install locally using Homebrew or other tools, and various other GUI tools.

My option of choice is DBngin. It is a simple tool that lets you add databases quickly for whatever you need including MySQL, Postgres, and even Redis.

DBngin Services

I am going to create a MySQL database.

Create a MySQL database in DBngin

...and it is just that simple! Now just start the new database and DBngin will take care of the rest!

Running service from DBngin

DBngin also happens to be made by the company behind my favorite database GUI tool, TablePlus. If you use TablePlus, you can click on the arrow next to the "Start/Stop" button and open the database right in TablePlus.

TablePlus

From there, it is easy to create databases, and tables, and set up users.

Creating tables and databases in TablePlus

A future post can go into more MySQL or TablePlus usage, but if you want to dive deeper into MySQL, I cannot recommend the MySQL for Developers course on Planetscale by Aaron Francis enough. It is a fantastic resource and even if you have been using MySQL for a while, I am sure there will still be something to learn!

I know this was a simple post, but hopefully, others getting started in their careers can find it helpful.

Did you find this article valuable?

Support Sean Kegel by becoming a sponsor. Any amount is appreciated!