I have been working for more than four years, and I have been dealing with countless databases. Especially when I was working on an enterprise-level application system, I spent the whole day on business, data, and Program The data is queried. On average, around 40% of the time is spent on manual SQL writing for data query every day. At the beginning, it seems quite good to query data through the command line tool provided by the database. At least a lot of functions are provided. You can obtain all the information related to the database through commands, however, developers often use the function of writing SQL statements to query, update, delete, and insert data, especially in enterprise-level application development. SQL statements are relatively complex and large in quantity, to improve development efficiency, a visual database client tool is necessary. Of course, some arrogant prawns may sneer at such tools, but the fact that an excellent database client tool can improve development efficiency cannot be erased, therefore, we recommend that developers use such tools frequently.
After so many years of development, many database client tools have been used, which are very professional, commercial, and open-source for free. I can't say which tool is good or not, because everyone's usage habits and needs are different. Today I will introduce a tool that I think is more useful: coolsql.
Coolsql is an open-source database viewing and management tool. This tool is mainly used for data query and analysis. It also provides some management functions, and coolsql is more operable. This is also the main reason why I chose this tool. Next I will show you the functions and features of this tool.
The coolsql interface is a view (similar to the eclipse view concept). It consists of a bookmarkdoning view, an SQL editing view, an execution result view, and a log view, I also introduce coolsql functions in the unit of view:
1. bookmarks view: In coolsql, Bookmarks can be understood as a database, which is actually a database ing. After each bookmarks are connected to the database, the object structure of the database is displayed in a tree structure. As shown in Figure1:
Different types of nodes in the database tree structure provide rich functions. The most typical feature is that table nodes provide a menu for common data viewing functions.
2. SQL editing view: this view has obvious functions, mainly for SQL editing and viewing. The SQL Editor provides functions not available in many other similar tools. In addition to the basic functions such as copy, paste, undo, redo, and search, SQL keyword highlighting is also a basic function. I also summarized some other good functions:
- Select columns (press the Alt key ).
- Select the SQL statement at the current cursor position (identified by ";" by default), and provide a shortcut key (F3 selected SQL, F4 executed selected ).
- Displays the row number.
- Adjust the case sensitivity of the selected text.
- Supports row/block annotations.
- Supports SQL formatting.
- Supports script execution.
- Supports non-automatic SQL commit (NON-AUTOCOMMIT)
- Highlight different types of keywords (commands, system functions, text values, values, comments ).
- Provides the data information prompt (Alt + /).
- Positioning and tracking of database object (press Ctrl and move the mouse) to directly locate the node in the database structure tree.
- Allows you to view historical SQL statements.
- The SQL favorites function is provided to facilitate quick acquisition and execution of common SQL statements.
- Export the data of the query type SQL directly.
3. Result Display view: this view is mainly used to display the execution results of SQL commands (including query, update, delete, and insert). This view also provides some special features:
- The query results are displayed by PAGE (the speed is very fast, mainly limiting the upper limit of the retrieved data), and all viewing functions are also provided.
- The SQL Execution time and the number of affected data items (the SQL Execution result of the modified type) are displayed.
- The display result of the query type. If you only view the data of an object, you can directly edit the value on the table component. Whether the query type result can be editable can be determined by the icon color in the lower left corner of the view.
- For direct data editing, this view provides a very friendly operation interface and safer information prompts.
- In addition, another Visual update structure is provided (I personally think this function is not necessary ).
In addition, there is a function that is very practical and powerful. We strongly recommend it here:Visualized addition of database Entity Data. This function is displayed in a new window. It can be triggered directly in the result set view, or directly on the table/view node in the database structure tree of the bookmarks view. Its features are as follows:
- Table data can be copied and pasted intelligently. (You can try it yourself. I personally think it is good ).
- Checks the validity of field data (highlighted ).
- Supports continuous drag of Field Values (a bit like excel, move the cursor to the bottom right corner of the selected table, it will become a cross shape, and then drag ), this function provides great convenience for developers and testers to create data.
- Supports SQL preview and export.
- Supports batch setting of table values.
4. log view: displays logs, including SQL Execution results and invalid operation error messages. In addition, log information is displayed by level (similar to log4j). You can customize the log display level.
I have finished introducing the views provided by coolsql. However, I would like to summarize other features of coolsql:
- Supports plug-in extension. sqlscript is a plug-in.
- Coolsql can run on an operating system platform that provides a Java Runtime Environment.
- All mainstream databases are supported.
- It provides a variety of appearances, of course, if you want better performance, it is recommended to use metal (metallic texture) appearance.
I just talked about some of its features from a big perspective, and I have done a lot of detail. I hope this will be helpful to developers and testers.
By the way, I almost forgot about coolsql:
Http://sourceforge.net/projects/coolsql/files/coolsql/CoolSQL%200.9.5%28RC2%29/
