Notes

For the past 3 months, I've been working as a freelancer.

In September, I left my previous employer, SAPO, where I worked for almost a year and a half as the Technical Project Manager for the Jabber/XMPP-powered instant messaging project, Mensageiro.

The switch was due to family issues. My second son was born May 31th, and since then the pressure of doing a 200km commute to Lisbon twice a week was getting a little bit more than I was willing to handle. Also, I was missing out on probably the best years of my kids.

So now I'm working on several projects.

First, I'm still attached to the XMPP project at SAPO while we switch server platforms. I don't think my work there is done (I don't think it will never be, really), and I expect to close some very cool features in the very near future. XMPP is getting a lot of publicity right now, and I praise SAPO for seeing this as a strategic area on which to focus resources.

Second, I'm working on a medium sized Catalyst/DBIx::Class project. This is giving me an opportunity to enhance my DBIx::Class skills. I plan to write a bit about this, but as an executive summary, I can tell you this: I first looked at it around version 0.4-something, and I was not at all impressed with it. The current version, however, is vastly superior, and I would encourage anybody who is doing DBI-related work to look at it.

Same could be said about Catalyst. If you only know pre-5.7 versions, you own yourself a favor and look it up again.

Third, I also preparing a new version of my family business site. My wife and I have a e-learning site, Evolui.COM, that has been a bit neglected in terms of upgrades and feature improvements. I've been re-factoring stuff, mostly in the back-office, to make it more productive for our day-to-day support people, and I hope to start hacking on the main site soon.

All in all, being near my family after almost 7 years with my wife, but always on the road, is probably the best move I made in a long time.

So 2006 had two major life switching events: my second son, and leaving behind 12 years working for others. Let´s see what 2007 will bring us.

Happy new year to you all!

Posted by Pedro Melo at 05:57 PM | Permalink | Comments (view)

Might come handy - How to convert a UNIX timestamp to a date in Oracle:

TO_DATE('19700101000000','YYYYMMDDHH24MISS')
+ NUMTODSINTERVAL(unix_epoch, 'SECOND')

Coolness.

Posted by Pedro Melo at 04:26 PM | Permalink | Comments (view)

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. You can also look at the utf8.t test script for examples of usage.

I'll post back my findings after I play with it.

Posted by Pedro Melo at 04:25 PM | Permalink | Comments (view)

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.

Posted by Pedro Melo at 04:01 PM | Permalink | Comments (view)

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?

Posted by Pedro Melo at 11:23 AM | Permalink | Comments (view)

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.

Posted by Pedro Melo at 11:49 AM | Permalink | Comments (view)