Re: Data.js — A Graph Manipulation Framework on top of CouchDB

2011-05-16 Thread Kinley Dorji
Thanks, this sounds great. Will check it out. On May 17, 2011 2:46 AM, "Michael Aufreiter" wrote: Just wanted to let you know we're working on a data manipulation framework for Javascript that exposes a simple API for graph persistence. It uses CouchDB in the backend, and thus turns it into a Gr

Re: SQL Query engine with views instead of tables

2011-05-16 Thread Jim Klo
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 stre

Re: fetching data: how to filter?

2011-05-16 Thread Alexander Gabriel
Thanks Gabor! Alexander Gabriel Am 16.05.2011 09:37 schrieb "Gabor Ratky" : > Alex, > > as with everyone new to CouchDB (and/or NoSQL) I recommend going through the CouchDB: Definitive Guide [1]. It is an indispensable resource and gives you a great overview of CouchDB. It makes it much easier to

Case Insensitive JavaScript Regex

2011-05-16 Thread Matthew Woodward
I'm sure I'm just messing up the syntax but I can't seem to figure out how to add the case-insensitive flag to a JavaScript regex, or at least it's not working in a temporary view. Basically I want to match a couple of individual words within a document field and this works (assuming foo is the wo

SQL Query engine with views instead of tables

2011-05-16 Thread Hendrik Jan van Meerveld
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 Lotu

Data.js — A Graph Manipulation Framework on top of CouchDB

2011-05-16 Thread Michael Aufreiter
Just wanted to let you know we're working on a data manipulation framework for Javascript that exposes a simple API for graph persistence. It uses CouchDB in the backend, and thus turns it into a Graph Database. With Data.js you can: - Query, manipulate and persist data on the client (browser)

querying inside a view function

2011-05-16 Thread Fabio Batalha Cunha dos Santos
Hello all, In a view function, I would to query the database to get a specific info that are stored in another document in the same database. Is it possible considering that the index will not be completely finished? I have the following type of documents in the same database: *document A* - J

Re: Passing _changes feed through a map function?

2011-05-16 Thread Alexander Shorin
No, you couldn't change returned document via filter_view. It just works as regular filter, but it generates "passed" state for documents that have been emitted by view map function at least once. You probably wanted of some kind real-time view result stream? Filter_view call doesn't update view in

Re: Passing _changes feed through a map function?

2011-05-16 Thread Joe Freeman
On 16 April 2011 16:42, Alexander Shorin wrote: > On Sat, Apr 16, 2011 at 7:26 PM, Joe Freeman wrote: >> Is there a way to pass the _changes feed (with include_docs=true) >> through a map function (for example, one that exists as part of an >> existing view)? If not, are there any plans for this?

Re: convert data query into map/reduce function

2011-05-16 Thread Sean Copenhaver
Dang hit the wrong key! Usually the convention is you have some kind of 'type' attribute (so type checking) on your documents or you check that all the fields you are interested in exist (more of the duck approach) in your map function. So perhaps your map function is something like: function(doc

Re: convert data query into map/reduce function

2011-05-16 Thread Sean Copenhaver
Usually the convention is you have some kind of 'type' attribute (so type checking) on your documents or you check that all the fields you are interested in exist (more of the duck approach) in your map function. So perhaps your map function is something like: function(doc){ if (doc.type != 'l

Re: convert data query into map/reduce function

2011-05-16 Thread Marcello Nuccio
Mauro, it is very difficult to help you with so little information. There's no general rules to translate from SQL to couchdb map/reduce views. You can find some hints at http://guide.couchdb.org/draft/cookbook.html Try to explain what you are trying to do. Marcello 2011/5/16 Mauro Fagnoni : > S

Re: convert data query into map/reduce function

2011-05-16 Thread Mauro Fagnoni
Stefan I'm trying to convert this sql query in an identical to the document I created in couchdb. Unfortunately, it is the first time using this database and would like to understand how to translate the query using only the wiki because I have not figured out how to do a lot 2011/5/16 Stefan Math

Re: convert data query into map/reduce function

2011-05-16 Thread Stefan Matheis
Mauro, i think a short example would be really helpful .. especially related to your data-structure .. and the expected behaviour. do you already have an reduce function, but it does not work like you'd have it to? Regards Stefan On Mon, May 16, 2011 at 4:52 PM, Mauro Fagnoni wrote: > Hi all, i

convert data query into map/reduce function

2011-05-16 Thread Mauro Fagnoni
Hi all, i've to convert this sql query into couchdb function but i've some problem with reduce function. Some one can help me?? Many thanks and best regards * SQL QUERY:* SELECT L_RETURNFLAG, L_LINESTATUS, sum(L_QUANTITY)as sum_qty, sum(L_EXTENDEDPRICE) as sum

Re: CouchDB SMTP server integration

2011-05-16 Thread Albin Stigo
I have done this. A very easy and secure way of doing this is to use some kind of "stock" smtp server ie. Postfix and set the mailbox_command to a custom script then inserts the mail into couchdb. http://wiki.kartbuilding.net/index.php/Procmail_-_setup_with_postfix I used python since python has

Re: CouchDB SMTP server integration

2011-05-16 Thread Olafur Arason
The easiest way to integrate it would be using node.js as the front end: https://github.com/joyent/node/wiki/modules#smtp and then storing the content in couchdb. Even adding a listener to _changes to monitor for new messages to be send. If you know erlang you can try integrating something like: h

Re: fetching data: how to filter?

2011-05-16 Thread Gabor Ratky
Alex, as with everyone new to CouchDB (and/or NoSQL) I recommend going through the CouchDB: Definitive Guide [1]. It is an indispensable resource and gives you a great overview of CouchDB. It makes it much easier to understand the concepts and the design behind CouchDB. Afterwards, you can just