Weblog

MySQL versus PostgreSQL: Adding a 'Last Modified Time' Column to a Table

This is the second post here detailing my ongoing adventures with PostgreSQL. This time I had a requirement to add a "timestamp" column to a table. The point of this being to allow us to track the "last modified" time of a row, without requiring that the application code manage the timestamp itself.

There's a lot of reasons why you might wish to do this. In this case it was to simplify syncing the data into a data warehouse. More specifically, to allow the DBA to easily identify rows which have changed since the last import.

Having done this a couple of times in MySQL, I assumed that the process would be straightforward. I should know better by now!

Continue reading MySQL versus PostgreSQL: Adding a 'Last Modified Time' Column to a Table »

Posted on Friday, the 14th of March, 2008 | permalink | comments (12)

An Introduction to Tera-WURFL

I recently added a post about Wurfl, a comprehensive open-source XML database of mobile device capabilities. I noted that actually querying Wurfl in a performant manner:

is going to be a non-trivial task, and is perhaps a topic for a further article.

Well, I guess this is that article. It's time to have a look at Tera-WURFL, which is perhaps the most popular tool for querying Wurfl programmatically - from PHP, at least.

Continue reading An Introduction to Tera-WURFL »

Posted on Tuesday, the 11th of March, 2008 | permalink | comments (3)

Herding Cats

For as long as anyone can remember, the term "herding cats" has been used as an analogy for the challenges involved in managing developers. The implication being, of course, that developers tend to be smart, wilful, single-minded folks. Personal experience suggests this is often the case.

The analogy was reflected in the title of a book named "Herding Cats: A Primer for Programmers who Lead Programmers", written by the impressively named J. Hank Rainwater. I mention it because this is a decent read for anyone who develops, or who works with developers - whether in a management capacity or not. It's not in the same league as "The Pragmatic Programmer", but I'm getting off the point now.

So anyway, I came across this video via Yahoo MySQL guru Jeremy Zawodny's blog. It's so slickly made that you're not surprised when it turns out to be an ad for a big expensive professional services company. But I liked it.

Continue reading Herding Cats »

Posted on Saturday, the 8th of March, 2008 | permalink | comments (0)

MySQL versus PostgreSQL: Adding an Auto-Increment Column to a Table

The bulk of my database experience (almost eight years now) has been with the popular open-source MySQL database management system. MySQL has progressed significantly over the years, and has grown into a remarkable product. It finally has all the must-have features such as views, stored procs and referential integrity, coupled with the blistering performance for which MySQL has always been known. In short, it rocks.

But I digress. I've recently been having to get to grips with PostgreSQL (an old version of course - 7.1 or so - just to make life really interesting). It's largely intuitive, but there are quirks around most corners. This is my favourite so far: I recently needed to add an auto-incrementing integer "id" column to a table.

Continue reading MySQL versus PostgreSQL: Adding an Auto-Increment Column to a Table »

Posted on Wednesday, the 5th of March, 2008 | permalink | comments (38)

A Brief Glossary of Mobile Jargon

A few terms that seem to get bandied about in the industry. I'll probably add to this over time.

Continue reading A Brief Glossary of Mobile Jargon »

Posted on Thursday, the 14th of February, 2008 | permalink | comments (0)

Managing Mobile and Non-mobile Versions of a Site Using Tera-WURFL and Zend Framework

This is a quick proof-of-concept I put together after a discussion on how to deal with running a mobile site and a 'full' web site on the same hostname in a sane way, and to transparently route user agents to the appropriate site.

Continue reading Managing Mobile and Non-mobile Versions of a Site Using Tera-WURFL and Zend Framework »

Posted on Tuesday, the 12th of February, 2008 | permalink | comments (3)

Mobile Device Detection: WURFL and UAProf

Posted on Wednesday, the 17th of October, 2007 | permalink | comments (0)

Are Relational Databases Obsolete?

Posted on Friday, the 7th of September, 2007 | permalink | comments (1)

JsUnit

Posted on Tuesday, the 8th of May, 2007 | permalink | comments (0)

« newer | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | older »