-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/30/2011 10:45 AM, Alexey Pechnikov wrote: > Very interesting annonce: > http://www.couchbase.com/press-releases/unql-query-language
It is rather difficult to work out from the spec pages how it differs from regular SQL. Personally I think it is a pointless exercise. The MongoDB query language is a far better fit for JSON data because the queries are expressed as JSON. It also deals well with the nested structure of JSON documents, that items can be lists etc. This page shows some example queries and then shows how operators are implmented: http://www.mongodb.org/display/DOCS/Advanced+Queries BTW if anyone is interested I have a virtual table implementation that lets you access CouchDB from within SQLite. The implementation notes section will be of interest to someone comparing both worlds. http://apidoc.apsw.googlecode.com/hg/couchdb.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk40XqUACgkQmOOfHg372QQ9uACaA6uNmpulkhiH/fvtHGgGlN3q Uy8AoL+VAyex1D89VH1fbhxsqySmNw7k =MqK8 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users