Postgres has a feature called Rules. Rules are somewhat like triggers, except that instead of running as rows are written to the database, Rules are run once when a query is submitted to the database, and can rewrite or add to the query.
You can use them to make arbitrarily complex writable views, for example. And they're generally considerably faster than doing the same thing with triggers. I've been writing some rules recently and am pretty pleased with the results. I could do a briefish (15 or 20 mins) presentation about how rules work and an example of their use at the next meeting, if anyone is interested. We're also using hstore, which is a feature in Postgres that lets you have a key-value store as the value of a field. I could talk about that also or instead. -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby
