An interesting post from Lullabot today [1] on problems with Drupal's Schema API and the Twitpocalypse [2]
It turns out that the Schema API doesn't properly understand the difference between different types of integers [3]
I was already concerned that
Schema API lacks the 'time' and 'date' type [4]
I don't really understand why the Drupal team has decided to try and roll it's own database abstraction layer, and make it a core part of the system in the current state.
There seem to be quite a few bugs [5]
Links:
[1] http://www.lullabot.com/articles/drupocalypse-now-or-dangerous-integer-handling-drupal-write-record
[2] http://www.google.co.uk/search?q=Twitpocalypse
[3] http://drupal.org/node/333788
[4] http://drupal.org/node/200953
[5] http://drupal.org/project/issues/search/drupal?text=&assigned=&submitted=&participant=&status[]=Open&priorities[]=1&priorities[]=2&categories[]=bug&version[]=6.x&component[]=database system&issue_tags=