Original: Taste of Little Sister (wechat official ID: XjjDog), welcome to share, please reserve the source.

I recently installed DBeaver because so many people love it. Boy, it works. But from the first glance I opened it, I knew it was developed in Java, because every time I added a database type, I needed to download a corresponding JAR package.

Good good, no more worrying about whether Navicat is pirated or not, and no more installing PL/SQL that can crash the system.

DBeaver has benefited from Java, JDBC, and is inherently cross-platform. DBeaver also provides a plug-in for Eclipse, providing sideways proof that its GUI was developed using Eclipse.

This caught me, once a skeptic of Java GUI development, off guard.

Welcome to star: github.com/xjjdog/bcma… . It includes ToB complex business, Internet high concurrency business, cache applications; DDD, microservices guidance. Model driven, data driven. Understand the evolution of large-scale services, coding skills, Learning Linux, performance tuning. Docker/ K8S power, monitoring, log collection, middleware learning. Front-end technology, back-end practices, etc. Main technology: SpringBoot+JPA+Mybatis-plus+Antd+Vue3.

What can it do?

So what’s so great about this tool? The first is that it supports very rich databases.

When creating a new link, we can see the whole picture from this interface. In addition to the usual MySQL, there are all kinds of databases you’ve never seen or heard of. I stared into my pretty eyes and counted, 86 in all! Of course, there will be more giveaways for the commercial edition.

No merit, also have hard work! Major software manufacturers are playing this way, regardless of what it needs, first to the bowl.

But DBeaver has pulled a clever trick. If you want to use a database, you need to download its JDBC driver. With the driver, it will have a small motor connected to the database. For example, here is a screenshot of the Oracle database driver download.

Download driver to network, so this tool, for some early nine to five play LAN companies, is not to play. Drivers must also be correct, because some database drivers are not as post-compatible. The absence of certain features can affect normal operation. I don’t need to remind you of the obvious.

Specific functions, and other database management software is about the same. We have everything we need.

  • Database management
  • Table design
  • Data browsing
  • Query window, etc.

It’s very interesting when you focus on a library. In the right window, tabs like the ER diagram appear.

This feature is lame, because the images it generates are so ugly that I’m embarrassed to take screenshots. So just have fun, the most common is still SQL Windows, SQL editor.

In fact, DBeaver supports Redis, but only the commercial version. It is also helpful to influence MongoDB, Cassandra, and InfluxDB. Think about it. It’s just a drive adaptation job.

Why do you need database management software

But why development now, need a handy SQL management software? I have something to say about the reasons for this.

SQL is a great invention.

I am not making up such a stark conclusion. At present, both big data and NoSQL have to compromise SQL and provide their own version of SQL, such as Hive, and then such as ES.

But SQL is also the root of all evil for programmers.

If you run a perverted company that uses MySQL, Oracle, or even SQL Server, according to official guidelines, you need to install three clients. In addition to looking different, each company’s clients also behave differently in SQL. For example, paging, which is limit in MySQL, is rownum in Oracle.

This artificial increase in barriers, we call it business, we call it a moat. But for practitioners, it’s a disservice.

Learn how to write MySQL SQL, or even stored procedures, and don’t assume you can play Oracle. A database DSL, in fact, has to do some development language stuff in it, so today’s programmer practitioners, rather than being called experts, are better known as trackers.

DBeaver is able to unify SQL and NoSQL at the tool view level and even give NoSQL users a way to spend their money, which is a good thing. But in any case, the problems it addresses are superficial. At present, no single enterprise can unify the chaotic status quo of SQL, each vendor is trying to twist their arms to expand their SQL, trying to sell users almost never use things.

Anyway, congratulations to DBeaver, coming out and slowly replacing Navicat, Datagrip.

PS: I recently found a tutorial on how to use DBeaver on wechat. I’m wondering if you have to learn DBeaver, are you sure you can handle SQL? You just need to be able to download it.

Welcome to star: github.com/xjjdog/bcma… . It includes ToB complex business, Internet high concurrency business, cache applications; DDD, microservices guidance. Model driven, data driven. Understand the evolution of large-scale services, coding skills, Learning Linux, performance tuning. Docker/ K8S power, monitoring, log collection, middleware learning. Front-end technology, back-end practices, etc. Main technology: SpringBoot+JPA+Mybatis-plus+Antd+Vue3.

Xjjdog is a public account that doesn’t allow programmers to get sidetracked. Focus on infrastructure and Linux. Ten years architecture, ten billion daily flow, and you discuss the world of high concurrency, give you a different taste. My personal wechat xjjdog0, welcome to add friends, further communication.