Thanks to the plug-plug SQuirreL SQL Client (www.squirrelsql.org) supports a variety of databases (Oracle, MySQL, PostgreSQL, IBM DB2 - all over 20). Actually to get started you must select the appropriate driver (plugin) and create a so-called alias - set the settings for connecting to the server. But the most important chip in the fact that the squirrel client written in Java and thus perfect start to any platform: as a Wind, and Linux and macos. However, universality - it is not the only horse. In addition to a nice spreadsheet, in prog implemented several visual tools with which, for example, we can construct a graph showing the relationship between the tables. Very high quality made and query editor in the arsenal of which there are syntax highlighting, and a built-in IntelliSense (just press press Ctrl + Space to autocomplete table names or teams) to accelerate the process of writing queries. To quickly view a list of all available options, just press Ctrl + t. Moreover, the editor supports templates.For example, if too lazy to dial a handle designs such as CREATE TABLE or INSERT VALUES, you can use the corresponding snippet. You just press Ctrl + j in the list that appears, select some interesting design. If the built-in templates is not enough, then nothing prevents the user to make their own. By analogy with office suites editor supports syntax checking and abbreviations. If the script write "SF", then the program will offer to replace it on "SELECT * FROM", "FORM" will replace "FROM", etc.
0 Comments:
Post a Comment