Object Relationship Mapping (ORM) is probably the best things that happened to enterprise software development since the invention of the Lego brick in 1949. Implementing the database access through ORM allows you to access the account data of a customer through the class 'Account' (with pure Java code), rather than having to mix SQL code in your Java classes. A framework does the job of translating your Java code to SQL statements and executing them though a JDBC connection.

ORM adoption has faced (and still does) a lot of resistance from the IT industry in general, but even more with enterprise software. Can't blame them: database access is a very common bottleneck for software that has intense use of data. Would you give away your fine tuned SQL scripts in favor of some 'magic bullet' that will automatically write that SQL for you at run-time?

It certainly does not help that many ORM frameworks did not work, or were simply not …

Object Relationship Mapping (ORM) is probably the best things that happened to enterprise software development since the invention of the Lego brick in 1949. Implementing the database access through ORM allows you to access the account data of a customer through the class 'Account' (with pure Java code), rather than having to mix SQL code in your Java classes. A framework does the job of translating your Java code to SQL statements and executing them though a JDBC connection.

ORM adoption has faced (and still does) a lot of resistance from the IT industry in general, but even more with enterprise software. Can't blame them: database access is a very common bottleneck for software that has intense use of data. Would you give away your fine tuned SQL scripts in favor of some 'magic bullet' that will automatically write that SQL for you at run-time?

It certainly does not help that many ORM frameworks did not work, or were simply not …

If you use mondrian's parent-child hierarchies, you will know that performance sucks unless you create closure tables. Closure tables expand the hierarchy, and allow mondrian to the operations required to roll-up a parent-child hierarchy using raw SQL: really fast.

The problem is populating the things. Closure tables contain what computer science profs. call a transitive closure of the parent-child relation (hence their name), and transitive closures aren't something which relational databases are very good at computing (which is why the database performs so much better when they're around). You can't just define a view, or write a simple SQL statement to populate them. Up til now, you'd have to use a stored procedure (if your database supports them) …

Skoll is a Community-Based Testing project out of the University of Maryland. Their first testing framework comes for MySQL. Watch Sandro Fouché, graduate researcher on this project, take you through what Skoll is, how it's beneficial, and how you can use it with an actual demo.

The Skoll testing client for MySQL can be downloaded here:
http://www.cs.umd.edu/projects/skoll/contribute/

Unless you've been coding under a blogosphere rock  you've heard that NCover has now gone commercial.  NCover has become a staple in many developer toolboxes.  I can understand this move.  People are so busy today that it's becoming increasingly hard to get people to contribute time to a good open source project.  And even fewer contribute money.  Unless you are functionally wealthy (read: actually wealthy or a nothing-better-to-do college kid), finding the time to significantly push projects forward can be daunting.

So the guys behind NCover and NCoverExplorer have banded together and formed a new organization named Gnoso.  Their first product is NCover 2.0 (now up to 2.0.1) and is available in x32 professional and x64 enterprise editions.

While the prices of these two products are fair, I …

Microsoft says that Visual Studio packages are binary compatible from 2005 so any packages that loaded successfully into VS 2005 should work in VS 2008.  Err, no.  At least not with VS 2008 beta 2.  I admit it didn't take much of a change to fix things, but it wasn't seamless.

So, I just committed a patch to our trunk repository that enables Connector/Net in VS 2008 beta 2.  Here's a shot of it running.

This trunk repository will eventually be our 5.2 release and you can grab a sneak peek by pulling a snapshot from here. 

I probably don't spend quite enough time following progress around MySQL considering how critical the product is to us. I'd like to consider it part of the infrastructure in a way I treat Red Hat Enterprise Linux, ie something I can trust to make good progress and follow up on a quarterly basis. Naturally we have people who watch both much more closely, but my time simply should, and pretty much is, spent doing something else.

However, it seems MySQL really demands a bit more attention right now. Today I went and read Jeremy Cole's opinion about MySQL Community (a failure), and I have to say I agree on many of the points. MySQL simply has not yet found a model that works as well as that of Red Hat's Fedora vs Enterprise …

Craig Mullins has weathered a very heavy week in the ’sphere and published the 63rd edition of Log Buffer, the weekly review of database blogs, on Data Management Today. Log Buffer’s dance-card is almost empty now. LB wants your attentions! If you’re a new database blogger, editing and publishing an edition of LB on your [...]

Recently I have been taking a serious look at stored procedures in MySQL and, in particular, how I might go about implementing them in my website and, in particular, where they could be used and why. At present, I have really only gotten my feet wet with using stored procedures, but I think that is enough to make some conclusions that I thought might be helpful to others that are starting to look at stored procedures as well.

One of my initial impressions is that, if you have never used stored procedures before, it seems to be slightly daunting at first. Stored procedures in MySQL basically use standard SQL syntax, but I found myself using some of the lesser used SQL structures (such as IF and WHEN statements as well as session variable handling). The MySQL documentation on stored procedures focuses directly on them and does not really cover the …

Wednesday

MySQL AB’s developer meeting lasts an entire week. The community days, as they call it, are only on Thursday and Friday, but Lenz asked me to come on Wednesday night for the get-together then. I arrived five minutes after they all left without a trace.

Thursday

The developer meeting is organzied like proper conference. There are different sessions to go to in different rooms, coffee breaks and everything. The morning sessions are actual team meetings while in the afternoon there are MySQL University lessons.

MySQL University is a weekly installment where a smart person lectures about a hot topic in the MySQL world (NDB Architecture, Using BitKeeper, Running MySQL with a debugger just to name a few). They started out as MySQL internal training courses, but …