I'm about to write some production code against a mid-sized, fully normalized database. Any lessons learned in those kinds of environments would be of interest.
i'm not sure you'll find many things for direct copy-pasting, but here's an sql abstraction layer that has a postgresql backend:
http://dwim.hu/darcsweb/darcsweb.cgi?r=HEAD%20hu.dwim.rdbms;a=headblob;f=/so...