Hi all, I'm using Couchdb for a new website and loving it. The two tier setup with the database directly sending the HTML to the client seems elegant to me.
One thing that I mis is SQL queries. Somebody will probably say that I need to learn a new way of thinking, but I've already been using Lotus Notes (another noSQL database) for 3 years and I'm still missing SQL. I've also recently noticed others on this mailing list that would benefit from SQL queries: - Alexander Gabriel: "Fetching data: how to filter<http://www.google.nl/url?sa=t&source=web&cd=2&ved=0CCEQFjAB&url=http%3A%2F%2Fmail-archives.apache.org%2Fmod_mbox%2Fcouchdb-user%2F201105.mbox%2F%253CBANLkTik8K6-ndbU9FFE%3DWO-HhcHhUFjejA%40mail.gmail.com%253E&rct=j&q=site%3Ahttp%3A%2F%2Fmail-archives.apache.org%2Fmod_mbox%2Fcouchdb-user%2F%20Fetching%20data%3A%20how%20to%20filter&ei=IuvRTaT9CdGa-wbeoaXICg&usg=AFQjCNGkk2mJ-mrIrMyqbAAy4iJ3B5Hjdg&sig2=a5J_L6IDGtWBbq__4gng5Q&cad=rja> " - Mauro Fagnoni: "Convert data query into map/reduce function<http://www.google.nl/url?sa=t&source=web&cd=3&ved=0CCwQFjAC&url=http%3A%2F%2Fmail-archives.apache.org%2Fmod_mbox%2Fcouchdb-user%2F201105.mbox%2F%253CBANLkTimvXY0BUoZQ74Z8JPUZGMs4RwPCGw%40mail.gmail.com%253E&rct=j&q=site%3Ahttp%3A%2F%2Fmail-archives.apache.org%2Fmod_mbox%2Fcouchdb-user%2F%20Convert%20data%20query%20into%20map%2Freduce%20function&ei=b-vRTaFahef6BqmwrOUK&usg=AFQjCNGwmdgGY_A0f_K-V-_taPVCThWX2w&sig2=Teio1B7yQrUPQManBwdxCQ&cad=rja> " - Fabio Batalha: "Querying inside a view function<http://www.google.nl/url?sa=t&source=web&cd=1&ved=0CBkQFjAA&url=http%3A%2F%2Fmail-archives.apache.org%2Fmod_mbox%2Fcouchdb-user%2F201105.mbox%2F%253CBANLkTik05ozk49Y-916efxTmDbqc5dZE9A%40mail.gmail.com%253E&rct=j&q=site%3Ahttp%3A%2F%2Fmail-archives.apache.org%2Fmod_mbox%2Fcouchdb-user%2F%20Querying%20inside%20a%20view%20function&ei=qevRTfyaBo6e-Qb_6u3UCg&usg=AFQjCNHqK_A1hrA9Z0j0a0hcuhKK-Qf0fw&sig2=aKCwGNxwwlIhoR2OLmiI7A&cad=rja> " I found somebody who actually made a front-end SQL engine for Couchdb: http://legitimatesounding.com/blog/NoSQL_meet_SQL.html And there is a popular noSQL database that actually does queries: MongoDB<http://www.mongodb.org/display/DOCS/Querying> All this makes me ask the question: "Can SQL language not be added to Couchdb?" Views are after all very much like tables, so could an existing SQL query engine not be rewritten to query tables in Couchdb? So my question is, does anybody have some thoughts about this? Would it be possible? Would it be difficult to implement in Erlang? Kind regards, Hendrik Jan
