Archive for May, 2007

MySQL, PHP

libmyxql is moving

Roland Bouman just gave me a call. He’s setting up a MySQL UDF repository, which sounds worth while joining. So I’ve decided to move the libmyxql project there. The lib will be renamed to lib_mysqludf_xql to follow the naming convention. You can find the repository on http://www.xcdsql.org/MySQL/UDF/index.html.

He also gave me a few good tips, including a way to get the name from the column or alias to be used as tagname. This should make the lib a bit more like SQL/XML. The downside is that the API will change again, but it the end it will be much better, so…
He also got his UDFs working for Windows, which I will implement as well. So good news for all you Billy lovers out there.

More about this soon….

Einstein

Postbank aanbieding (of niet)

Het gaat kennelijk niet goed in de bankwereld. De oude vertrouwde postbank komt met een mooie aanbieding:

Postbank aanbieding

Slechts 750 euro + 1,95 voor een bon van 15 euro, geen geld toch?

PHP

Drop in replacement for Snoopy

I’ve just finished a so called drop in replacement for the snoopy library. I grabbed a RSS aggregater from the planet-php site. The aggregater was using magpierss, which in its place was using snoopy to get the RSS feeds. Unfortunately the whole snoopy library is a bit outdated (the magpierss as well). This shouldn’t be a problem, but I ran in to a few anyway.

The first problem I had was that snoopy always got a time out when fetching content from a server with keep-alive enabled. It should look at the ‘Content-Length’ header, but it doesn’t. Second was that fetching data which was send chunked, header ‘Transfer-Encoding: Chunked’, didn’t arrive well at all. The sizes are send before each chunk, which made them end up in the result. That of course, made the whole XML invalid making magpie fail.

The new snoopy library uses Curl instead of the file handlers (fopen, fgets, etc). Basically all the functionality of snoopy is already in the curl extension, so I just had to write a wrapper for it. It should be a drop in replacement, but I’ve only tested it with magpie, so there might be some bugs still.

I’m happy again. If you are sad about snoopy and want to be happy as well, you can download the lib from this site. Should there be any bugs, please let me know.

For the record… If you are not using snoopy, don’t start now and just learn how to use curl.

Einstein, Javeline / Ajax.org

Javeline’s developer center is (almost) here

The server has gone online, but the website isn’t live yet. There are still some CSS problems with IE, especially in the bug tracker. I’ll have to look at that next week.
Also much of the content is still a stub and the downloads are fake as well. The deadline is the 21st of may, so that should be a problem.

If you want to have a look already go to http://developer.javeline.net (use Firefox).

My linux desktop, PHP

Eclipse problems solved (finally)

I was getting a lot of hassle from eclipse after updating to ubuntu feisty. Finally I found the problem. I was running GNU java VM (GIJ) as default, while eclipse is build to run with the SUN java VM. The GIJ is only Java 1.4 and it therefor not working correctly.

Run the command `java -version`. And if you get the following, it’s no good:
java version “1.4.2″
gij (GNU libgcj) version 4.1.2 (Ubuntu 4.1.2-0ubuntu5)

Just install the SUN java packages (using apt) and then run `update-java-alternatives -s java-1.5.0-sun`. When you run `java -version` now, you should read:
java version “1.5.0_11″
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
Java HotSpot(TM) Server VM (build 1.5.0_11-b03, mixed mode)

Now re-install eclipse and it will run like a charm.

Continue Reading »

Einstein, Javeline / Ajax.org, PHP

Using flyspray

I’ve just finished with the bug tracker for the new development center of Javeline based on flyspray. Don’t let the crappy website of flyspray turn you down, because the software is actually quite good.

I did have to modify it quite a bit, to make the style match that of the website and (more important) make it anonymous-user friendly.

The developer center is not online yet, but keep watching this blog and you’ll know the minute is goes live. If you need any of the changes I made to flyspray, which haven’t made it into the main distro, like captcha or a ‘new task’ button when ‘all projects’ is selected, just write me an e-mail.