When comparing DbVisualizer vs OmniDB, the Slant community recommends OmniDB for most people. In the question“What are the best GUI tools for PostgreSQL on Windows?” OmniDB is ranked 6th while DbVisualizer is ranked 10th. The most important reason people chose OmniDB is:
OmniDB is open-source and in active development.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Duplicate row button
Makes it really easy to stub out example data while developing, just change the values with unique constraints and you have extra data ready to go
Pro Wildcard finder
Has a search box that will highlight any matching row, regardless of what field is matched (spans multiple columns)
Pro In-line editing
Allows you to edit and save db rows through a spread-sheet like edior
Pro Open source and actively developed
OmniDB is open-source and in active development.
Pro Web-based, can be run locally or deployed on server
OmniDB is web-based and works similarly to pgAdmin 4. You can run the web server locally or deploy it on a server, and connect to it through a web browser.
Pro OmniDB has 2ndQuadrant as its main sponsor
Cons
Con Expensive
License for the full product is costly.
Con Not mature software
While OmniDB is actively developed and maintained, it currently doesn't offer common features found in other database clients. It currently supports only PostgreSQL, but has plans to support others (SQLite, MySQL, MariaDB, Oracle, etc.)