Building simplicidade.org: notes, projects, and ocasional rants

Notes

last update:

RedHat and the RHN Satellite Server

Just saw that RedHat will release RHN Satellite Server source code. Well, too late. I was a more or less happy customer of RHEL for 2 years, with 4 licenses of RHES3. The distribution was rock solid, but the RHN was a mess, rarely worked the way it was supposed to, updating only some of my servers, and the performance was painfully slow. I dropped RHEL and moved over to CentOS, not because of price (I believe they should be payed by their services), but because the software update service was better, '''way''' better than RHN.

Top 3 tools for MySQL

At the moment, my top 3 tools to tune MySQL are: mysqlreport: a friendly report about the status of your MySQL server (or SHOW STATUS for real persons);innotop: a top-like program to see what's going on with your MySQL server (works with multiple servers);mysqlsla: analyses MySQL statement logs (including slow queries).Other tools are also useful sometimes: Duplicate Index Checker: checks your indexes to see if you have multiple indexes covering the same information, in the same order;MySQL Query Profiler: reports on what work MySQL will have to do for a given batch of queries.

Twitter

Twitter.com is becoming a world wide chat-room or IRC channel, where two or three people have a conversation twitting their messages. Crazy. Get a room already!

JQuery Love

I'm not a Javascript guru, I just dabble a bit, and most of the time I would only reuse stuff from other persons. Until I spent a weekend with JQuery. I needed a small JS lib to do some stuff in a application I'm working on. Basic stuff, like edit in place, building HTML live and adding more options to forms. After looking at the tutorials and "how it works"-kind of pages, I started to try it out.

JSF renamed

Yay! The Jabber Software Foundation is now the XMPP Standards Foundation. I think this is great news. Of interest: recently in a mailing list I subscribe to, there was an impromptu exchange of instant messaging addresses. I was very very happy to see that the majority had a Jabber address, mainly using GTalk service. This was not a geek list, by the way.

MacFUSE, by Google

Awesome news: Today Google is releasing MacFUSE, an open-source Mac port of the FUSE mechanism for Linux. Like FUSE, it enables developers to implement a fully functional file system in a user-space program. And since it aims to be API-compliant with the original FUSE (Filesystem in USErspace) for Linux, it makes many existing FUSE file systems readily usable on Mac OS X. The core of MacFUSE consists of a dynamically loadable kernel extension.

Jobs keynote: $60M per minute

With the 100 minute Apple keynote where the iPhone was introduce, Apple market capitalization raise $6B. Thats sixty-million dollars per minute right there. This and much more info on this post.

Apple TV

When I first saw the presentation of this last year, I was not terrible impressed. But I've been looking for a device that would connect to the TV and allow me to play XVid and DivX files. I would upload the files via ethernet or wifi and I would have a small interface on the TV to play them. Right now, the Apple TV does most of what I want. I don't expect support for DivX or XVid anytime soon, so we will need to do some transcoding, but as long as we can do it, I think I found my box.

iPhone

It's here, everybody has an opinion: I like: the weight is the same as an iPod 5G. It's a tiny bit shorter, and a tiny bit thicker;160 dpi screen.I don't like, but I hope they change it in time: the lack of support for third party applications;the lack of 3G: I don't believe they will launch in Europe without this.Overall, very very good. I want one. Update: there is a good iPhone video demo online at YouTube.

Tip: MySQL is not that helpful sometimes

Stupid problem today. In a listing I had, I had a percent column. The problem was that the database definition for that column was wrong, it used DECIMAL(2,4). Yes, 100% will not fit in there. Also: this syntax was valid in 3.x but with 5.x you need DECIMAL(6,4). I'm using now DECIMAL(7,4) to fit the edge case. My peeve with MySQL is that if I give him 100 to put in that column he will not complain nor store NULL.