Jos, my co-author for the "Building Pentaho Solutions" book just pointed me to a recent article by Jeff Prenevost entitled "The Problem with History".AbstractJeff's topic, loading a hybrid Type 1 / Type 2 slowly changing dimension table is related to data warehousing but maybe of interest outside of that context as well.

As it turns out, the particular problem described by Jeff is non-trivial, but can be solved quite elegantly in a single SQL statment. This may be a compelling alternative to the multi-step, …

In the last few months, we've introduced a few interesting new features to opentaps.

Query Builder for opentaps Analytics

We have completed a query builder for opentaps analytics, which allows you to query the opentaps data warehouse based on multiple criteria. For example, you can now run a report of sales by product for all "Gizmos" in the United States since 2007, or sales by product in California on Mondays during the Julys. This new tool, along with the data transformations, reports, and report generator we've already built, will give you a large number of available reports through opentaps analytics

Google Web Toolkit Widgets Now Officially in opentaps

We have merged back the Google Web Toolkit (GWT) …

Has anyone else noticed that almost all of the consulting companies that support MySQL (and blog) start with a 'P'? (Percona, Pythian, Proven Scaling). I think OpenQuery needs a name change to keep up with the market. Even though 'O' is the letter next to 'P' in the alphabet, it requires more than one bit flip - so it's not that close.

Has anyone else noticed that almost all of the consulting companies that support MySQL (and blog) start with a 'P'? (Percona, Pythian, Proven Scaling). I think OpenQuery needs a name change to keep up with the market. Even though 'O' is the letter next to 'P' in the alphabet, it requires more than one bit flip - so it's not that close.

The MySQL Proxy was split into

• a chassis which handles cmdline, service, logging, plugin loading
• a core library for the life-cycle, network handling and protocol decoding
• a lua layer wrapping around the internals
• a set of plugins: proxy, admin, debug, replicant

It also contains a few tools that reuse the above libraries:

• mysql-binlog-dump
• mysql-myisam-dump

We dropped libcheck in favour of glib 2.16's g_test_* functions.

Changelog:

Chassis

• added support for SIGHUP to reopen logfiles
• added win32-service support
• added --basedir
• added experimental --log-backtrace-on-crash
• added DTrace probes
• added a angel to keep the chasses alive
• added --user option to change the …

I’ve been thinking about SaaS (in the form of Spinn3r) and how it relates to Open Source for the past few months and I think I’ve come to some interesting conclusions. I think SaaS might be a strong competitor to Open Source in that it’s cheaper and higher quality in a number of situations.

Apparently, I’m no the only one:

Open source is always driven by some organisation – a central body that leads community development efforts to support developers and build revenue streams. In essence, that body gives away the base code and knowledge of the community version to encourage development of the service and expand distribution; to make the software go ‘viral’.

However, I believe software as a service …

This week we had our first WarpTalks session. Once a month we’ll gather in our meeting room and someone will deliver a talk, workshop or debate about topics considered interesting.

We opened this Monday with two talks. They are in Spanish but you can get the idea.

Introduction to Subversion by Victor Jimenez

Subversion is the RCS we currently use, and the developers know it well enough to do their everyday job, but the not-so technical people at the company have been expecting some training for a while.

Introduccion a Subversion from Jorge Bernal on Vimeo.

10 things you might not know about MySQL by Jorge Bernal (me)

MySQL is the obvious choice when we need a database for our projects, so many of the developers use …

Sun reports second quarter results. Compiere reports 216% quarterly revenue growth. EnterpriseDB grows customers accounts. Hyperic and JasperSoft team up on BI for IT. Microsoft embraces Apache but resists GPL. And more.

Sun up or Sun down?
There was some comparatively good news from Sun, which reported a net loss of $209m on revenue down 10.9% at $3.2bn. As Sam Diaz at ZDnet notes, however, “after excluding one-time costs related to recent layoffs and other costs, the company posted a profit of 15 cents per share, beating analysts’ expectations of a 10 cent loss”. In regular trading, shares of Sun were up more than 5%.

Matt Asay noted the impact open …

Hello and welcome to my Log Buffer, the weekly review of database blogs. My name is Keith Murphy and I am the editor of MySQL Magazine, a free digital magazine with information for MySQL administrators and developers, released quarterly.  I am also a MySQL database administrator at Pythian.

I am losing count of how many of these Log Buffers I have done. If I recall correctly, this is number three. But then again, it could be number four. You know what they say though—the more the merrier!

This week’s Buffer features a great allegory about a database, some tips, feature requests, and breaking news. It seems that this week, people shared information that was relevant across database servers, so I recommend that no …

Next Thursday (February 5th), we're continuing our series of sessions on MySQL performance measuring and improvements with Allan Packer's presentation titled MySQL Performance and Scalability Project - Issues and Opportunities. Allan works in the Performance and Applications Engineering department at Sun Microsystems, so again, expect to get some deep insights into the inner workings of the MySQL Server.

Allan is based in Australia, so note that this session will take place in the morning (Europe) or evening (APAC), respectively.

For MySQL University sessions, point your browser to this page. You need a browser with a …