DbVisualizer vs. Spyder

Well suited for medium size to large Oracle system that includes a large and complex database schema with many database objects including functions and triggers. Also well suited for a medium size to large Microsoft SQL Server system with many complex database objects. Its SQL editor and query builder are well suited in developing complex SQL queries.

Spyder is well suited if you're limited on hardware. You have to work with single code file. You need to quickly write some code and test it. Apart from this if you want to have a look at your variables then you can make use of Spyder. If you're working with Anaconda navigator then this can be the best to start with as it can be installed with single click there.

Incentivized

• Provides simple access to all tables, indexes, views, triggers, stored procedures, etc., to just about every database on the market
• Allows me to develop and run queries in a simple, easy to read and understand manner
• Allows me to create entire new schemas as well as alter existing schemas
• Gives me access to databases without the need to install specific drivers for any particular database

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

I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.

It is fairly straightforward to use. Pretty much good to go as soon as you install it. The IDE itself is very user friendly, and it is only limited by whatever limitations Python has as a language. Great for those who want to run their scripts quickly or do some Python programming without fussing.

Incentivized

Never used

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] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.

Incentivized

I have chosen Spyder because it's free and open-source that comes with properly documented comments in the code. I have been using Spyder for more than 2 years and it always feels good to work with Spyder every time start my work. In Spyder, we have three windows one for man code window, idle window, and the other is for running your code and analyze. So to test a particular code I use the idle window to see what is going to be the result when I use this set of codes. That the main reason, I use Spyder.

• The only point I could potentially give is hours saved by having so many warehouses hooked up in one place vs. having to manage connection string changes/password updates across multiple applications... maybe 10% decrease in time spent managing connections? Mind you, I've had everything hooked up on DbVis for close to 6 years so it's hard to remember the "before times"

• Less time spent on employee training.
• Limited integration with Git.
• No tools for repository.

Incentivized