> I'm searching for projects that would serve as good PostgreSQL examples. In
Excellent idea.
> Ideally the project would have the following characteristics:
[...]
- good use of connection pooling
- good use of read-only vs. read-write connections (emulated
via grants or as in 7.4devel)
- use of notifies (dynamic/non-dynamic notify names)
- good solutions to standard problems:
- auditing
- special purpose ref-counting
- cross-database queries with dblink
- tsearch
- i18n for strings in the database
- "fixed nr. of rows" in a table
- ...
This should not only serve as helpful advocacy material but
also provide for best-of-breed examples to check one's own
design and code against.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346