DBeaver, Just Build the Dam Thing

When building an application’s backend I have had some struggles in visualizing the data and being sure of relationships between data models. I have been using Postman to make requests to the database and it has worked well up to this point, but what I found difficult was checking the relationships created by join tables, when a teammate suggested DBeaver. I am not an expert, and this is not a tutorial, I just hope someone else can benefit from this tool!

Here is the magic of DBeaver!

All of our data models will have an ER diagram so you can SEE how they relate to one another! From here you can easily access the models and make changes to columns and data types.

The program has a ton of great features as well for creating and modifying our database. We can do it with plain old SQL statements, or they have a GUI that allows for the same manipulations without having to write out the SQL statements. Here is the interface for creating a table.

DBeaver is a nifty tool, we can build and visualize VERY quickly, and hooking it up to our database is a snap. It also works well with Postgres, which tends to be a bit finicky with these kinds of applications. If you haven't used DBeaver you should definitely give it a try!