incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "matt j. sorenson" <m...@sorensonbros.net>
Subject Re: StackOverflow round-up (help needed!)
Date Thu, 21 Mar 2013 20:44:28 GMT
does ASFBot speak xmpp??...
* https://github.com/emjayess/screencaps/blob/master/stacksguru-xmpp.png
* 
http://stackapps.com/questions/345/stacksguru-a-near-realtime-bot-for-all-stack-exchange-sites


On Thu, Mar 21, 2013 at 12:07 PM, Noah Slater <nslater@apache.org> wrote:

> Thanks for the help guys. I'll take a look at this sometime.
>
>
> On 11 March 2013 11:39, david martin <david.martin@lymegreen.co.uk> wrote:
>
> > On 11/03/13 10:02, Elisiano Petrini wrote:
> >
> >> Hi,
> >>     they do have an API ( https://api.stackexchange.com/**docs/<
> https://api.stackexchange.com/docs/>) but I
> >> couldn't find an updated python library for it (py-stockexchange reads
> >> 1.1 API version whereas the latest is 2.1).
> >>
> >> Nonetheless, their API return json data, hence you can very easily parse
> >> it with python (or whatever other language supporting json).
> >>
> >> To see the kind of json returned (or tune the query) you can visit
> >> https://api.stackexchange.com/**docs/search#order=desc&sort=**
> >> creation&tagged=couchdb&**filter=default&site=**stackoverflow&run=true<
> https://api.stackexchange.com/docs/search#order=desc&sort=creation&tagged=couchdb&filter=default&site=stackoverflow&run=true
> >
> >>
> >> This is a very simple example of how to put the pieces together in
> >> python (far from being usable in production, but already useful to avoid
> >> manual searches):
> >>
> >> [elisiano@pc-elisiano ~/Projects ]$ cat couchdb_stack_overflow.py
> >> #!/usr/bin/env python2
> >>
> >> import urllib2
> >> from StringIO import StringIO
> >> import gzip
> >> import json
> >>
> >> url="""https://api.**stackexchange.com/2.1/search?**
> >> order=desc&sort=creation&**tagged=couchdb&site=**stackoverflow<
> https://api.stackexchange.com/2.1/search?order=desc&sort=creation&tagged=couchdb&site=stackoverflow
> >
> >> """
> >>
> >> req=urllib2.Request(url)
> >> req.add_header('Accept-**Encoding', 'gzip') # should be the default
> >>
> >> res=urllib2.urlopen(req)
> >>
> >> buf=StringIO(res.read())
> >> f=gzip.GzipFile(fileobj=buf)
> >> data=json.loads(f.read())
> >>
> >> ### print only unanswered questions
> >> for question in data['items']:
> >>     if not question['is_answered']:
> >>        print "%s => %s" % (question['title'], question['link'])
> >>
> >>
> >>
> >> [elisiano@pc-elisiano ~/Projects ]$ ./couchdb_stack_overflow.py
> >> couchdb map/reduce view: counting only the most recent items =>
> >> http://stackoverflow.com/**questions/15320834/couchdb-**
> >> map-reduce-view-counting-only-**the-most-recent-items<
> http://stackoverflow.com/questions/15320834/couchdb-map-reduce-view-counting-only-the-most-recent-items
> >
> >> couchDB sorting complex key =>
> >> http://stackoverflow.com/**questions/15259910/couchdb-**
> >> sorting-complex-key<
> http://stackoverflow.com/questions/15259910/couchdb-sorting-complex-key>
> >> How to specify individual database location in couchdb? =>
> >> http://stackoverflow.com/**questions/15236632/how-to-**
> >> specify-individual-database-**location-in-couchdb<
> http://stackoverflow.com/questions/15236632/how-to-specify-individual-database-location-in-couchdb
> >
> >> Query Ad-Hoc (Temporary) Views with ektorp =>
> >> http://stackoverflow.com/**questions/15220020/query-ad-**
> >> hoc-temporary-views-with-**ektorp<
> http://stackoverflow.com/questions/15220020/query-ad-hoc-temporary-views-with-ektorp
> >
> >> Google closure on CouchDB =>
> >>
> http://stackoverflow.com/**questions/15212983/google-**closure-on-couchdb<
> http://stackoverflow.com/questions/15212983/google-closure-on-couchdb>
> >> couchdb conflict identical document =>
> >> http://stackoverflow.com/**questions/15208208/couchdb-**
> >> conflict-identical-document<
> http://stackoverflow.com/questions/15208208/couchdb-conflict-identical-document
> >
> >> What database(s) for storing user data, and also support targeting
> >> queries? =>
> >> http://stackoverflow.com/**questions/15177068/what-**
> >> databases-for-storing-user-**data-and-also-support-**targeting-queries<
> http://stackoverflow.com/questions/15177068/what-databases-for-storing-user-data-and-also-support-targeting-queries
> >
> >> CouchDB Security in a Lightweight Stack? =>
> >> http://stackoverflow.com/**questions/15163643/couchdb-**
> >> security-in-a-lightweight-**stack<
> http://stackoverflow.com/questions/15163643/couchdb-security-in-a-lightweight-stack
> >
> >> CouchDB: synchronize between slave databases =>
> >> http://stackoverflow.com/**questions/15159186/couchdb-**
> >> synchronize-between-slave-**databases<
> http://stackoverflow.com/questions/15159186/couchdb-synchronize-between-slave-databases
> >
> >> CouchDB &quot;virtual&quot; database, that combines 2 databases into
1
> >> =>
> >> http://stackoverflow.com/**questions/15158869/couchdb-**
> >> virtual-database-that-**combines-2-databases-into-1<
> http://stackoverflow.com/questions/15158869/couchdb-virtual-database-that-combines-2-databases-into-1
> >
> >> CouchDB didn&#39;t start in Windows XP? Anybody has same experince? =>
> >> http://stackoverflow.com/**questions/15142066/couchdb-**
> >> didnt-start-in-windows-xp-**anybody-has-same-experince<
> http://stackoverflow.com/questions/15142066/couchdb-didnt-start-in-windows-xp-anybody-has-same-experince
> >
> >> How to retrieve the couchDB data by given limit(start_limit,end_limit)
> >> using cradle in node.js? =>
> >> http://stackoverflow.com/**questions/15105002/how-to-**
> >> retrieve-the-couchdb-data-by-**given-limitstart-limit-end-**
> >> limit-using-cra<
> http://stackoverflow.com/questions/15105002/how-to-retrieve-the-couchdb-data-by-given-limitstart-limit-end-limit-using-cra
> >
> >>
> >>
> >>
> >>
> >>
> >>
> >> On Sat, 2013-03-09 at 11:08 -0800, Mark Hahn wrote:
> >>
> >>> Is this automated?  If not then it should be.  I assume stackoverflow
> has
> >>> an api.
> >>>
> >>>
> >>> On Sat, Mar 9, 2013 at 6:17 AM, Noah Slater <nslater@apache.org>
> wrote:
> >>>
> >>>  Dear community,
> >>>>
> >>>> Here are the latest StackOverflow questions about CouchDB. These might
> >>>> be a
> >>>> good opportunity to earn some StackOverflow reputation and help out
> the
> >>>> wider CouchDB community at the same time!
> >>>>
> >>>> CouchDB Security in a Lightweight Stack?
> >>>>
> >>>> http://stackoverflow.com/**questions/15163643/couchdb-**
> >>>> security-in-a-lightweight-**stack<
> http://stackoverflow.com/questions/15163643/couchdb-security-in-a-lightweight-stack
> >
> >>>>
> >>>> CouchDB didn't start in Windows XP? Anybody has same experince?
> [closed]
> >>>>
> >>>> http://stackoverflow.com/**questions/15142066/couchdb-**
> >>>> didnt-start-in-windows-xp-**anybody-has-same-experince<
> http://stackoverflow.com/questions/15142066/couchdb-didnt-start-in-windows-xp-anybody-has-same-experince
> >
> >>>>
> >>>> Thanks,
> >>>>
> >>>> --
> >>>> NS
> >>>>
> >>>>
> >>
> >>
> >>  Analysis of StackOverflow api output JSON via Erlang view and
> map-reduce
> > of the key value structure in Erlang terms.
> > This outputs what is emitted by the erlang view of the JSON
> > program code at Re: Using the Erlang view server to Educate in CouchDB
> >
> > Key, Grouping  Reduce on   exact Value
> > first 2 of 29 answers to "erlang" and "couchdb"
> > Mon 11 Mar 2013 11:06:35 GMT
> > [["_id"], "**04d7a389c5335d2c22c993b7e83081**6e"]      1
> > [["_id"], "**04d7a3d7abd825c55cc06f50255574**20"]      1
> > [["_rev"], "1-**27e61d976ff7989cae2965eb2a5670**3e"]      1
> > [["_rev"], "1-**361ec33082b9208e612ac5af3fcb1d**6e"]      1
> > [["has_more"], true]      2
> > [["items", [0], "answer_count"], 0]      2
> > [["items", [0], "creation_date"], 1362908290]      1
> > [["items", [0], "creation_date"], 1362996678]      1
> > [["items", [0], "is_answered"], false]      2
> > [["items", [0], "last_activity_date"], 1362919660]      1
> > [["items", [0], "last_activity_date"], 1362998116]      1
> > [["items", [0], "last_edit_date"], 1362919660]      1
> > [["items", [0], "last_edit_date"], 1362998116]      1
> > [["items", [0], "link"], "http://stackoverflow.com/**
> > questions/15320834/couchdb-**map-reduce-view-counting-only-**
> > the-most-recent-items<
> http://stackoverflow.com/questions/15320834/couchdb-map-reduce-view-counting-only-the-most-recent-items
> >"]
> >      1
> > [["items", [0], "link"], "http://stackoverflow.com/**
> > questions/15335898/export-**data-from-mnesia-to-excel<
> http://stackoverflow.com/questions/15335898/export-data-from-mnesia-to-excel
> >"]
> >      1
> > [["items", [0], "owner", "accept_rate"], 0]      1
> > [["items", [0], "owner", "display_name"], "francoi mocci"]      1
> > [["items", [0], "owner", "display_name"], "wasperen"]      1
> > [["items", [0], "owner", "link"], "http://stackoverflow.com/**
> > users/2095691/francoi-mocci<
> http://stackoverflow.com/users/2095691/francoi-mocci>"]
> >      1
> > [["items", [0], "owner", "link"], "http://stackoverflow.com/**
> > users/2153440/wasperen <http://stackoverflow.com/users/2153440/wasperen
> >"]
> >      1
> > [["items", [0], "owner", "profile_image"], "http://www.gravatar.com/**
> > avatar/**8dc5891d8dbe48ed1580a66aab57c0**9b?d=identicon&r=PG<
> http://www.gravatar.com/avatar/8dc5891d8dbe48ed1580a66aab57c09b?d=identicon&r=PG
> >"]
> >      1
> > [["items", [0], "owner", "profile_image"], "http://www.gravatar.com/**
> > avatar/**b9331d61a59e58b9de331a4e6c0dd4**75?d=identicon&r=PG<
> http://www.gravatar.com/avatar/b9331d61a59e58b9de331a4e6c0dd475?d=identicon&r=PG
> >"]
> >      1
> > [["items", [0], "owner", "reputation"], 6]      2
> > [["items", [0], "owner", "user_id"], 2095691]      1
> > [["items", [0], "owner", "user_id"], 2153440]      1
> > [["items", [0], "owner", "user_type"], "registered"]      2
> > [["items", [0], "question_id"], 15320834]      1
> > [["items", [0], "question_id"], 15335898]      1
> > [["items", [0], "score"], 0]      1
> > [["items", [0], "score"], 1]      1
> > [["items", [0], "tags", [0]], "excel"]      1
> > [["items", [0], "tags", [0]], "mapreduce"]      1
> > [["items", [0], "tags", [1]], "couchdb"]      1
> > [["items", [0], "tags", [1]], "erlang"]      1
> > [["items", [0], "tags", [2]], "mnesia"]      1
> > [["items", [0], "title"], "couchdb map/reduce view: counting only the
> most
> > recent items"]      1
> > [["items", [0], "title"], "export data from mnesia to excel"]      1
> > [["items", [0], "view_count"], 10]      1
> > [["items", [0], "view_count"], 14]      1
> > [["items", [1], "accepted_answer_id"], 15321245]      1
> > [["items", [1], "answer_count"], 1]      1
> > [["items", [1], "answer_count"], 2]      1
> > [["items", [1], "creation_date"], 1362907130]      1
> > [["items", [1], "creation_date"], 1362932917]      1
> > [["items", [1], "is_answered"], true]      2
> > [["items", [1], "last_activity_date"], 1362911343]      1
> > [["items", [1], "last_activity_date"], 1362938582]      1
> > [["items", [1], "last_edit_date"], 1362907356]      1
> > [["items", [1], "link"], "http://stackoverflow.com/**
> > questions/15320693/using-**couchdb-as-interface-is-it-**appropriate-way<
> http://stackoverflow.com/questions/15320693/using-couchdb-as-interface-is-it-appropriate-way
> >"]
> >      1
> > [["items", [1], "link"], "http://stackoverflow.com/**
> > questions/15324572/erlang-**orddictsize-function-for-**record<
> http://stackoverflow.com/questions/15324572/erlang-orddictsize-function-for-record
> >"]
> >      1
> > [["items", [1], "owner", "accept_rate"], 76]      1
> > [["items", [1], "owner", "accept_rate"], 97]      1
> > [["items", [1], "owner", "display_name"], "lost_with_coding"]      1
> > [["items", [1], "owner", "display_name"], "Valentin Heinitz"]      1
> > [["items", [1], "owner", "link"], "http://stackoverflow.com/**
> > users/298206/valentin-heinitz<
> http://stackoverflow.com/users/298206/valentin-heinitz>
> > "**]      1
> > [["items", [1], "owner", "link"], "http://stackoverflow.com/**
> > users/513034/lost-with-coding<
> http://stackoverflow.com/users/513034/lost-with-coding>
> > "**]      1
> > [["items", [1], "owner", "profile_image"], "http://www.gravatar.com/**
> > avatar/**2911c6ad709ff05272e49a21df247d**a2?d=identicon&r=PG<
> http://www.gravatar.com/avatar/2911c6ad709ff05272e49a21df247da2?d=identicon&r=PG
> >"]
> >      1
> > [["items", [1], "owner", "profile_image"], "http://www.gravatar.com/**
> > avatar/**713b314a279977bd57a97b13c6e3c9**54?d=identicon&r=PG<
> http://www.gravatar.com/avatar/713b314a279977bd57a97b13c6e3c954?d=identicon&r=PG
> >"]
> >      1
> > [["items", [1], "owner", "reputation"], 506]      1
> > [["items", [1], "owner", "reputation"], 636]      1
> > [["items", [1], "owner", "user_id"], 298206]      1
> > [["items", [1], "owner", "user_id"], 513034]      1
> > [["items", [1], "owner", "user_type"], "registered"]      2
> > [["items", [1], "question_id"], 15320693]      1
> > [["items", [1], "question_id"], 15324572]      1
> > [["items", [1], "score"], 0]      1
> > [["items", [1], "score"], 2]      1
> > [["items", [1], "tags", [0]], "erlang"]      1
> > [["items", [1], "tags", [0]], "interface"]      1
> > [["items", [1], "tags", [1]], "couchdb"]      1
> > [["items", [1], "tags", [1]], "size"]      1
> > [["items", [1], "tags", [2]], "mustache"]      1
> > [["items", [1], "tags", [2]], "record"]      1
> > [["items", [1], "tags", [3]], "ordereddictionary"]      1
> > [["items", [1], "title"], "Erlang: orddict:size() function for record?"]
> >    1
> > [["items", [1], "title"], "Using CouchDB as interface. Is it appropriate
> > way?"]      1
> > [["items", [1], "view_count"], 23]      1
> > [["items", [1], "view_count"], 27]      1
> > [["items", [2], "accepted_answer_id"], 15318766]      1
> > [["items", [2], "answer_count"], 1]      2
> > [["items", [2], "creation_date"], 1362887368]      1
> > [["items", [2], "creation_date"], 1362913090]      1
> > [["items", [2], "is_answered"], true]      2
> > [["items", [2], "last_activity_date"], 1362887951]      1
> > [["items", [2], "last_activity_date"], 1362916747]      1
> > [["items", [2], "link"], "http://stackoverflow.com/**
> > questions/15318711/how-do-i-**add-a-new-key-value-pair-to-**
> > couchdb-using-cradle-node-js<
> http://stackoverflow.com/questions/15318711/how-do-i-add-a-new-key-value-pair-to-couchdb-using-cradle-node-js
> >"]
> >      1
> > [["items", [2], "link"], "http://stackoverflow.com/**
> > questions/15321466/erlang-**using-gb-tree-functions-**
> > within-beam-executable-record-**operations<
> http://stackoverflow.com/questions/15321466/erlang-using-gb-tree-functions-within-beam-executable-record-operations
> >"]
> >      1
> > [["items", [2], "owner", "accept_rate"], 80]      1
> > [["items", [2], "owner", "accept_rate"], 97]      1
> > [["items", [2], "owner", "display_name"], "lost_with_coding"]      1
> > [["items", [2], "owner", "display_name"], "streetlight"]      1
> > [["items", [2], "owner", "link"], "http://stackoverflow.com/**
> > users/1209702/streetlight<
> http://stackoverflow.com/users/1209702/streetlight>"]
> >      1
> > [["items", [2], "owner", "link"], "http://stackoverflow.com/**
> > users/513034/lost-with-coding<
> http://stackoverflow.com/users/513034/lost-with-coding>
> > "**]      1
> > [["items", [2], "owner", "profile_image"], "http://www.gravatar.com/**
> > avatar/**6385b493b6448615358774f4df3982**cd?d=identicon&r=PG<
> http://www.gravatar.com/avatar/6385b493b6448615358774f4df3982cd?d=identicon&r=PG
> >"]
> >      1
> > [["items", [2], "owner", "profile_image"], "http://www.gravatar.com/**
> > avatar/**713b314a279977bd57a97b13c6e3c9**54?d=identicon&r=PG<
> http://www.gravatar.com/avatar/713b314a279977bd57a97b13c6e3c954?d=identicon&r=PG
> >"]
> >      1
> > [["items", [2], "owner", "reputation"], 506]      1
> > [["items", [2], "owner", "reputation"], 577]      1
> > [["items", [2], "owner", "user_id"], 513034]      1
> > [["items", [2], "owner", "user_id"], 1209702]      1
> > [["items", [2], "owner", "user_type"], "registered"]      2
> >
> > --
> > David Martin
> >
> >
>
>
> --
> NS
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message