Trigger Happy

07Apr09

Now that I’ve freed my thinking from core data, I’m beginning to get my teeth into SQLite. It features triggers a trick that means that I can perform some lovely automatic denormalisation of the data model to keep quick access to the current version of any cell whilst maintaining a full audit trail. I’m really having fun with Bliss and the good news about the SQLite triggers is that they are completely cross platform unlike the cocoa presentation layer. Don’t get me wrong, I like cocoa, but I’m acutely aware that I’ll need to rewrite the presentation layer for each platform, so the more that I can pack into the database itself, the better.

Advertisement

Filed under: Bliss, Internals   |  Leave a Comment