On Sun, Aug 17, 2003 at 04:20:44PM -0500, Michael Chaney wrote: > I've done database development for 15+ years now.
Cool. That's more than half my lifetime! :) > The simple fact is that storing your business rules in the database > along with the data is the only way to ensure that the data will be > manipulated only in the correct manner. The language (i.e. PL/pgSQL) > is specifically made for dealing with data, and as such does an > excellent job. This is part of what makes me so interested in learning more about stored functions, procedures, triggers, et al. It's already easy to put business rules in the application (eg: in my Zope SQL methods), but then to do a separate parallel front end will require that the same rules be enforced there, and so on. So far I've been consulting the following references for my database work: - "The Practical SQL Handbook: Using SQL Variants", 4th ed., by Judith Bowman, et al. - "Practical SQL: The Sequel", by Judith Bowman. - "An Introduction to Database Systems", 7th ed., by C. J. Date. - On-line PostgreSQL documentation The first two have been very great at introducing me to database basics, and did a really good job at keeping me a step ahead during our introductory database class (CMSC 127) for Computer Science in UP Manila. The PostgreSQL references have answered many of my implementation questions, as PostgreSQL is by DBMS of choice. Date's classic is very good, but it's a little too theoretical at times, or perhaps very technical at the least. This makes it a little challenging as a reference, but it has been great at explaining the theories behind the relational model. Given that my database experience is very limited, I'm in need for suggested reading other than the above to help me get acquainted with the more advanced database topics such as stored functions, procedures, triggers, et al. Any tips? Thank you very much. --> Jijo -- Federico Sevilla III : http://jijo.free.net.ph : When we speak of free Network Administrator : The Leather Collection, Inc. : software we refer to GnuPG Key ID : 0x93B746BE : freedom, not price. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
