DbVisualizer vs. Python IDLE

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
DbVisualizer
Score 8.2 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
Python IDLE
Score 8.7 out of 10
N/A
Python's IDLE is the integrated development environment (IDE) and learning platform for Python, presented as a basic and simple IDE appropriate for learners in educational settings.
$0
Pricing
DbVisualizerPython IDLE
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
DbVisualizerPython IDLE
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
DbVisualizerPython IDLE
Database Development
Comparison of Database Development features of Product A and Product B
DbVisualizer
7.8
40 Ratings
9% below category average
Python IDLE
-
Ratings
Performance optimization tools7.535 Ratings00 Ratings
Schema maintenance8.138 Ratings00 Ratings
Database Administration
Comparison of Database Administration features of Product A and Product B
DbVisualizer
7.6
28 Ratings
11% below category average
Python IDLE
-
Ratings
User management7.925 Ratings00 Ratings
Database security7.722 Ratings00 Ratings
Database status reporting7.221 Ratings00 Ratings
Best Alternatives
DbVisualizerPython IDLE
Small Businesses
DBeaver
DBeaver
Score 8.9 out of 10
PyCharm
PyCharm
Score 9.0 out of 10
Medium-sized Companies
DBeaver
DBeaver
Score 8.9 out of 10
PyCharm
PyCharm
Score 9.0 out of 10
Enterprises
DBeaver
DBeaver
Score 8.9 out of 10
PyCharm
PyCharm
Score 9.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
DbVisualizerPython IDLE
Likelihood to Recommend
8.8
(47 ratings)
2.1
(7 ratings)
Likelihood to Renew
9.1
(2 ratings)
-
(0 ratings)
Usability
8.2
(17 ratings)
8.2
(2 ratings)
Support Rating
9.1
(1 ratings)
8.0
(1 ratings)
Implementation Rating
9.1
(1 ratings)
-
(0 ratings)
User Testimonials
DbVisualizerPython IDLE
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
Python Software Foundation
Scenarios where python IDLE is well suited 1-Quick scripting and prototyping 2-Education and training 3-small projects utilities 4-exploring python libraries and modules Scenarios where python is less appropriate 1 large scale projects 2 complex debugging and profiling 3 multi language development 4 Advanced code analysis and inspection
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
Python Software Foundation
  • Firstly, I would say Python IDLE interface is user friendly.
  • Easy to learn for the beginners.
  • Syntax highlighting is nice features.
  • Smart indent helps a lot.
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
Python Software Foundation
  • Too simplistic
  • Could not find source revision management integration support
  • Only basic debugging is available
  • Does not have data-science-specific notebooks (but can be installed separately)
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
Python Software Foundation
No answers on this topic
Usability
DbVis Software AB
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.
Read full review
Python Software Foundation
The IDE Python IDLE is a good place to start as it helps you become familiar with the way Python works and understand its syntax.
This IDE allows you to configure the environment, font, size, colors, .....
It also looks like any simple text editor for any operating system, I work with Windows or Linux interchangeably, and you don't have to learn to use the IDE before programming.
Once the IDE is executed you can start programming directly in it.
Read full review
Support Rating
DbVis Software AB
Never used
Read full review
Python Software Foundation
Python IDLE support is what the community can give you. As it is free software, it does not have support provided by the manufacturer or by third-parties.
In any case, for most of the problems that normal users can find, the solution, or alternatives, can be found quickly online.
As this IDE is made in Python, the support is the same group of Python developers.
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
Python Software Foundation
It's easy to set up and run quick analysis in Python IDLE on my local machine. The output is direct and easy to read. But sometimes I prefer Jupyter Notebook when the datasets are large, since it would take too long to run on my local machine. It is easier to run Jupyter Notebook on my cloud desktop
Read full review
Return on Investment
DbVis Software AB
  • Positive: Real time saver when working across multiple databases. At least 30-40 mins a day are saved
  • Positive: Helpful for the 'quick DBA' tasks without switching to the native tools: approx 1-2 hours saved weekly
  • Positive: Easy switch between environments / schemas / etc without hassle: saved at least an hour daily
Read full review
Python Software Foundation
  • In a short time, we were able to develop several ML models for various teams to make accurate decisions.
  • Beginners can easily understand and adapt to GUI.
  • We could automate several manual validation tasks and so could reduce human intervention.
Read full review
ScreenShots

DbVisualizer Screenshots

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