QA Graphic

DBeaver

All in one Database tool

The past few months I have been doing a lot of database work. I was looking for a good application that I could use that wasn't limited on the type of database. I was recommend DBeaver - the free Universal Database tool.

DBeaver Logo

Five Reasons Why I Like DBeaver

  1. Database Support - The application pretty much supports any database you need: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto and more. (A total of 89 different database connections are available out of the box!)
  2. SQL Generation - You can easily moved text between tables. Simply select a bunch of rows, right-click and select "Generate SQL." You'll get a copy of the SQL statements as insert statements. Useful when you want to delete a row and reinsert it again to test triggers.
  3. In Grid Editing - Easily change data in the grid - just like excel. DBeaver makes it so much easier to manipulate the data. Once you make all the changes, simply commit it.
  4. SQL Views - Very easy to create/modify views. In one of my projects, I didn't use many database views. When using DBeaver, it was easy to create and modify SQL views.
  5. SQL Scripts - Create and Save SQL Scripts for various projects. Makes it very easy to reuse past queries. You can even search through SQL Scripts for code - making it a great resource to reuse SQL commands.

 

About

A Mac veteran since 1989, I'm here to share my experience with tips and tricks every Friday. Witnessing the evolution of Mac software and hardware firsthand, I've gained a deep understanding of how these machines work and can help you troubleshoot any issues that may come up.

Schedule

FridayMacintosh
SaturdayInternet Tools
SundayOpen Topic
Monday Media Monday
TuesdayQA
WednesdayKeyboard Maestro
ThursdayGluten Free