Interesting idea--the bulk of my experience with NoSQL is in CouchDB and I love the RESTful access it provides and actually wouldn't want to use cfquery in lieu of that, but maybe it makes more send for Mongo?
Also from a practical standpoint, and this is a question I have since I've heard of UnQL but haven't been following the efforts on it, are there any actual implementations yet on the database side of things or are they still in "what would this spec look like" phase? On Thu, Feb 9, 2012 at 8:18 AM, David Mulder <[email protected]>wrote: > OK, just a random thought I decided to throw up, we already have a fairly > good SQL parser, why wouldn't we use it to implement a subset of UnQL > <http://www.unqlspec.org/display/UnQL/Example+Queries+and+Usage>to query > mongodb. As far as I can see it can't be too hard (as we already have QoQ > and the simpleDB implementations) and we could claim to have the first UnQL > implementation (UnQL will only get more popular and if you drop a mention > of OpenBD integrating the first UnQL implementation on wikipedia that's > bound to have some effects XD ). Aside of that, not sure how useful it > would /really/ be, but I imagine it's quite useful and cool to be able to > access all databases through cfquery. If we would want to do it the > following resources might be quite useful: Link > 1<http://www.mongodb.org/display/DOCS/SQL+to+Mongo+Mapping+Chart>and link > 2 <http://rickosborne.org/download/SQL-to-MongoDB.pdf> . Although of > course the sql would need to be extended with UnQL behavior (hmm, although > that would mean as well that the tag wouldn't be backward compatible as > UnQL will probably still be changing, but that's fine as far as I am > concerned (or it could be separate jar file which will allow independent > updating of the openbd core)). > David Mulder > > -- > online documentation: http://openbd.org/manual/ > google+ hints/tips: https://plus.google.com/115990347459711259462 > http://groups.google.com/group/openbd?hl=en > > Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012 > -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en Join us @ http://www.OpenCFsummit.org/ Dallas, Feb 2012
