Thursday, May 26, 2011

SQLyog hide Query Builder and Schema Designer

When you open a new connection in SQLyog, you by default automatically get 3 tabs, the Query tab (to enter queries), Query Builder, and Schema Designer.
To prevent the Query Builder and Schema Designer tabs from opening every time you can disable them in the sqlyog.ini file.

The file can be found under C:\Users\<your username>\AppData\Roaming\SQLyog or similar in other Windows OSes. Find the lines called DefaultQueryBuilder and DefaultSchemaDesigner and change their values from 1 to 0.

SQLyog should now only open the Query tab.

(The tabs can easily be added by pressing Ctrl + K or Ctrl + Alt + D respectively or from the Powertools menu).

Wednesday, May 18, 2011

Thunderbird Ctrl+F open Quick Filter not Find in message

In Thunderbird, if you have selected a message so that it's shown below your message list (not double click to open in separate tab), pressing Ctrl + F won't give you a find box for the message. Instead, it will open the Quick Filter bar which lets you search for messages.

To get a search bar where you can search within the message text press Ctrl + F twice(!) OR press Ctrl + G.

Note: shortcut to hide the bars is escape, once for each bar.

Solution source: http://groups.google.com/group/mozilla.feedback.thunderbird/browse_thread/thread/877e7351d9bd51fd
And
http://kb.mozillazine.org/Make_Thunderbird_3.1_look_like_Thunderbird_2

Sunday, May 1, 2011

Ruby on Rails missing sqlite3.dll

I was following the official guide at http://guides.rubyonrails.org/getting_started.html on how to set up Ruby on Rails. At step 3.4 Configuring a Database I got the following error message:
"The program can't start because sqlite3.dll is missing from your computer. Try reinstalling the program to fix this problem."

After quite a lot of googling I found that the problem was that the sqlite3 gem
(installed with the bundle install in step 3.3 I believe) didn't include windows DLL. This is probably because "most Ruby developers use Linux".

The solution is to download the DLL from the official SQLite website http://www.sqlite.org/download.html. You want the "This ZIP archive contains a DLL for the SQLite library" file. At the time of writing it is the following file: http://www.sqlite.org/sqlite-dll-win32-x86-3070600.zip
Put the files from the ZIP file into your ruby/bin directory. Close and open a new console window and continue with the Ruby on Rails guide.