You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@couchdb.apache.org by Ian Connor <ia...@gmail.com> on 2008/12/16 20:14:02 UTC
Is there a modified table or quick way to get all that is modified since a given date?
I am trying to see all the documents modified since a given date - or is
sequence number a better idea?
Ideally, I want to update a solr/lucene index and then keep the modified
date or last state that the index was updated. Then on a regular (hourly or
daily) basis, update the index from the changes in couchdb.
One way, would be to know the last update time from the index and get all
changes since that time. However, I noticed that there is this sequence
number kept per database. I assume this might help in some way with
replication in a similar way the modified table works in Lotus Notes. Is
this true, is there a view/query I could run to get all documents touched
after a given sequence number?
--
Regards,
Ian Connor
CTO - pubget.com
Re: Is there a modified table or quick way to get all that is modified since a given date?
Posted by Ian Connor <ia...@gmail.com>.
That works - brilliant! Thanks.
On Tue, Dec 16, 2008 at 2:22 PM, Paul Davis <pa...@gmail.com>wrote:
> Ian,
>
> The update sequence is probably what you're wanting to use. You can
> use it like such:
>
> http://127.0.0.1:5984/db_name/_all_docs_by_seq?startkey=seqid
>
> To get all modified docs since the last time you ran your indexing.
> Generally people have used the db update notification process to know
> when the database changes in conjunction with the update_seq.
>
> This might be of help to you:
>
> http://github.com/davisp/couchdb-lucene/tree/master
>
> HTH,
> Paul Davis
>
> On Tue, Dec 16, 2008 at 2:14 PM, Ian Connor <ia...@gmail.com> wrote:
> > I am trying to see all the documents modified since a given date - or is
> > sequence number a better idea?
> >
> > Ideally, I want to update a solr/lucene index and then keep the modified
> > date or last state that the index was updated. Then on a regular (hourly
> or
> > daily) basis, update the index from the changes in couchdb.
> >
> > One way, would be to know the last update time from the index and get all
> > changes since that time. However, I noticed that there is this sequence
> > number kept per database. I assume this might help in some way with
> > replication in a similar way the modified table works in Lotus Notes. Is
> > this true, is there a view/query I could run to get all documents touched
> > after a given sequence number?
> >
> > --
> > Regards,
> >
> > Ian Connor
> > CTO - pubget.com
> >
>
--
Regards,
Ian Connor
1 Leighton St #605
Cambridge, MA 02141
Direct Line: +1 (978) 6333372
Call Center Phone: +1 (714) 239 3875 (24 hrs)
Mobile Phone: +1 (312) 218 3209
Fax: +1(770) 818 5697
Suisse Phone: +41 (0) 22 548 1664
Skype: ian.connor
Re: Is there a modified table or quick way to get all that is modified since a given date?
Posted by Paul Davis <pa...@gmail.com>.
Ian,
The update sequence is probably what you're wanting to use. You can
use it like such:
http://127.0.0.1:5984/db_name/_all_docs_by_seq?startkey=seqid
To get all modified docs since the last time you ran your indexing.
Generally people have used the db update notification process to know
when the database changes in conjunction with the update_seq.
This might be of help to you:
http://github.com/davisp/couchdb-lucene/tree/master
HTH,
Paul Davis
On Tue, Dec 16, 2008 at 2:14 PM, Ian Connor <ia...@gmail.com> wrote:
> I am trying to see all the documents modified since a given date - or is
> sequence number a better idea?
>
> Ideally, I want to update a solr/lucene index and then keep the modified
> date or last state that the index was updated. Then on a regular (hourly or
> daily) basis, update the index from the changes in couchdb.
>
> One way, would be to know the last update time from the index and get all
> changes since that time. However, I noticed that there is this sequence
> number kept per database. I assume this might help in some way with
> replication in a similar way the modified table works in Lotus Notes. Is
> this true, is there a view/query I could run to get all documents touched
> after a given sequence number?
>
> --
> Regards,
>
> Ian Connor
> CTO - pubget.com
>