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.
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.
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.
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.
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?
Today, databases do not store only strings and numbers, as it used to be. You can use your database for different data types, including images, spatial data, and even data structures such as JSON. If the text value is easy to edit right in the table cell, working with more complex data types can be difficult. Today we will talk about how DBeaver’s Value Panel solves this problem.
Sometimes company employees need to access the files stored in the AWS. It is possible to do this with the AWS console. But for security reasons, the admin can not provide the necessary credentials for this. Today we will tell you how to solve this issue with the S3 browser, one of the most important DBeaver Ultimate tools.
SQL Editor is a powerful tool for creating and executing various SQL scripts. Today we are going to tell you about its main features.
Employees of companies that keep their infrastructure, partly or completely, in AWS, face a number of issues and challenges related to this. Let’s talk about the most important ones.
