We have a placeholder for posts on our profile. But, let's get into filling it in with some real content. We are going to do this by allowing users to post small pieces of content and by having them tied to the user account.
Let's talk through what needs to happen in order for us to save posts to CouchDB and relate them to a user. Before we get into how to do this with CouchDB, let's try to bring it into perspective by looking at how we would do it with MySQL.
If we were modeling this relationship for MySQL (or another RDBMS), it might look similar to the following screenshot:
In a nutshell, this diagram shows a posts
table that has a foreign key user_id
that references the id
of the users table. This one-to-many relationship is a common occurrence in most applications and, in this case, means that one user can have many posts.
Now that we've looked at a familiar diagram, let's look at the same relationship as it pertains to CouchDB.