The Database Programmer

This week in the Database Programmer we look at something called an "UPSERT", the strange trick where an insert command may ...

If you look at any system that was born on and for the internet, like Ruby on Rails, or the PHP language, you find an immense wealth of re...

This week we are returning to the series on Philosophy, and we will nail down the role of data and the database in any application th...

This week I am taking a bit of a departure. Normally I write about things I have already done, but this week I want to speculate a b...

No it does not. If it did, then your customer/employer would be doing something no other human being has ever done, which is unlik...

There are links to related essays on normalization and denormalization at the bottom of this post . This blog has two tables of contents, ...

The stunning power of a data dictionary comes into play once the dictionary contains formulas for calculated values. The dictionary ca...