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 Re: SQL Query engine with views instead of tables
Date Tue, 17 May 2011 16:50:52 GMT
Thank you for the reply Jim,

I'll look into Lucene someday.
Agree with you that the method for views feels more elegant that for lists.

Hendrik

On 17 May 2011 08:10, Jim Klo <jim.klo@sri.com> wrote:

> 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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message