DbVisualizer vs. Spyder

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.

Incentivized

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.

• 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.

Incentivized

• 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

Incentivized

• 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..)

Incentivized

• Colors in code format
• Add a broadcast to share the project with friends
• Contains more than one important language such as Python

We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.

Incentivized

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.

Incentivized

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.

Incentivized

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.

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

Incentivized

• 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

Incentivized

• Easy to use.
• Quick switch from R.
• Hard to manage env.

Incentivized