incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hendrik Jan van Meerveld <haa...@gmail.com>
Subject SQL Query engine with views instead of tables
Date Tue, 17 May 2011 03:32:34 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message