Today, SCO announces MySQL Network for SCO OpenServer 6 at the National Retail Federation event in New York. The announcement is also on the MySQL Partner Site.

The news of this announcement, beyond the September 2005 SCO partnership press release, is that the porting to OpenServer 6 has now been completed, and thus SCO will begin reselling MySQL Network through their partner channel to their customers as planned in Sep 2005.

We got some questions on the nature of the deal between MySQL AB and SCO back then, and I might as well answer some PAQ (”Presumably Asked Questions”) in advance.

• Although SCO will be offering our commercial MySQL Network subscriptions to their customers, the deal also has allowed us to offer a community edition of MySQL 5.0 for …

I picked this up in a market in Stockholm.

It’s sitting on top of a diagram of a bunch of classes in ndb_mgmd and in front of The Art of Computer Progromming (Knuth, Volumes 1-3). On top of that is Transactional Information Systems.

Release 5.1 of MySQL comes with a new event scheduler, this is great news and further moves the MySQL database away from just a data store, something which began with the introduction of Stored Procedures and Triggers in 5.0.

The event scheduler will allow you to run an SQL command at a specific time, this is great for maintenance purposes. It's possible to run the command a single time or set up and interval and run it multiple times. What's also great is that you can use DDL, DML and even compound statements which allows SQL/PSM syntax to handle processing as part of the command.

I'll admit to not having downloading and installing 5.1 as yet but this is definitely something I'll be using. As an Oracle user I've been using Oracle's version DBMS_JOB for a while and this looks to be as good, if not better due to the easy method of adding events.

Having said all this often in Oracle I have often preferred …

I have just been trying to get all the info about myself on one page so I can have it as a record and use it to create a master resume of my self.

Why do I need to go through this excruciating process? Because I consider myself very competent when it comes to a variety of technologies and because I am looking for work since my business partner stabbed me in the back by getting a job right when the business needed him most.

To give you a oneliner about myself :)

Me = DBA + Systems Administrator + Automation Expert + Graphics Designer + Accountant + Strategic Manager + a good guy

If you have nothing better to do in life at the moment, you can bore yourself by reading it on my personal blog at http://mashraqi.com/. So far, among other things, includes a cover letter that I prepared for Google but never …

Every so often you come across people desiring intense XML and RDBMS interaction. Recently, here: Technical Notes and Articles of Interest » MySQL 5.1 is gaining some momentum.

In MySQL land, this usually means “An XML Storage Engine would be great”. hrmm… a storage engine is a way to store a table. A table is a relational thingy. Surely what’s wanted is a good way to query an XML document and search for a specific XML document.

So, is what’s really wanted good XML indexers and the ability to extract parts (or the whole) of a document? Maybe there’s some extension to fulltext (along with some funky functions) that could bring an immense amount of power with dealing with XML?

What is there now? What do people do now? What do they want to do?

All interesting stuff

ticketmaster.com.au - The White Stripes

Damn, damn, damn, damn damn. Only January 28th - and I’m in NZ.

Note to future organisers: make sure dates don’t overlap BDO or any really cool band tour dates.

Of course, the real disaster would be if Tool were touring at the same time as a work thing. How will people take it if i leave a company event for however long is needed to see Tool live. as many times as possible. I am dearly hoping that travel co-ordinates itself to see them in different cities, countries. Heck, even another planet if we can do that by the time the new album is ready :)

Some people don’t seem to get the Tool thing. It’s just good music. But that’s the …

The first Free and Open Source Conference ("FrOSCon") takes place on June, 24th and 25th 2006 in Sankt Augustin, near Bonn, Germany.

Organized by a commited team, it aims to become a significant event for free software in the Rhineland. The conference is hosted by the faculty of Computer Science of the University of Applied Sciences Bonn-Rhein-Sieg in collaboration with the student body and the …

The first Free and Open Source Conference ("FrOSCon") takes place on June, 24th and 25th 2006 in Sankt Augustin, near Bonn, Germany.

Organized by a commited team, it aims to become a significant event for free software in the Rhineland. The conference is hosted by the faculty of Computer Science of the University of Applied Sciences Bonn-Rhein-Sieg in collaboration with the student body and the Linux/Unix User Group Sankt Augustin.

In a Call for Papers, the organizers ask for submission of contributions. A broad variety of topics concerning free and open …

It wasn’t that long ago that MySQL released the GA Release of Version 5.0 with major new features (Oct 24 2005). It still took 5.0 about a year to go from alpha to GA, however I’d suspect a much shorter turnaround this time.

Version 5.1 is already at alpha, and the largest public functionality mentioned has been Partitioning. It is also anticipated that Storage Engines (a very handy MySQL feature in comparison to other RDBS products), will be a hot-pluggable API instead of a source re-compilation. Now I’ve never even looked at the Storage Engine code, but it’s been talked about a few …

In a recent job interview I was asked the question regarding Unit Testing/Automated Testing of a Database? An interesting question and indeed an interesting problem. I thought it was a good topic to describe what I’ve done in the past, and where I would go for a more complete testing environment given the opportunity of a entire XP project.

This is the approach I have implemented successfully in the past. It’s not a complete solution, however at the time with the client it provided appropriate coverage.

I don’t use a framework such as dbUnit to load data via XML, or specifically test data. XML is ugly to store data, and also with maintenance and comparison. I start with a pre-configured database of representative sample data, refer to my notes later on this, and then I use the tests of the application to perform the necessary data …