Lead Image © Erwin Wodicka, Fotolia.com
Cross-platform database management with DBeaver
Data Director
Governing and taking care of databases is a specialized task that requires special system administrators who are commonly known as database administrators (DBAs). While their role encompasses all aspects of maintaining data integrity within an organization, some of it overlaps with the duties of a system administrator.
To save yourself time and effort when you are called to administer databases, you can use a graphical database management tool. There's no dearth of such tools, and some databases have their own in-house versions. What sets DBeaver [1] apart is that it works across platforms and supports a wide variety of database servers. Whether you are using relational databases like PostgreSQL and MariaDB, Hadoop-based ones like Apache Hive, graph databases like Neo4j, or even embedded ones like Firebird and SQLite, DBeaver can manage them all, as well as several others (Figure 1). Basically, if your database server has a JDBC driver, you can hook it up with DBeaver.
Figure 1: Besides DBAs, application developers and SQL programmers will find DBeaver useful.
DBeaver comes in two versions: DBeaver Community Edition (CE) and DBeaver Enterprise Edition (EE). The CE version discussed in this article is available under the
...
Buy this article as PDF
(incl. VAT)
Buy ADMIN Magazine
US / Canada
UK / Australia
Related content
- Keep your edge with these powerful Linux administration tools:
-
Five graphical database front ends
Skillfully formulated SQL statements are not everyone's favorite pastime. But graphical front ends can help manage data, so even newcomers will benefit from complex data collections. -
Advantages of data analysis with graph databases
Analyze scattered but related data in real time with a graph database. -
Why databases are moving to the cloud
Demand for cloud databases continues to increase, not only because of better scalability and availability, but because of lower investment and operating costs. We'll look at some of the limitations. -
Vector databases for data-driven artificial intelligence
Artificial intelligence requires special databases that rely on similarity searches for more effective processing of diverse data and embeddings to improve scalability, flexibility, and interpretability.