Postgresql AutoDoc has the ability to output XML, which can be loaded into Dia to create a UML diagram of the database (complete with table relations and descriptive information), an HTML form for further detailed information, GraphViz .dot output, and Docbook 4.1 style SGML for inclusion with project documentation as an appendix. It works on any 7.x PostgreSQL-based database.
> I like and use relational databases
> including PostgreSQL, MySQL, Oracle,
> Access, FileMaker, etc. - sometimes in
> conjunction with object/xml databases.
> I beseech and implore others to open
> their minds enough to try object/xml
> databases, find out what they are suited
> for, and perhaps eventually choose to
> use one within the context of a
I have a hard time finding a commercial project which doesn't require statistical reporting to be performed on the data regularly for marketing or sales reasons. Lots of time the data stored fits oo much nicer than relational, but have you ever tried to run stats on some fiddly piece of information near the tail of an object list? Sure, it's fine if you only have a couple thousand of them.
Home projects simply don't get big enough to matter past Referrential Integrity.