Hi Kris, One thing to consider is the flexibility that SQL 12 has regarding XML data structures. You can store all kinds of things in it dynamically and retrieve that data, search on it, etc.
Of course, it warps the minds of those of us brought up in the EF Codd approach to relational database theory, more than a little bit. But it does work well. That said, is there a reason a newer design wouldn't be able to follow the prior developer's precedent? --Ben On 11/1/2013 9:07 AM, Kris Sisk wrote: > I realize I'm a little behind the curve on this. In my defense this is the > first time since becoming a full time developer that I've dealt with data > that didn't come from spreadsheets, so I've not really had a reason to look > very far into NoSQL other than just far enough to understand what it was. > I've played with Mongo a little on my personal web server (which runs PHP but > not CF so that I can keep those skills fresh while I spend my days working > with CF), but I've not had any serious projects involving unstructured data. > > The project I have now involves replacing an existing web app. Currently the > application follows its initial design, circa 2003, well before it's original > designer (my predecessor) had heard of NoSQL. The app works with data by > creating new tables for each data structure it needs. After being in use for > 10 years we have somewhere around 1000 tables. Clearly this is an app that > begs for a NoSQL solution. > > Which brings me to my question. What's the best NoSQL database for use with > ColdFusion? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:357020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
