If you haven't signed up for our webinar - Turbo Charging MySQL Reporting and Data Warehousing with Kickfire, you can do so at the link below.

I will be one of the panelists discussing our exciting new appliance and how it can help accelerate your MySQL database performance now and into the future.

http://www.mysql.com/news-and-events/web-seminars/display-146.html

And again we're on our mission to keep XAMPP up-to-date and just released the first betas of the upcoming XAMPP version.

In this beta we updated: Apache (2.2.9), MySQL (5.0.51b), PHP (5.2.6), phpMyAdmin (2.11.6), mod_perl (2.0.4), OpenSSL (0.9.8h), and eAccelerator (0.9.5.3).

XAMPP beta versions are always for testing purposes only. There will be no upgrade packages from and to beta versions. To all testers: Many thanks in advance!!

Get the downloads at XAMPP BETA.

I usually try very hard to not write about IBM. But the following from Matt Asay requires a reply. Regardless, IBM isn't in the habit of open sourcing technology in which it has a lead or at least a strong position, such as it does with DB2. IBM strategically invests in open source to undermine the margins of its competitors, not its own. Really? Take a look into OSGi, SCA, Apache HTTP Server or the countless other open source projects into which IBM has open sourced technology. This technology didn't undermine competitors; it helped customers and competitors alike (and let's... READ MORE

Truncating all tables in a database is a common problem which arises a lot during testing or debugging.
One of the most common answers to this question is to drop & recreate the database, most likely utilizing the shell. For example, something like this:

mysqldump --add-drop-table --no-data [dbname] | mysql [dbname]

This dumps the entire schema structure to disk, without dumping any data, and with commands for dropping existing tables. When loading it back into mysql, it essentially truncates all the tables in the database. Basically, this is a decent solution for many uses.

We had a requirement for a solution that needed these additional features:

1. Does not require shell (We work with both Linux and Windows)
2. Resides inside the MySQL Server (To minimize outside dependencies - for example - the mysql command line client)
3. Can truncate only specified tables using a …

There's a story on CNet about IBM considering open sourcing DB2. While there are no immediate plans, IBM UK's director of information management software Chris Livesy has said that market conditions may make it unavoidable. "Looking at IBM's heritage in contributing to the open-source market, we've been particularly keen to lead that market. Open source is an interesting space, as a whole. As the future unfolds, and the economics become clearer, there's going to be more commitment to open source by everybody. We've made good steps towards that." And why not? A while back, I predicted that within 10 years... READ MORE

How To Set Up WebDAV With MySQL Authentication On Apache2 (Debian Etch)

This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on a Debian Etch server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP. Of course, WebDAV can also be used to upload and download files.

On my current project my team had to develop a portlet interface. Users can load portlets and organize them in multiple tabs with 3 columns per tab. They can reorganize the order of their tabs and move portlets within a tab an also move them to new tabs. Portlets are always placed at the top left when they get added or moved to a tab. Furthermore portlets and tabs can be removed, though the last delete operation can always be undone. All of this essentially required me to devise a plan for how to manage ordered lists inside an RDBMS.

Note that while this was written for MySQL (it makes heavy use of MySQL session user variables), I am using the Oracle style named placeholder support that PDO emulates for MySQL. So do not get confused by ":foo" in the SQL statements. This is just like the "?" you should know if you ever used prepared statements with MySQL. Furthermore I am using pseudo code control logic around the SQL. I think it should be …

In the last several months at Grazr, we've been wrestling with a large database (running on MySQL) of feeds and feed items. The schema is essentially a feeds table with child tables items, items_text (text), and enclosures. We have this database to provide the means for users to be able to merge (a Stream) feeds so that you have an aggregate feed with items for whatever feeds you want in the list of feeds for your merge. It works great, the only problem being the volume of data, which more data means the query to produce that merge becomes slower. We want this merge to be able to be run on the fly, and if it's too slow, the user experience is unacceptable.

So, now I'm in the process of implementing a "Hot Cache" of feeds with an LRU (Least Recently Used) policy. The idea being, that this cache provides a smaller data set for performing the merge query against. We need to be able to handle storing much more data than we currently do …

How To Set Up WebDAV With MySQL Authentication On Apache2 (Debian Etch)

This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on a Debian Etch server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP. Of course, WebDAV can also be used to upload and download files.

To coincide with EURO 2008, I’m embarking on a virtual European tour, taking a quick look at open source policies and deployment projects in the 16 nations that are competing in the tournament.

The Czech Republic team was just three minutes away from qualifying for the knockout stages of EURO 2008 on Sunday before Turkey managed to turn a 2-1 deficit into a 3-2 win. Publicly available information on Czech open source deployment projects suggests that the country has had rather more luck when it comes to open source.

Key projects:
There was early success in 2001 when …