XS Labs

In other words, remove the conflict message about UUID existing already, when trying to copy a .vdi file to use with some other machine.

The command is (in virtualbox’s folder in command prompt) VBoxManage internalcommands sethduuid C:\path\to\hd.vdi

The command had been renamed, before the “sethduuid” part was “setvdiuuid” so I decided to make this post so perhaps others might benefit from not having to figure out the command’s name change themselves.

Sadly (at least the current version) MySQL does not support “rename database” clause anymore, because it’s “unsafe”.

Here’s how to do it manually:

Issue

create database “newdatabase”;

Then for every table in your old database

rename table `olddatabase`.`tablename` to `newdatabase`.`tablename`;

Yeah I know it’s manual labor, but “show tables” query and a text editor with macro support makes it a bit easier. :)

.. does not work with the latest binary version (0.2.1) from Sourceforge, but I compiled the DLL with Visual Studio 2008 SP1 (needs to be SP1 for the regex library) and it works.

If anybody’s interested, I attached the DLL here.

Notepad++ QuickText-compiled-by-xs.fi

How’d you feel like typing $Users->Select(“UserName”)->Where(“UserStatus = ‘active’”)->OrderBy(“UserID”, “DESC”)->Columnn(); to get ["foo","bar","baz",..] ?

Started the PHP project at http://code.google.com/p/fantastisql/

It is actually a spin-off of my xsLib project, a PHP framework for doing things super-quick. Why spin-off? To get FantastiSQL lifted off quickly. xsLib is still in early stages of development.

SVN read-only access with command

svn checkout http://fantastisql.googlecode.com/svn/ fantastisql-read-only

Documentation will be available online later, when the API settles down

Source available at http://code.google.com/p/fantastisql/source/browse/src

Releases will be available at http://code.google.com/p/fantastisql/downloads/list