couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jim Klo <jim....@sri.com>
Subject Re: SQL Query engine with views instead of tables
Date Tue, 17 May 2011 06:10:44 GMT
You effectively get close to that if you use CouchDB + Lucene. 

Alas not a 'native' solution either, but there is a very well defined query language for Lucene.

I've wondered as well how difficult it would be to build a query optimizer that would effectively
be a dynamic list.   One of the strengths relational db's have is the optimizer - essentially
predetermining what key to use before scanning. Couch effectively has this albeit manually
via lists. Maybe I'm missing something myself but, my biggest gripe about lists though is
output in JSON feels like a kludge vs the method used for views. Output mechanisms should
have some cardinality (I think I should be able to emit in a list vs having to JSONify output).


- Jim 



On May 16, 2011, at 8:32 PM, Hendrik Jan van Meerveld <haaiee@gmail.com> wrote:

> 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
View raw message