I recently set up a dojox.data.CouchDBRestStore in combination with a dojox.grid.DataGrid. Initially the data get displayed as they should. But if you scroll down the grid no new values get retrieved from the couchdb. Adding a row index to the store shows that the grid is aware of the total count of the documents within the database as ...
We are currently considering a change from Postgres to CouchDB for a usage monitoring application. Some numbers: Approximately 2000 connections, polled every 5 minutes, for approximately 600,000 new rows per day. In Postgres, we store this data, partitioned by day: t_usage {service_id, timestamp, data_in, data_out} t_usage_20100101 i...
I'm new to CouchDB and am just trying to assess its usefulness in common tasks. One such task is in generating reports. My problem is this: If I have a document structure like this: { "_id": "29763f342ab34fd7b579fd4546aaed93", "_rev": "3-f56dccaa214f3e9fce1e1e3e32e710a2", "client_id": "sse", "outcomes": [ { ...
Hi guys, I'm really trying hard to understand this new concept after working so long with relational databases... Can anyone explain how I should go about storing say, a category hierarchy? in a relational DB, I'd have: Category: CategoryId ParentCategoryId Name or something of that nature.. ...
I want to use the current version of bundler (there have been quite some changes from 0.8 to 0.9) to mange the gems of my Rails app. First I created a Gemfile in the root of the app folder and added all the needed gems to it. Then I placed (as recommended in the manual) the following code to my config/environment.rb: begin # Require t...
Hi! I'm willing to give MongoDB and CouchDB a serious try. So far I've worked a bit with Mongo, but I'm also intrigued by Couch's RESTful approach. Having worked for years with relational DBs, I still don't get what is the best way to get some things done with non relational databases. For example, if I have 1000 car shops and 1000 ca...
I am build an autocomplete that searches off of a CouchDB View. I need to be able to take the final character of the input string, and replace the last character with the next letter of the english alphabet. (No need for i18n here) For Example: Input String = "b" startkey = "b" endkey = "c" OR Input String = "foo" startkey = "fo...
I've seen a couple of apps using this DesktopCouch thing, What are the differences between CouchDB and DesktopCouch??? ...
Is there a way to implement captcha on a couchdb app? I am writing a signup page on my application and I want to have protection against spam signups. It seems that I would have to do that with a server alongside couchdb. I was hoping to avoid that. Any ideas? ...
I'm looking for a document-oriented db with a Ruby API that has SQLite-like properties: self-contained, serverless, zero-configuration. Are there light alternatives to MongoDB or CouchDB? Is RDDB a possibility? If not, what are the best paths to walk then? ...
How to create a complex map reduce function in couchdb to span a view over multiple documents with same attribute names to give back a single json object? What is the most efficient way to manage this? Is a nested set/source algorithm suitable for couchdb (changes are very write intensive)? ...
I am working on an application that runs on multiple clients that talk to one main MySQL database. Additionally, we have a web application that uses the same MySQL database. Due to latency issues, all clients will have to run their own local MySQL database which should be a copy of the main MySQL database. The web application remains to...
I'm vainly attempting to learn how to use object databases. In database textbooks the tradition seems to be to use the example of keeping track of students, courses and classes because it is so familiar and applicable. What would this example look like as an object database? The relational database would look something like Student ...
StackOverflow lets you search for posts by tags, and lets you filter by an intersection of tags, e.g. ruby x mysql x tags. But typically it's inefficient to retrieve such lists from MySQL using mulitple joins on the taggings. What's a more performant way to implement filter-by-multiple tag queries? Is there a good NoSQL approach to thi...
Are there anyone who can help me out on how to connect a codeigniter-application with couchDB? I have tried to find drivers or libraries, but without any success. What can I do to make it work? Thanks! ...
Hi! I have started to try out noSQL databases now and are currently testing out couchDB. Seems like a good solution, but I really get some headache when I follow available examples on how to create views (queries) to select documents from a database and sort them. Everything I can find is regarding JavaScript and it would be great to ta...
CouchDB, version 0.10.0, using native erlang views. I have a simple document of the form: { "_id": "user-1", "_rev": "1-9ccf63b66b62d15d75daa211c5a7fb0d", "type": "user", "identifiers": [ "ABC", "DEF", "123" ], "username": "monkey", "name": "Monkey Man" } And a basic javascript design documen...
Hello, what is the best practice to sort/order multiple documents by user defined order (position) in CouchDB? Solutions I thought about: Every document has a "position" value, starting from 1 to n. The view would emit this value. Problem: If one document is sorted, all other documents with a greater position have to updates. This co...
Can I order the result of a view by the value, returned by reduced? { "rows": [ {"key":"bob","value":2}, {"key":"john","value":3}, {"key":"zztop","value":1} ] } I wanna a result like this: { "rows": [ {"key":"zztop","value":1}, {"key":"bob","value":2}, {"key":"john","value"...
Sorry if this question is somewhat subjective. I am new to 'could store', 'distributed store' or some concepts like this. I really wonder what do they have in common and want to get an overview on all of them. What do I need to prepare if I want to write a product similar to this? ...