Dependency Management Standardization

David Lloyd and I are working on getting some standards together for dependency management. We are hoping that this will help unify projects and provide the ability for all the different projects to use the same repositories. Please join us for the discussion if you have ideas you want to share. Here are the details: […]

Database date/time support sucks

Okay, after many hours of battling with MySQL and PostgreSQL, I’ve come to the conclusion that databases support for dates and times suck. PostgreSQL appears to do a much better job than MySQL, but overall they both leave a lot to be desired. The main The main issues with both these databases is that the […]

Database handling for TimeZones

Today I’ve been working with Postgresql and MySQL trying to figure out how they handle date-time values and timezones. This is actually quite tricky, so I wanted to write it down for later. First, both databases have two different types of columns: One that stores the date-time without any time zone information One that stores […]

Oracles OLTP numbers vs. Clean Speak

Oracle is hosting a webinar today covering the awesome performance of their Exadata system. Sure Oracle’s OLTP tests probably do slightly more than Clean Speak does, but 1,870 transactions in 2 minutes hardly seems like something to rave about. The Clean Speak profanity filter handles between 5,000 and 10,000 messages per second. The profanity filter […]

Escaping JSON in FreeMaker

The ?js_string doesn’t work quite right for JSON since it ends up escaping single-quotes. This isn’t quite right for JSON since it only allows Strings to be specified using double-quotes. Therefore, in order to properly escape Strings in FreeMarker for JSON, you need to write a custom method and add it to the model. Here’s […]

JDBC Batch vs. Multi-Row Inserts

I recently had a requirement to insert a few hudred rows into a relational database ever couple of seconds. Generally this could be accomplished during the request, but I didn’t want to introduce issues if there were spikes. Therefore, I figured I would cache the data and then write it out in a background thread […]

iMac vs. build-your-own

I’ve been meaning to do this comparison for a while now, but this morning I decided to just jump in and do it. A lot of people are constantly complaining about how expensive Macs are and I’ve long held the notion that they are quite reasonably priced. Here’s my break down: CPU (i7 2600K 3.4GHz […]