Thanks Aurélien! Can you please give me an example of a case where you'd use a relationship in PostgreSQL, but wouldn't if you were using CouchDB? This might help me understand the approach. (I tried reading about it but couldn't understand.)
Thanks, Ram. On Sat, Jun 13, 2015 at 12:39 PM, Aurélien Bénel <[email protected]> wrote: > >>> > http://docs.ehealthafrica.org/couchdb-best-practices/#one-to-n-relations > >> Is this how I'm supposed to use CouchDB? Because isn't this relational? > I think that if I'm pushing CouchDB to be like PostgreSQL, then maybe I'm > doing it wrong and I should either use PostgreSQL idiomatically or CouchDB > idiomatically. > > > > The fact that CouchDB is a document based database does not mean you > cannot model relations with it when it makes sense. > > Ram, Johannes, I'm afraid there is a term confusion between "relations" > and "relationships". > > The "relation" of "relational databases" is an algebraic notion for > something you would probably call a "table" (see > https://en.wikipedia.org/wiki/Relational_algebra). > > Having no "relations" (aka tables) doesn't mean you don't have > "relationships" (even if you have probably less of them). > > > Regards, > > Aurélien
