Re: startkey endkey problem

2013-04-16 Thread Stanley Iriele
sure...i was using a rewrite handler to rewrite /:game/channels/:year/:month/:day/ though these are strings they work for my case and they map to db/_design/ddoc/_list/bats/viewname?startkey=[":game",":year",":month",":day"]&endkey=[":game",":year",":month",":day",{}] this worked just fine befor

Re: startkey endkey problem

2013-04-16 Thread Dave Cottlehuber
On 17 April 2013 00:29, Stanley Iriele wrote: > nevermind..I found the cause...It is clearly a couhdb bug...but I found a > work around for it that seems to make everyone happy..if anyone gets this > error...or even sees this message I'll happily follow up Hi Stanley, Glad to hear you found a so

Couchdb 1.3 Mac OS X version crashes after 25836 doc updating

2013-04-16 Thread Gennady Denisov
Hello everyone. I try to update large amount of documents. On 25837th document I got crash. I have 5 remaining docs to update. The error is https://www.friendpaste.com/5kxHLcrBI9vJxrGTTokIZD. I'd appreciate your help. Thanks in advance. Best regards, Gennady

Re: startkey endkey problem

2013-04-16 Thread Stanley Iriele
nevermind..I found the cause...It is clearly a couhdb bug...but I found a work around for it that seems to make everyone happy..if anyone gets this error...or even sees this message I'll happily follow up On Mon, Apr 15, 2013 at 8:00 PM, Stanley Iriele < siri...@breaktimestudios.com> wrote: > Hi

Re: Replication and sequence id question

2013-04-16 Thread Paolo Negri
Replications would be initiated from touchdb, typical case being a mobile application ships with a primed database or with an empty database, then when a connection is available the mobile application would then connect to the server in order to synchronize the database and receive updated data fro

Re: Replication and sequence id question

2013-04-16 Thread Robert Newson
Yes. The couchdb replicator stores the checkpoint at both source and target. I don't know touchdb beyond its goal of being couchdb-on-mobile, so I will defer to Jens as to whether the replicator in touchdb also does this. Are you initiating replication on couchdb or touchdb? B. On 16 April 2013 1

Re: Replication and sequence id question

2013-04-16 Thread Paolo Negri
Thanks again for the answer, I'm now confused by the role of the checkpoint and its storage, let's say that I have a mobile app that has been downloaded on 100k devices and I'm using touchdb to sync my db to the devices, does this mean that each device will need to store a checkpoint on my server s

Re: Decimal values in JSON

2013-04-16 Thread Sander Dijkhuis
Hi Elisiano, thanks for the link! Just for reference, the discussion seems to have resulted in this explanation in the CouchDB docs: http://couchdb.readthedocs.org/en/latest/json-structure.html#number-handling On Apr 16, 2013, at 14:17 , Elisiano Petrini wrote: > Hi Sander, > there has been

Re: Decimal values in JSON

2013-04-16 Thread Elisiano Petrini
Hi Sander, there has been an extended discussion on this list a couple of months ago about float numbers and their representation. Have a look at http://mail-archives.apache.org/mod_mbox/couchdb-user/201302.mbox/% 3Ckfvbob$c6p$1...@ger.gmane.org%3E and follow the thread from there (sorry I was

Re: Distinct values with range

2013-04-16 Thread Andrey Kuprianov
We've solved the problem using Jim's approach, but at a small cost: we had to round up dates to the beginning of each month (not day, as he suggested). So when we ran a reduce with grouping, then output of a view shortened to a much smaller amount of rows, which we then fed down to list function, w

Decimal values in JSON

2013-04-16 Thread Sander Dijkhuis
Hi, I’m working on a CouchDB design doc that provides a Cosm-like API to work with sensor measurements. I know that the CouchDB guide recommends using strings to represent decimal values in JSON[1], but was curious to try using the { "field": 4.2 } format as it gives a cleaner API. I figured th

Re: Distinct values with range

2013-04-16 Thread muji
That depends upon your requirements and data. If the requirement is to find data across *any* date range then it will potentially be slow, however if you only every need to be able to query with a maximum date range of say a year (ie, your date ranges do not go over a year) then you could use filte

Re: Replication and sequence id question

2013-04-16 Thread Robert Newson
Hi Paolo, The checkpoint is stored in the database at source and target, so couchdb will fail to find that document on server B and so it will start from update sequence 0. B. On 16 April 2013 10:06, Paolo Negri wrote: > Hi Robert > > On Tue, Apr 16, 2013 at 10:05 AM, Robert Newson wrote: >> H

Re: Distinct values with range

2013-04-16 Thread Andrey Kuprianov
Muji, what happens if you have several hundred transactions per day in a variety of different countries over several years? Then your view processing is going to be very slow. We are looking for a near real-time solution On Tue, Apr 16, 2013 at 5:42 PM, muji wrote: > I believe you need to query

Re: Distinct values with range

2013-04-16 Thread muji
I believe you need to query with startkey and endkey as complex keys (assuming -MM-DD): startkey=[startyear,startmonth,startday] endkey=[endyear,endmonth,endday,{}] Then you can extract the countries from the key returned with each row (it will be the last element in the array). You will also

Re: GeoCouch performance: any suggestion to improve it ?

2013-04-16 Thread Volker Mische
Hi Luca, On 04/16/2013 12:57 AM, Luca Morandini wrote: > Folks, > > I built a test rig to assess the performance, geo-spatial-wise, of > PostgreSQL vs CouchDB, and I have found out that -on average- CouchDB > takes double the time of PostgreSQL when completing a spatial query. That's cool, I've

Re: Replication and sequence id question

2013-04-16 Thread Paolo Negri
Hi Robert On Tue, Apr 16, 2013 at 10:05 AM, Robert Newson wrote: > Hi Paolo, > > No, couchdb (and touchdb) will be just fine if you fail over to a > different server. What will happen is that the replication from server > B to your mobile client will start from update sequence 0 (as you will > ha

Re: Replication and sequence id question

2013-04-16 Thread Robert Newson
Hi Paolo, No, couchdb (and touchdb) will be just fine if you fail over to a different server. What will happen is that the replication from server B to your mobile client will start from update sequence 0 (as you will have no previous checkpoint). The replication process will then check whether ea

Replication and sequence id question

2013-04-16 Thread Paolo Negri
Dear list I have a question related to couchdb replication, let me walk you through the scenario I have 2 servers server A and server B on both A and B I'm running couchdb B is configured to replicate all dbs from A I also have one mobile client that uses touchdb to sync data with one database