I would not do any data validation within the database, but I would certainly perform any other logic within the db.
For example my data validation is first done by JS, then CF, then passed to the db via an SP and the SP and triggers handle the rest of logic, I'm all for it and works quicker than doing it with CF. I still have constraints within the database though, but they are hardly ever put to the test as CF does the data validation. Taco Fleur Tell me and I will forget Show me and I will remember Teach me and I will learn > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Ryan Sabir > Sent: Wednesday, 17 March 2004 6:07 PM > To: CFAussie Mailing List > Subject: [cfaussie] Database programming > > > Hey all, > > Been doing some pretty intense study of MS-SQL server lately > and a few questions came up... > > Basically, a lot of software developers say to put all your > business logic into the database, and to support it by > constraints at the database level, instead of at the > application (i.e. CF) level. This means things like using > triggers to update multiple rows in the database, and having > checks on the validity of foreign keys etc... > > The more I look at this, the more they seem to be saying to > build your entire application on the database server.... so > my question is how should Cold Fusion fit into this? > > With the XML capabilities of SQL Server 2000, it would be > possible to write an entire application in the database, and > link stylesheets to the XML output, completely bypassing CF. > Has anyone tried anything like this? > > I imagine this is not a viable method to build a serious > application, I guess because SQL and VB / C# are more > cumbersome to work with than CF.. but then where do you draw > the line? How do you decide that a particular piece of > business logic is more suited to be run at the database > level, or at the application level? > > Any thoughts? > > > > ----------------------- > Ryan Sabir > Newgency Pty Ltd > 2a Broughton St > Paddington 2021 > Sydney, Australia > Ph (02) 9331 2133 > Fax (02) 9331 5199 > Mobile: 0411 512 454 http://www.newgency.com/index.cfm?referer=rysig > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
