Sqlyog 5.1 Beta 1

[peterlaursen]

Now that Ritesh released SQLyog 5.1 BETA 1 then

I) let me point your attention to four new FAQs:

http://webyog.com/faq/8_94_en.html

http://webyog.com/faq/8_93_en.html

http://webyog.com/faq/8_92_en.html

http://webyog.com/faq/34_95_en.html

II) also you may read this if 'auto-complete is somewhat a mystery for you!

A brief introduction to the 'autocomplete' feature of SQLyog Enterprise 5.1 (Beta1).

======================================================

Autocomplete functions in four different ways. They all have the purpose to make it ease to type (database object) names, keywords and functions. The features makes use of the SQLite database engine that is compiled into SQLyog Enterprise 5.1. A SQLite database consists of a single file. There are two kinds of these files as of SQLyog 5.1.

1) The keywords.db file in SQLyog Installation folder comes packed with the installer package and is written there by the installer script.

2) In the TAGS-folder in the SQLyog Installation folder tree you will find a .db -file for each connection that has been opened since SQLyog 5.1 was installed. It contains the names of (all sorts of) database objects available with each individual connection. SQLyog builds this file first time the connection is opened and rebuilds/verifies it every next time it is opened. If you have connections with a lot of databases – each with a lot of tables and columns – you may have to wait a little first time you open a connection. All depending on the 'power' of your PC.

Now the four functionalities:

1) Auto-popup. Whenever you type in an object name followed by “.” the available object in the level below will pop up in a small window from where you can select using arrow-keys and ENTER. For instance try typing a database name like “mydb.” to see the list of tables in the 'mydb'-database. And type a “mytable.” and a list of colums in that table is displayed. Also typing the name of a function followed by “(” will display the parameter list of that function. Try typing “ABS(” yourself!

2) TAB-key functionality. Try higlighting a database in Object Browser and type in a single or a few characters in the editor pane. For each time you press the TAB key autocomplete will switch between all possible inputs starting with this/these character(s). These inputs are functions, keywords and database objects from the selected database as well.

3) CTRL+SPACE functionality. As above type in a single or a few character(s) in the editor pane. Press CTRL+SPACE and a small window opens with a list of keywords and functions starting with this/these character(s). Cursor must be placed in editor window. Use arrow-keys to select one, press ENTER and the selected one is inserted.

4) CTRL+ENTER functionality. When cursor is placed in the editor pane pressing CTRL+ENTER allways opens a small window with a list of ALL keywords and functions. As above use arrow-keys to select one, press ENTER and the selected one is inserted.

Autocomplete is included in SQLyog Enterprise only. It can be turned off in 'preferences'.

********************************************

enjoy!

[peterlaursen]

Two more FAQs:

http://www.webyog.com/faq/8_99_en.html

http://www.webyog.com/faq/29_100_en.html

[peterlaursen]

One more:

http://www.webyog.com/faq/24_101_en.html

[peterlaursen]

I have now written-up quite a lot of our FAQs to reflect the changes with SQLyog 5.1.x.

Please drop a note if I overlooked something that must also be rewritten!

[Author]

Posts