SolidDB Storage Engine

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 😦 ….

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: