CYBAEA Technology Notes

The blog to satisfy your inner geek! Our Technology Notes is an infrequent series of notes that document some of our learnings from experimenting with various tools and gadgets.

This blog is for technology enthusiasts only.

Subscribe to CYBAEA Technology Notes

4 easy steps to make Mason utf-8 Unicode clean with Apache, mod_perl, and DBI

On 2009-01-28 17:57:00, Allan Engelhardt wrote:

This is a note for people who are using the Mason system for high-performance, dynamic web site authoring with Apache, mod_perl, and a relational database like PostgreSQL accessed through DBI, and who want to be utf-8 Unicode clean in all their data.

You want to be able to write accented letters in any language in your web pages. You want your users to be able to enter any characters in web forms, and you want that data to get in and out of your relational database and still display correctly and be handled correctly by perl.

That is, unfortunately, not how it works out of the box, at least not on Red Hat Enterprise Linux 5 or on Fedora 10. This article shows how we made it work right.

Username:
Password:
Remember me:

Recent blog entries

R: Eliminating observed values with zero variance

On 2010-03-08 14:46:00, Allan Engelhardt wrote in CYBAEA Data and Analysis:

I needed a fast way of eliminating observed values with zero variance from large data sets using the R statistical computing and analysis platform. In other words, I want to find the columns in a data frame that has zero variance. And as fast as possible, because my data sets are large, many, and changing fast. The final result surprised me a little.

Your mobile phone knows everything about you ... and it is telling

On 2009-08-17 09:18:00, Allan Engelhardt wrote in CYBAEA Journal:

We knew the potential existed already, of course. Mobile devices in the USA generates some 600 billion transactions per day, each tagged with the location and time. Jeff Jonas: Every call, text message, email and data transfer handled by your mobile device creates a transaction with your space-time coordinate[...].

The mobile operators have this data, of course. We all know this (especially here where we have been using some of it for social network analysis). No real surprises here, except perhaps in the volumes.

But did you know that the operators are sharing your data? What is new, at least to me, is that this data is being provided to third parties that are leveraging specially designed analytics to make sense of our space-time-travel data.

Beautiful Data

On 2009-07-27 19:38:00, Allan Engelhardt wrote in CYBAEA Data and Analysis:

O'Reilly's recent publication Beautiful Data has a chapter by Jeff Jonas which is enough reason in itself for me to recommend it. The chapter, Data Finds Data, is also available as a PDF download.

Massively parallel database for analytics

On 2009-07-22 13:37:00, Allan Engelhardt wrote in CYBAEA Data and Analysis:

This is by far the best description of why traditional parallel databases (like Teradata, Greenplum et al.) is a evolutionary dead end. But much more than a theoretical discussion, they have built a solution which they call HadoopDB. It is based on Hadoop, PostgreSQL, and Hive and is completely Open Source. Alternative, column-based, backends to PostgreSQL are being implemented now. Read: Announcing release of HadoopDB.

B2B Content Marketing

On 2009-07-22 06:59:00, Allan Engelhardt wrote in CYBAEA Journal:

The nice people at Velocity has released The B2B Content Marketing Workbook. It is behind a registration wall which means we wouldn’t normally recommend it but you can just type junk in the fields if you are not comfortable with giving your personal details to a marketing agency. (Think about it....) If you are relatively new in the B2B world, say having joined a professional services or consulting organization, you may find this one useful.