>From: "Kees Nuyt" <k.n...@zonnet.nl> >Thursday, November 11, 2010 10:34:51 AM > >Stored procedures don't enforce business rules by >themselves. Constraints and triggers do. >To enforce business rules stored as procedures in the >database, one would need an access system which prevents >direct modification of table data. >As an embedded database SQLite definately is in an other >niche of the DBMS market. >Stored procedures can often be replaced by INSTEAD OF >triggers on views, that's quite powerful.
OK, they can't truly enforce business rules but nothing enforces good design on my C++ code either. What it does is allow the business rules to be packaged as a complete unit with the data and I claim that would be better design and more maintainable over the life of the project. Jeff Archer Nanotronics Imaging jsarc...@nanotronicsimaging.com <330>819.4615 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
