The DB is dedicated to the APP. So they can be looked at as a stack that make up the application as a whole. So yes, the DB is simply the datastore for the app and nothing else is using the DB.
The only downside I could think of with using the DB is that if we switched databases, it'd all have to be rewritten. I'll have control of both the app and the DB, and they won't be separated, so I'm thinking that it comes down to performance. On Wed, May 23, 2012 at 3:20 PM, Alex Skinner <[email protected]> wrote: > > Depends on your thoughts is your db being shared by multiple apps or is > your cfml app the app and db just the data store. If the former then store > procedures may be the option in the db, if not there are some source > control benefits of the logic being in the app as a Cfc dao layer. > > My 2p > > A > > On Wednesday, 23 May 2012, Jason Allen <[email protected]> wrote: > > Hi Guys, > > I've ported my apps database from MS-SQL to mySQL and so far so good. > > Since I've got most of my scripts working right, I'm now looking at the > best way to create those scripts as a function. > > ie createUser('username','firstname','lastname','email') rather than > some spaghetti cfml that does it using 1,000 lines of code. > > The adHoc scripts work fine, but I'm certain there is some performance > to gain by building many of these functions into a CFC, or building it > directly into the mySQL DBMS. > > What's the best way? My first guess is that there's more to gain by > doing it directly in the DBMS. Just call the db user defined function via > CFQUERY and rather than spelling the sql code out, use the function. And I > also wonder, that in the case of creating an API, having the functions > directly in the DBMS might allow the API in some instances to bypass OpenBD > altogether? > > > > Thoughts? > > -Jason > > > > -- > > online documentation: http://openbd.org/manual/ > > http://groups.google.com/group/openbd?hl=en > > > > -- > Alex Skinner > Managing Director > Pixl8 Interactive > > Tel: +448452600726 > Email: [email protected] > Web: pixl8.co.uk > > > > -- > online documentation: http://openbd.org/manual/ > http://groups.google.com/group/openbd?hl=en > -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
