I know that I can retrieve a specific revision of a document via http://localhost:5984/mydb/626b345059c2a54fbe8b8009ba87a409?rev=2-3696048776 but this assumes I know the revision number 2-3696048776. How can I list all available revisions for document 626b345059c2a54fbe8b8009ba87a409? ...
Why is CouchDB so popular among non-relational databases? ...
I'm trying to use CouchDB with HTML/standalone REST architecture. That is, no other app server other than CouchDB and ajax style javascript calling CouchDB. It looks like cross scripting is a problem. I was using Cloudkit/Tokyo Cabinet before and it seems like the needed callback function was screwing it up in the URL. Now I'm trying ...
I am contemplating the design of an event logging system based on couchDB. What would be a good way of storing each event? one document with events as 'attachments' one document per event one document per event-type, events as attachments Other? ...
CouchDB access as a rest service seems insecure. Anyone can hit the database and delete/add documents once it is exposed. What is the best strategy to secure the CouchDB? ...
I'm trying to create a database in couchdb, which has an admin user/password set, using couchbeam. I've set my credentials in couchdb's local.ini file and restarted. My code to create a db is: couchbeam:start(), Params = #couchdb_params{username="test" ,password="pass"}, Connection = couchbeam_server:start_connection_link(Params), Db = ...
I am playing around with CouchDB Replication and I'm wondering how to copy a local database of name "myDatabase" to a remote database on www.mySite.com that requires ssh access, and rename it to "myRemoteDatabase". How do I do that? I am able to login to both the local and remote servers and run: curl -X GET http://localhost:5984/ .....
Using CouchDB, I currently have a document which represents an idea, you can rate this idea. Every idea is one document and every rating is a different document. I am doing this like this to avoid concurrent access problems when people are rating an idea. My documents look like that (I have simplified them): An idea: { "_id": "idea1"...
I am new to CouchDB and learning about it. I did not come across CouchDB support for referential integrity. Can we create a foreign key for a field in the CouchDB document? For e.g. Is it possible to ensure a vendor name used in a order document is available in the vendor database? Does CouchDB support referential integrity? And Is i...
I am looking at implementing a CouchDB server to provide ad-hoc searching of some metadata that we store for an internal business operation. We store a number of "attributes" like size, source, submit date, and URL for the "jobs" in our internal process. This is all well and good in our relational database, but our users would like to ...
I'm looking a way to automate schema migration for such databases like MongoDB or CouchDB. Preferably, this instument should be written in python, but any other language is ok. ...
Hi, I'm currently designing an architecture for a web-based application that should also provide some kind of image storage. Users will be able to upload photos as one of the key feature of the service. Also viewing these images will be one of the primary usages (via web). However, I'm not sure how to realize such a scalable image sto...
We all know that for relational databases it is best practice to use numerical IDs for the primary key. In couchdb the default ID that is generated is a UUID. Is it best to stick with the default, or use an easily memorable identifier that will be used in the application by the user? For example, if you were designing the stackoverflow...
What's the best way to store large JSON files in a database? I know about CouchDB, but I'm pretty sure that won't support files of the size I'll be using. I'm reluctant to just read them off of disk, because of the time required to read and then update them. The file is an array of ~30,000 elements, so I think storing each element separ...
I'm considering using MongoDB or CouchDB on a project that needs to maintain historical records. But I'm not sure how difficult it will be to store historical data in these databases. For example, in his book "Developing Time-Oriented Database Applications in SQL," Richard Snodgrass points out tools for retrieving the state of data as ...
I haven't got my hands dirty yet with neither CouchDB nor MongoDB but I would like to do so soon... I also have read a bit about both systems and it looks to me like they cover the same cases... Or am I missing a key distinguishing feature? I would like to use a document based storage instead of a traditional RDBMS in my next project. I...
I'm having problem getting the right results in my coordinate system. To explain my system, I have this simple database that have x_axis, y_axis and name columns. I don't need to get all the data, I just need to display some part of it. For example, I have a coordinate system that have 10:10(meaning from x_axis -10 to 10 and from y_ax...
I've run a series of somewhat brutal tests against CouchDB 0.10 and it handled itself well (ex. the server's netstack caved in but best I can tell CouchDB was still functioning ). Unfortunately none of that really matters if I can't convince clients and employers to allow me to use it*. Common fears I've heard. "It's only Version .10...
I found out that RCS for models is an interesting problem to solve in the context of data persistence. They are several solution using the django ORM to achieve this django-reversion and AuditTrail each of which propose their own way to do it. Here is the model (in django-model-like format) which I would like to have revisions : class ...
I keep seeing references to the idea that "CouchDB may not be the best tool in every situation." This is good to know, but unfortunately also applies to every technology. What would be much more helpful is a description of how CouchDB was tried on a project and subsequently abandoned for a traditional SQL database. If you've tried Couc...