On Wed, 2003-07-23 at 16:55, Steve Crawford wrote: > I'm searching for projects that would serve as good PostgreSQL examples. In > fact it would be nice to have a place on the PostgreSQL web page that > featured some good examples. (If such a place exists and I missed it, please > let me know.) > > Ideally the project would have the following characteristics: > > -Open-source (naturally, it's hard to use as an example otherwise) > > -Good database structure/normalization > > -Good error detection/recovery > > -Appropriate use of back-end capabilities including functions, triggers and > rules > > -Good security practices > > -Appropriate use of special PostgreSQL features (non-standard data types, > inheritance, etc.) >
http://gforge.org/ fork of the sourceforge codebase, now much improved http://www.sql-ledger.com/ double entry accounting system http://openacs.org/ enterprise level web community system Robert Treat -- PostgreSQL :: The Enterprise Open Source Database ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match