If you open any connection in your navigation tree of DBeaver Enterprise or DBeaver Ultimate, you will see a list of folders containing various database objects. But in the Lite version, only your database tables are displayed there. Why so?
In one of our previous blog posts, we talked about what opportunities DBeaver provides to financial analysts. Data Editor features may come in handy not only for them but also for other specialists working with large amounts of data. Today we will tell you about one of these features, it allows you to colorize certain values in your table.
The Data Editor is one of the most powerful and useful DBeaver tools for most of our users. It allows you to view and edit data and metadata, visualize data, generate result sets for reporting, and much more.
This year we have started a partnership with EDB, the biggest commercial provider of PostgreSQL and a major contributor to this database. They are the longest players in the industry and cooperate with the largest companies in the US.
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.
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.
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.
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.
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.
