DEV Community

Jem
Jem

Posted on

Dev tools for databases, what is out there?

I've been spending a lot of my time this month thinking about databases and dev tooling. What's out there in this space? How do you know you're getting the best performance or security out of your database?

Top comments (5)

Collapse
 
llagerlof profile image
Lawrence Lagerlof

Well, I strongly recommend DBeaver, a powerful opensource database GUI tool. In the past I already used mysql workbench, heidisql, sqlyog, navicat, toad and oracle sql developer. Finally I found the wonderful DBeaver and stick with it because it has the most useful features, it's compatible with many database engines and has constant updates.

Collapse
 
jem profile image
Jem

I'll check it out, thanks for the list too. I guess there's lots of tools with a wide range of focus.

Collapse
 
bobbyiliev profile image
Bobby Iliev • Edited

In case that you are using MySQL, there is a cool Perl script called mysqltuner. It allows you to quickly test your MySQL configuration and it gives you suggestions for adjustments to increase performance and stability.

For more information you could take a look at this answer here:

How to optimize MySQL

Collapse
 
jem profile image
Jem

I haven't used MySQL for a while, but I'll go check it out 😁

Collapse
 
jem profile image
Jem

I've just been browsing the #sql tag and found this wonderful story of a SQL linter for VSCode: dev.to/ronsoak/doing-the-impossibl...