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.

 

Comments

Add Comments

Name:
Comment:

 

About

As someone who has worked on Macs since 1989, I will use my experience to share tips and tricks with you on Fridays. As a Mac user since 1989, I have seen the evolution of Mac software and hardware, and I know how Mac computers work. I also know how to troubleshoot and fix Mac problems that can arise.

Schedule

WednesdaySnagIt for QA
ThursdayPython
FridayMacintosh
SaturdayInternet Tools
SundayOpen Topic
Monday Media Monday
TuesdayQA