dbForge Studio is provided by
Devart and is a universal front-end client for database
management, administration and development. Devart's GUI tool provides
utilities to compare, synchronize, and back up databases (e.g. MySQL, Oracle, SQL Server, PostgreSQL, etc.) with scheduling,
and includes the possibility to analyze and report MySQL tables data. For example, dbForge
Studio for MySQL works with any MariaDB database servers, and supports all
MariaDB objects types. This solution enables users…
$9.95
per month
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.
This tool is useful for small and large IT departments and associated data analysts that perform direct database functions such as DBA tasks or extracting/importing data. Non-technical staff members would not benefit from this tool as much as the functions are detailed and technical. However, automation engineers will find this tool very open for automation, and can generate the scripting code for any of its functions.
IDLE is a good option to run small scripts directly on the console, and that's it. It is a good exit when you don't want or need to open a proper IDE like Pycharm.
The ability to parameterize searches more would be advantageous. For example, being able to specify to only look for certain columns, certain data type changes, etc.
The output reports from dbForge are very plain and could contain more detail, and perhaps be structured more like a pivot table form Excel
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.
Although experience here is limited, as only one question has been asked and answered promptly, the registration and licensing process was very smooth and professional. There are forums online that discuss dbForge issues, as well as a Facts and Questions section on dbForge's website, so product support does seem to exist if needed.
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.
Before choosing dbForge Studio I evaluated at least a dozen tools, especially on the Visual Query Builder function. For now, I have identified only one product that has a better Visual Query Builder than dbForge Studio. This other product also manages UNIONs, while dbStudio still doesn't do it visually. However, the better alternative product is enormously slower in operations and less feature-rich than DbForge Studio
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
