Might come handy - How to convert a UNIX timestamp to a date in Oracle: TO_DATE('19700101000000','YYYYMMDDHH24MISS') + NUMTODSINTERVAL(unix_epoch, 'SECOND') Coolness.
I've talked about this before. Basically, if you use UTF8 in your database, the scalars returned by DBD::mysql wouldn't have the utf8 flag turned on for text fields. Until now. With the latest release (DBD-mysql-4.0000), things have changed. A patch from Dominic Mitchell was applied (in DBD-mysql-3.0008_1 according to the changelog) that does the right thing regarding UTF8 text fields. Check the documentation (search for mysql_enable_utf8) to see how it works.
Comments and Trackbacks are back, courtesy of HaloScan. It might go bonkers while I tweak my templates, but seems to work. Old comments are still available on each individual entry under the heading Comments BHS (Before HaloScan) (like this todo.sh entry). The old Trackbacks are still missing though. I'll get to them later, the solution I used for old comments is not that good for Trackbacks.
The Beta-days we live in are getting to a point that it starts being funny. Check out the Google SOAP Search API page. It stills displays the Google-traditional Beta-stamp, but the API had a vasectomy, as of December 5, 2006. Can you at least remove the damn Beta-stamp? Is not likely to change now, is it?
Yes, I'm still breathing. This is just a quick post to tell you all that I'm closing comments and track-backs on all my posts for a couple of days, while I move them to HaloScan. After that is done, I'll give you a big update on life, and the meaning of freelance work.
One of the good things about Subversion is that all his internals (paths, commit messages, etc) are always UTF-8 encoded. I think that was one of the brightest decisions they made. Yet, for quite some time I was getting errors when I tried to use commit messages with accentuated characters: subversion/libsvnsubr/utf.c:466: (aprerr=22) In my case, the problem is that I didn't have a proper LANG environment variable. If run svn ci like this:
I've just finished watching the Quicktime stream of the Apple Showtime presentation. My first impression is positive, but there are some issues. The iPod revamps are nothing spectacular in my opinion, with the exception of the iPod Shuffle which I find truly amazing. The extended batteries are cool for some of you, but I already get enough juice from my iPod Video. The new search features feel strange to me. I'll have to experiment a bit to see if they match with my brain.
Rui did the .Mac part of Google + Apple. I'll do the XMPP part: Apple is using XMPP in it's iChat client, but still defaults to .Mac accounts based on the AIM network. If out of this get-together we get iChat using by default Jabber, powered by GTalk servers, and maybe even start using Jingle JEPs for all the cool iChat peer-to-peer multimedia capabilities, then the interoperability with iChat is even more closer.
If you asked me what web-based application is the best example of what you can do with HTML and AJAX, I would respond: Dabble. Check the videos and screencasts, it's truly amazing.
Not only to answer to Rui, but also so that I don't forget, these are the series I'm keeping track of, mostly via DVD's from Amazon.co.uk: House MD;Battlestar Gallactica;24;The West Wing (waiting for last season, number 7): I'll miss this one;CSI (Las Vegas, Miami, and NY);Without a Trace;Desperate House Wife's;Gilmore Girls (Yes, that one);(sometimes) Law & Order: Criminal Intent.Ordered in terms of my personal preferences at the moment. I might be missing Also so that I can keep track, and remember to talk about them later, this are the latest technical books that I bought and I'm in the middle of (ordered in reverse chronological order of purchase):