Relational databases have worked perfectly for managing data for decades,so unless you can make a clear business case for switching, you might want to consider cleaning up the existing database instead of invoking the learning curve and complexity of moving to a NOSql database. Simply because the existing system is creating a lot of tables doesn't mean that NOSql is the answer. Especially if you have no knowledge of how to do use it.
That being said, there is a good comparison of the various NOSql options here: http://en.wikipedia.org/wiki/Comparison_of_structured_storage_software For most basic website that require NOSql, I use MongoDB. On Fri, Nov 1, 2013 at 9:07 AM, Kris Sisk <[email protected]> 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:357018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
