[Update 28/1/2007: New Version and new website.]

Amit Singh ported FUSE to MacOS X. This is just cool. Thanks!

I created a little Cocoa GUI around sshfs to manage and mount your remote drives via ssh conveniently from a program and not from the commandline. This is early alpha software and may break things. It is not heavily tested and could sleep with your wife while beating your kids, so BEWARE! Additionally, the software it interfaces with is in its early stages as well and it includes a custom kernel extension (written by Amit, so I trust it). You have been warned. It's so new that it doesn't even have an icon. But sssssh!

See this announcement for …

I just made a snapshot of the development branch of the innotop MySQL and InnoDB monitor, and released it as version 1.3.0. This code will eventually become version 1.4. Here’s what’s new. Version number policy Odd-numbered releases, such as 1.3.0, contain the code that will eventually become a stable release – in this case 1.4. Not all the features are there, and not all of them work perfectly, but it’s a development snapshot for community review and feedback.

In this episode, the second part in a two-part series about Falcon, the new storage engine provided by MySQL, we talk about what happens when commit, going over and explaining the serial log and indexes.

Direct play episode 6 at:
http://tinyurl.com/yympcn

Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=206806301

You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Links:
Falcon features:
http://dev.mysql.com/doc/falcon/en/se-falcon-features.html

Falcon …

I believe this is a huge optimization for a heavily implemented Web 2.0 idea.

This article makes simple work of groups of queues. An example of this would be “the most recent 10 people to view an article,” so each article has a queue of up to 10 items in it. This method eliminates the need for multiple SQL statements or using TRIGGERS to check to see if the queue is full.

I bow down to Baron Schwartz, aka Xarpb, for his article on how to implement a queue in SQL:

http://www.xaprb.com/blog/2007/01/11/how-to-implement-a-queue-in-sql/

I am very excited because this also works for groups of objects, and we’re about to implement something at work that needs this idea. The idea of “the most recent x things” or “the top x things” is huge, especially in social networking, and probably one of the most often …

I had dinner with Fabrizio, a good friend and CEO of Funambol, the leading mobile open source company. He was in Salt Lake to ski and was kind enough to call me so that we could hang out.

Fabrizio said some things about open source that rang true with me, which I had not considered before. I'll list two principles he mentioned, and will discuss each in turn:

1. Don't upsell your community, and

2. Sell open source to those who don't like/trust open source.

At first glance, Fabrizio's principles fly in the face of most open source businesses out there. But when you scratch the surface of his thinking you see that it actually undergirds the most successful open source businesses. Let me explain.

Fabrizio's first principle - …

I’ve just recently released a new version of libmygis, a library for dealing with various GIS formats. Its main purpose is importing ESRI Shapefile data into MySQL’s GIS, but it is useful for much more.

There are many new small features in libmygis 0.7, but the biggest new feature is projection support (and automatic re-projection) via the PROJ.4 cartographic library. With support for projections and the ability to read Shapefile PRJ files, libmygis is getting much closer to having full support for the Shapefile format.  This means you can easily import Shapefiles in any projection into MySQL and deal with it in pure lat/lon, which is what you’ll need in order to interface with outside tools such as …

I've been told I should start blogging about the fun projects I work on. Here is a start to this endeavor!

I recently left the employment of MySQL to work at Grazr. What is Grazr you ask? It's a great new tool that allows you to view as many feeds as you like without subscribing. It's a client-server architecture, where the client is Ajax/javascript with a great UI that lets you have a "tree" of feeds. It utilises OPML as the structure which it displays feeds. You can read more about it at http://www.grazr.com, since I'm new and I think the site does a much better job at explaining what Grazr is all about.

I look forward to utilising all the good things I've learned while at MySQL for Grazr. The things I will most definitely use are MySQL itself such as replication, various storage engines, stored procedures, and great GUI tools which I didn't use much as a core …

Finally, episode 5 is here. In this episode, the first part in a two-part series about Falcon, the new storage engine provided by MySQL, we talk about what happens when you query a Falcon table, going over and explaining MVCC and the record cache. Next episode will go over the serial logs and indexes.

Direct play episode 5 at:
http://tinyurl.com/y68ewn

Subscribe to the podcast by clicking:
http://phobos.apple.com/WebObjects/MZStore.woa/wa/viewPodcast?id=206806301

You can Direct download all the oursql podcasts at:
http://technocation.org/podcasts/oursql/

Jim Starkey is a great speaker, and very funny to listen to ? at one point he refers to a performance hit as a …

lca2007 already totally rocks.

did the speaker thing this morning, which was awesome (and i won’t spoil the surprise)

mysql miniconf today, should rock.