SolidDB Storage Engine

March 29, 2007

The ATG Creating Commerce Applications course uses the Solid Embedded Engine. So ofcourse when trying to run the Solid Sql scripts in my MySQL database it fails on the following line:

alter table dynamusic_item_bought set pessimistic

This is only natural since this is a typical Solid statement. When googling to see how I can translate this to MySQL syntax I stumble on the SolidDB Storage Engine for MySQL . He this is new! So when I use MySQL with this storage engine will it accept my SQL statement? I have no idea. I am completely in the dark how MySQL and its storage engines actually work. But hey let’s give it a try. Unfortunately there is only a Windows and a Linux version. But somebody on the net compiled the sources for the PowerPC mac and had created a Mac build. Hoorah.

However the following code fails:

CREATE TABLE `Fiets1` (
`id` varchar(11) NOT NULL , PRIMARY KEY (`id`)
) ENGINE=solidDB DEFAULT CHARSET=latin1;

But this one works

CREATE TABLE `Fiets1` (
`id` INTEGER NOT NULL , PRIMARY KEY (`id`)
) ENGINE=solidDB DEFAULT CHARSET=latin1;

It seems that I cannot do a primary key on a varchar. That’s odd.

Next step is to compile the stuff myself. However although I’m perfectly able to compile the MySQL sources from mysql.org on my MacBook, I get a compile error when downloading the linux sources from the solid website. Must be my inexperience. Solid forums.

So now I’m on Parallels for the remainder 😦 ….