What program to choose to work with databases?

Question

MySQL

Hello!!! Please advise a powerful program for working with databases so that it is possible to compare changes and see what changes have been made in the tables so that everything is clear. Thank you all for your attention! =)

Answer 1

db ForgeStudio for MySQL
For more clarity, the author compares some features with Workbench. Studio for MySQL is a powerful integrated development environment (IDE) for MySQL from an industry leader known for its database development tools. In this article, we will discuss some of its features that may be useful for database developers, analysts, database administrators, or architects. General features
Access to a wide range of flavors MySQL
Studio for MySQL is compatible with a wide range of MySQL features, storage systems and connection protocols. Besides the open source MySQL core, it can connect to, Amazon Aurora for MySQL, Google Cloud MySQL, and Server, to name a few.
Interface
The Studio user interface has a modern, intuitive look and feel. Hidden panels, open toolbars, and context-sensitive menus make navigating the tool quite easy.
Those who are used to working with Visual Studio will feel right at home with the default interface. But there are other skins to change the UI theme.
Command Line Automation
One really nice feature is that most of the actions in the user interface can be exported to an operating system command.
Most dialog boxes have a button that says "Save Command Line...". This allows you to export the dialog box action as an operating system command. The options you select in the dialog box become the options for the command. It can help users automate regular database tasks from their desktop.
For Database Developers
Code snippets
A good development environment should help developers save time and automate tasks as much as possible. When it comes to development productivity, for MySQL offers some of the standard features such as code completion, syntax checking, code formatting, or code snippets. Here are some examples of code completion and code snippets:
Object dependencies
Objects such as tables or views can be checked for their relationship with other objects in the database. This can be done by selecting the "Depends On" or "Used" folders from the object tree. Dependencies are shown recursively. This can be very handy when troubleshooting or debugging code.
Generator
Another good feature of this tool is the generator. Right-clicking on a table and selecting from the context menu will create a template for four stored procedures. Each procedure will be executed for the main operation (SELECT, INSERT, UPDATE, DELETE).
Schematic Comparison Tool
Most database client tools will offer schema comparison and synchronization features. is no exception. The intuitive user interface makes it easy to find and reconcile schema differences.
Debugging Tools
The debugger is another great feature for developers. The debugger wizard requires the debug engine to be deployed to the MySQL server and create the _debug database. This database contains all the procedures, functions, and tables needed to debug user code.
Deploying the debugging engine requires the user to have process administrator rights, and we have found that this feature does not work with MySQL at Amazon because it does not allow access to the server.
For systems that allow a debugging mechanism to be deployed, MySQL developers can run their stored procedures with the "Compile for debugging" option. It inserts custom debug code into a procedure by calling routines from the _debug database.
This added code allows developers to step through code instead of using custom debug messages. To keep things simple, no debug code is displayed when a procedure or function is loaded in the editor.
Once the code is ready, developers can easily remove debug information with a few clicks.
For Data Analyst Data
Comparison Tool
Like the schema comparison tool, for MySQL has a data comparison tool that should be useful for data analysts and developers. It has an intuitive interface for comparing and reconciling data between two tables.
Data import and export
Studio for MySQL can connect to ten different types of data sources to import and export data. Notable types are Google Sheets, XML, or even ODBC connections.
With this utility, the author was able to copy several hundred Excel sheets in no time. The author then successfully imported the JSON document. These features significantly accelerated the author's work on a database transfer and backup order from a small Moscow construction company.
Compared to, the MySQL Workbench Table Data Import Wizard can only import CSV or JSON.
Master-detail
browser The Master-detail browser is a great tool for viewing data relationships. Analysts can use this tool to quickly check different categories of master data and their child records.
Pivot Table
The Pivot Table function can be used to aggregate, group, sort, and filter data. For example, the original table might look like this (the author uses the database as a reference).
With a few clicks, the rotate feature allows us to split or collapse the rental income figure.
Making report
Not too many enterprise-class query tools have built-in reporting. Studio for MySQL comes with a great report designer.
Users can create reports either by selecting one or more tables or by using their own custom queries. When the wizard completes, the report will open in a WYSIWYG editor for further customization. Once it is ready, it can be saved in Data Report (.) format.
For the
DBA DBAs will find most of the tools they use for day to day management of MySQL databases similar between and MySQL Workbench. This includes:
- User Management ("Security Manager" in, "Users and Privileges" in MySQL Workbench)
- Table maintenance (analyze, optimize, validate, validate, restore)
- Current instance connections
- System variables and states
Similarly, a database is backed up by right-clicking on it, and selecting "Backup and Restore > Database Backup" data..." from the pop-up menu. creates an SQL dump file for the database. Restoring the database is also easy.
It should be mentioned that the author could not find the server log file viewer in Studio for MySQL, although it is readily available in MySQL Workbench. With Amazon MySQL, log files are not available with any of these client tools.
Copying databases
Copying databases from one instance to another is an intuitive and easy process using Studio. All the user has to do is select the source and target instances, select the databases to copy to the source and any additional options if needed, and then click the little green arrow.
Moreover, databases can be copied between different MySQL flavors: the author was able to successfully copy a MySQL database to an instance.
For data architects Database
diagrams
Reverse engineering the structure of an existing database is often part of the job of a data architect, and Studio for MySQL makes the process easy. Tables from the database tree can be dragged and dropped into the database diagram and it will automatically create a beautiful diagram as shown below:
Database
Document databases.
A full blown professional system architecture document can be created with just a few clicks. The documentation will describe tables and views, indexes, column data types, constraints, and dependencies, along with SQL scripts for creating objects. Documentation can be created in HTML, PDF or .
Data Generator
Finally, a feature that database architects and developers would like to use is the Data Generator tool. Database design often requires meaningful dummy data for rapid proof of concept, load testing, or customer demos. offers a turnkey solution for this.
Using the Intuitive Data Generator Wizard, you can quickly populate an empty MySQL database schema. The generator maintains foreign key relationships during data loading, although foreign keys and triggers can be disabled if desired.
The tool can create a data generator script and load it into an SQL editor, save it as a file, or run it directly against the database.
Conclusions
In general, the author believes that - a good product, in fact, a very good product - that deserves at least some serious attention from the programming community.
Well, a link to the product itself, if anyone is interested in this tool, it can also be downloaded in the free version https://www.devart.com/free-products.html

Answer 2

Usually this is not the case in databases. But the program that the database serves can keep its own logs - logs - in a format that is convenient for you, which you program.

Answer 3

Please advise a powerful program for working with databases so that it is possible to compare changes and see what changes have been made in the tables so that everything is clear.

There is no such program. If you need to look at changelogs, you need to write your own application for working with data, or learn how to work with logs and generate binlogs for mysql. But it won't be clear.

Answer 4

MySQL Workbench