Here is my relational database design ER Diagram. The arrows point from FK (foreign key) dependencies. As you can see its a pretty simple database. Everything is centered around User.
Now I also made a ER Diagram for my noSQL database. The brackets indicates which attributes hold documents. In cases where the documents will be other documents - that document's structure is outlined.
As you can see there is a vast difference between these two database styles. The first design , the relational database has multiple tables that are connected by foreign keys. In the second design we have a schema-less design.
Personally I prefer the schema-less design because, I think it is easier to maintain. Also Music School Online is a study on development on the MEAN stack, MEAN means you are using a MongoDB, ExpressJS, AngularJS, NodeJS full-stack framework. For more info see wikipedia.
Here's a video about Dynamo DB.
October 21, 2015
I ran into some problems with the DynamoDb approach. The only way I could find to use it with my AngularJS application would be to use Amazon's Identity Access Management (IAM) services which requires the user to sign-in using Facebook, Google, or another 3rd party authentication provider. I do not want to require users to login using a third-party authentication so I am going to use the traditional MEAN stack way instead. This involves using MongoDB with Mongoose. More info on this to come.
October 23, 2015
Actually, I couldn't figure out how to get mongodb installed locally on Ubuntu 15 (which is what OS I'm using on my dev machine). So I signed up for a free managed hosting service at https://mongolab.com. It turns out they are running a mongo db in AWS...(I didn't know you could do that!)
No comments:
Post a Comment