Forward Engineering with ERD
In our previous article, we talked about two ways how to use diagrams with DBeaver. But ERD can be used not only to view and navigate through data but also to directly make changes to the database.
Two ways to use ERD in DBeaver
An Entity Relationship (ER) Diagram is a type of flowchart that illustrates how entities relate to each other within a system. In terms of a database management system, an entity is a table. So by showing relationships among tables, the ER diagram represents the complete logical structure of a database.
Import Data with DBeaver
Our readers are already familiar with Louis, who not only uses DBeaver for his work but also uses it for his favorite hobby. He has a website where he regularly publishes information about films, and he stores all the necessary data in a database. Louis realized one day that it was not only he but also his readers who were interested in information about popular TV series.
Visualize data with DBeaver
DBeaver supports a large number of databases with different purposes. Relational databases remain the most common databases our users constantly work with, and our app offers a wide range of features for working with the data stored in them. For your convenience, we have added the ability to visualize data to our PRO versions as one more way to work with data.
Keep calm and use Connection types
In our previous article, we talked about transactions and how they work in DBeaver. When you are in the development and testing phase of your project, there is usually no need to keep track of transactions. But if we are talking about a production system, we need stricter control over reading and editing data. Therefore, DBeaver has Connection types that allow you to track transactions only when you need to.
Change the data in the smart way
If you work with databases, it is highly likely that you have already used transactions even if you weren’t aware of it. Let’s talk about what transactions are and how they work in DBeaver.
Think about the content, not about the structure
Our hero Louis, who you would have read about in one of our previous articles, has a new hobby. As he is quite fond of going to the cinema, he has created his own website with information about movies. Louis stores movie titles and descriptions, cast lists, and other information in a database and updates it regularly. And with DBeaver, he can easily keep his site up-to-date.
How to organize your connections
When you just start working with DBeaver and create the first few connections to different databases, you will have no problems with organizing your navigation tree. But what if you are working on multiple projects with dozens of scripts and diagrams? In this case, your navigation tree starts looking messy. To organize it, you can use Projects in DBeaver.
Build your report step by step
Let’s take a look at a small company that manufactures and sells merch all over the world using its own online shop. The boss asked his assistant Louis to reward regular customers by sending them gifts. To get a list of the mailing addresses, he needs to select the desired group of customers.
How can he do all of this with DBeaver?
