DbVisualizer

Name: DbVisualizer
Price: 197.00 $
Rating: 4.5714 (5 reviews)

Version 14.0.3

Follow this app Developer website

Download (188.4 MB)

$197.00

Subscription

Buy Now

DbVisualizer overview

DbVisualizer is a feature-rich, intuitive, cross-platform database tool for developers and DBA's providing a single powerful interface for a variety of databases. DbVisualizer supports simultaneous database connections; it lets you explore and manage database objects, execute SQL queries, visualize information, and a lot more. Free of charge for commercial and non-commercial use. This edition provides basic level features useful for most users.

DbVisualizer comes in Free and Pro editions. You can find the differences here . The price quoted in the listing is the starting price for the Pro edition.

What’s new in version 14.0.3

Updated on Feb 02 2023

Improvements:

DB Support: Cassandra, DDL Generator - Extend DDL generation to support table options in Cassandra
DB Support: Exasol - Add support for virtual schema and clusters in Exasol
DB Support: MariaDB, DB Support: MySQL - Added support for sub-millisecond precision in TIME columns in MySQL and MariaDB
DB Support: Microsoft Access - Add "Export Tables" and "Export Views" actions for Microsoft Access
Driver Manager - Require a restart after updating a driver that contains a dynamic library
Installation/Update Installation, OS Support: Windows, Theme: FlatLaf - Deliver FlatLaf dll files separately to avoid security issues on Windows

Bugs Fixed:

Compare - Fix sync and multiline replace in the text comparison dialog
Connection Setup - Do not ask for master password upon reconnect if there is at least one open connection
DB Support: Cassandra - Potential error when generating DDL for old Cassandra versions
DB Support: Greenplum, DB Support: PostgreSQL, DDL Generator - Index name in CREATE INDEX should not contain schema
DB Support: MariaDB, DB Support: MySQL - Backticks can be used as delimiters in the DEFINER clause of CREATE TRIGGER
DB Support: MariaDB, DB Support: MySQL, Export - Table name in CREATE TRIGGER statements should not include schema
DB Support: SQL Server - Current database's SQL formatter should be used in scripting actions
DB Support: SQLite, DDL Generator - Improve handling of foreign key constraints in CREATE TABLE for SQLite
Data tab - Exception while visiting the Data tab when disconnected
Export - @export should generate CREATE and SELECT statements also for empty result sets when the corresponding flags are set. There should be no statement separators in generated code after SQL blocks (e.g. CREATE FUNCTION blocks). Exclude computed columns from insert statements when exporting tables in SQL Server
SSH - Create .ssh/known_hosts automatically if it doesn't exist

Information

License

Shareware

Size

188.4 MB

Developer’s website

https://www.dbvis.com/

Downloads

27220

App requirements

Intel 64
OS X 10.11 or later
Version for Apple Silicon

0.0

(0 Reviews of )

There are no reviews yet

jmrx

Sep 10 2013

9.1

4.5

Version: 9.1

I've been using DbVisualizer since 2006 and have been a happy customer ever since. Updates appear on a regular basis and customer support is quick and helpful. Yes, the program is written in Java and it does not look 100% native. But still it looks and feels great. I have seen native Cocoa Apps which feel sluggish and unpolished in comparison. The SQL editor is fast and comes with syntax highlighting, auto-completion and all sorts of (configurable!) keyboard shortcuts. It is lacking a vi-mode though. What makes DbVisualizer really shine is its graphing feature. Similar products can create visualizations of a database schema as well, but only DbVisualizer produces a layout that does not look like a knot of spaghetti. DbVisualizer is an excellent product for a very reasonable price.

Bobthevisitor

Mar 5 2013

9.0.5

Version: 9.0.5

This is a really professional tool to query every possible database accessible by JDBC. I use it daily and professionally and albeit the UI is not Mac-like (Java) it's power features are hard to find anywhere else. Import and Export is highy configurable, syntax highlighting and completion as you would expect. I use it mainly for Informix, Oracle and MySQL Databases without any problems so far (started with version 7 and currently 8) - I highly recommend taking a look at it. Well worth the money if you are a pro.

Mutant

Feb 15 2010

7.0.2

Version: 7.0.2

Draconian install, very un-userfriendly. First thing that pops up is a "buy me" dialog. It's listed as free, so I assume it's for support only. SQLite access didn't work. mysql over ssh worked fine, would be nice to have a httptunnel, but I won't complain. postgresql worked, MSSql seemed to work fine. In all however, I didn't see the use in this over a dedicated tool like phpMyAdmin, Mysql studio, or MSSQL Studio. This brought nothing more to the table than an interface to type in sql commands and view data. No typeahead hints, no autotable completion, nothing special in any way. I suppose it's a decent way to keep all your databases in one spot, but without even an SSH tunnel manager, it's more work to create the connections than to manage the tool.

barefeettom

Apr 19 2008

6.0.10

3.0

Version: 6.0.10

Here's a detailed comparison of DbVisualizer with alternative SQLite GUI programs: http://www.tandb.com.au/sqlite/compare/

Mar 12 2008

6.0.8

Version: 6.0.8

DB Visualizer seems to be the most full featured SQL GUI tool out there. It has some data entry aids that really make it viable, such as automatic form view (on record per screen), adjustable grid views and filters for everything from table listing to rows of data. Some of the tools and options aren't immediately obvious but very impressive once you find them. It's a Java app which limits a lot of Mac OS X integration (eg all the windows move in Spaces together) and some controls (such as tabbed panes) don't work in the standard Mac way. It's "Mac Look and Feel" setting makes DbVisualizer more palatable than most Java apps, but it's still a bit ugly and non-intuitive for Mac users. DbVisualizer, uses JBDC drivers to connect to the database. That takes a bit of fiddling which would scare off most users. I've tried two available JDBC drivers with SQLite (the most prolific database on the Mac) and only get limited functionality. For instance, I can't get DbVisualizer to show me the source of a selected table or view, I can't see triggers in the list. Every time I make changes to data, DbVisualizer complains that "no rows were affected by this edit", but the changes were actually made. Overall it's a great program that I can't yet use until SQLite access is fixed.