DbVisualizer vs. Spyder

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
DbVisualizer
Score 7.7 out of 10
N/A
DbVisualizer is a multi-database tool for developers, analysts and database administrators, providing a single interface across a wide variety of operating systems. Boasting an easy-to-use and clean interface, DbVisualizer runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
$0
per user
Spyder
Score 8.7 out of 10
N/A
Spyder is a free and open source scientific environment for Python. It combines advanced editing, analysis, debugging, and profiling, with data exploration, interactive execution, deep inspection, and visualization capabilities. Spyder is sponsored by open source supporters QuanSight, and NumFOCUS, as well as individual donors.
$0
per month
Pricing
DbVisualizerSpyder
Editions & Modules
DbVisualizer Free
$0
per user
DbVisualizer Pro with Basic support - Renewal
$69
per user
DbVisualizer Pro with Premium support - Renewal
$99
per user
DbVisualizer Pro with Basic support
$197
per user
DbVisualizer Pro with Premium support
$229
per user
No answers on this topic
Offerings
Pricing Offerings
DbVisualizerSpyder
Free Trial
YesNo
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup Fee$197 per userNo setup fee
Additional DetailsNew license cost includes a perpetual license, software upgrades and support for the length of the term. 1, 2 & 3 year terms are offered. Once license expires the user may access all Pro versions released before the license expiry indefinitely. To gain access to Pro versions released after the license expired, license renewal is offered. Renewal cost starts at USD 69. Volume discounts apply to both new and renewal licenses.
More Pricing Information
Features
DbVisualizerSpyder
Database Development
Comparison of Database Development features of Product A and Product B
DbVisualizer
7.7
29 Ratings
10% below category average
Spyder
-
Ratings
Performance optimization tools7.125 Ratings00 Ratings
Schema maintenance8.328 Ratings00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
DbVisualizer
8.3
18 Ratings
2% below category average
Spyder
-
Ratings
User management8.217 Ratings00 Ratings
Database security8.415 Ratings00 Ratings
Database status reporting8.214 Ratings00 Ratings
Best Alternatives
DbVisualizerSpyder
Small Businesses
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 8.9 out of 10
Medium-sized Companies
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 8.9 out of 10
Enterprises
DBeaver
DBeaver
Score 8.4 out of 10
PyCharm
PyCharm
Score 8.9 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
DbVisualizerSpyder
Likelihood to Recommend
8.7
(31 ratings)
9.9
(6 ratings)
Likelihood to Renew
10.0
(1 ratings)
-
(0 ratings)
Usability
9.0
(1 ratings)
-
(0 ratings)
Support Rating
-
(0 ratings)
8.0
(2 ratings)
User Testimonials
DbVisualizerSpyder
Likelihood to Recommend
DbVis Software AB
Whenever you have to access data sources from more than one database engine provider, you should consider using DbVisualizer for the task. Switching between multiples IDE consumes time and resources (memory), and you also need to learn menus, shortcuts, etc., for each IDE, while using DbVisualizer allows you to work consistently no matter which database engine you are connecting. You can use it to simply navigate through data structures, write SQL sentences or even create new tables and views, develop stored procedures, etc.
Read full review
Open Source
Spyder is an open-source Python IDE designed for the movement of data science work. Spyder comes with an Anaconda package manager distribution, so depending on your setup you may have installed it on your machine.
Spyder includes most of the "standard IDE" features you can expect, such as a strong syntax code editor, Python code rendering, and an integrated text browser.
Spyder is used when we want to develop a code that is useful and able to explore proper documentation of the code that has been written. We use Spyder to perform data-related operations like filtration, cleaning, and enhancing the data qualities. There some cases where it is less appropriate like working in an environment, creating dashboards of data visualizations and plots.
Read full review
Pros
DbVis Software AB
  • Timed queries that add their result to the result grid for every execution are helpful. Creation of graphs also extremely helpful.
  • Query history and auto-recover feature makes sure we don't lose our queries.
  • Actions like exporting grids to Excel or other tools is a very easy task.
Read full review
Open Source
  • Debugging of your existing code
  • Generates figures very quickly as part of a figures tab which lets users understand results quickly
  • Different layouts are available for the software which will give the users freedom to decide what layout works best for them
Read full review
Cons
DbVis Software AB
  • does not handle lost connections well (specially after stopping a running query) (mysql). eg. after hitting stop, and then hitting run again, it can sometimes look like its running the query, but it isn't actually!
  • filtering on databases window is clunky (why the need for filtering certain object types at a time? just filter everything, google style)
  • altering table, adding columns (NOT to the end of the table's columns, but earlier) is not supported (mysql) even though the db supports it (alter table add column BEFORE..)
Read full review
Open Source
  • Colors in code format
  • Add a broadcast to share the project with friends
  • Contains more than one important language such as Python
Read full review
Likelihood to Renew
DbVis Software AB
We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.
Read full review
Open Source
No answers on this topic
Usability
DbVis Software AB
Menus are simple and well organized. You can use the same shortcuts no matter which database engine you are connecting to. Configuration of data source connections is simple while keeping all required options.
Read full review
Open Source
No answers on this topic
Support Rating
DbVis Software AB
No answers on this topic
Open Source
Most of data scientists or data engineers are either using ec2 on the cloud or Atom or PyCharm locally. It is a bit hard to find people who are still using Spyder and have the sight of the IDE and can help you to answer your question.
Read full review
Alternatives Considered
DbVis Software AB
DbVisualizer provides a good value when compared against other 3rd party products with similar features as well as products with similar functionality made by the database vendors. The user interface is good and user friendly / intuitive and easy to learn. It doesn't take too long for an experienced DBA / database developer to come up to speed.
Read full review
Open Source
I think Spyder doesn't stack up as well as other IDEs due to its many limitations. But it is available for free and that is one advantage it has over its competitors
Read full review
Return on Investment
DbVis Software AB
  • The institution is of the governmental type, therefore we do not measure the commercial impact of using this tool
  • The impact on the benefit of the population is always positive with tools that streamline our processes, and DbVisualizer is one of the best
Read full review
Open Source
  • Easy to use.
  • Quick switch from R.
  • Hard to manage env.
Read full review
ScreenShots

DbVisualizer Screenshots

Screenshot of Screenshot of SQL formattingScreenshot of ERD diagramScreenshot of Auto completeScreenshot of Database connectionScreenshot of Database connection