Wrap Up – Week 8 of 7 databases in 7 weeks

by Buddy Lindsey on March 26, 2012

It has been a long journey getting through this book, 8 weeks actually. I can honestly say I have learned a heck of a lot and know I can be more effective in the future. For the last couple of years I have felt like I have had a giant gaping hole in my knowledge when it came to different types of databases, and this book has really helped me start to fill in that hole.

Impressions of the Book

While the book has strong and weak parts, overall it did a great job at giving just enough information for you to learn each database. The only negative of the book is it isn’t longer, more detailed, and doesn’t have more in-depth examples of data to store, but that is because I like details to be extensive as possible even if they are too much. The book accomplished its goal well and was surprisingly short based on everything I learned.

What I learned

Day 3 of Redis Chapter

I hinted at really liking Day 3 of the Redis chapter, and it making me a better developer. What I was not telling you is that Day 3 was all about using 3 separate databases Redis, CouchDB, and Neo4j to build a single application. It was all built on Node.js so it can give you a real look at the breadth of technology it can be used with.

What was very interesting is how it was used in conjunction with everything, and it was well layed out showing yet another way to use the databases. I’ll be honest it did not go into as much detail as I wish it would have, but it did just enough to drive the point home, which was the point.

Types of NoSQL Databases

I never realized there were so many different types of NoSQL databases. Part of that was because of everyone calls it NoSQL, and the other part of it was because I never looked beyond MongoDB. The greatest thing about reading this book is I am not only aware of the different types of databases, but I am starting to understand when a good scenario is to use them in. It gives me a better leg up for the future when I might run into scenarios to need them since NoSQL is becoming more important.

To the Future

MongoDB

For the immediate future I am going to start off on a project and use MongoDB. I am choosing it because I feel the most comfortable with it, and I am not sure which type of NoSQL store I should use. I do however know for this project NoSQL is the optimal data store over an RDBMS, which is a win in and of itself. I kind of feel like I should use a key value pair store, but I figure since this is a side project for fun if I choose wrong it really doesn’t matter since it will be fun and I will learn.

Neo4j

Believe it or not by the end of the year I will start in on using Neo4j for another project, and I will bring you along for the ride. I have had an idea for an application for a long time to help with my learning Japanese. The problem is how I envision the project and its complexity I have always had trouble with the database schema. After working with Neo4j it hit me that it might be the correct fit for my specific needs, maybe. I will be experimenting with it and using it with Node.js as well.

Conclusion

I find the fact that I am now able to analyze the needs of my project and start the process of choosing a data-store in an informed manner to be a huge win for me. I walked in with no knowledge and a lot of confusion, and have emerged with a better understanding of how to solve some of my problems with a couple of projects. Problems I didn’t know exactly what they were or how to solve them before, I only “felt” the problem.

I do recommend this book to anyone interested in learning more, and about, databases. To be honest it was a bit much to try and do each chapter every week, and try to understand it fully. If you are at least a little bit familiar with NoSQL DB’s you should be fine, but if you were like me and had no understanding at all then take more time. Other than that get the book, learn and become a better developer so you can make even cooler stuff.

Related Posts:

{ 0 comments }

It’s My Birthday – What Would You Like?

by Buddy Lindsey on March 23, 2012

Today is my 27th birthday, yay. So I was hoping you could give me a present in the form of a comment answering two questions.

How can I improve my blog?

  1. What can I do to make this blog better for you, the reader?
  2. What content would you like to see? Any specific ideas or technologies? or rants?

I am trying to improve my blog so people enjoy it more any comments and feedback are very welcome. Have a great my birthday.

Related Posts:

  • No Related Posts

{ 3 comments }

Redis – Week 7 of 7 Databases in 7 Weeks

March 19, 2012

The best was saved for last, at least that is how I see it, and in multiple ways. I will be honest I was a bit surprised Redis was a Key Value pair based data store, but I guess I should not have been considering its efficiency. As the book is winding down I wasn’t [...]

Read the full article →

Neo4J – Week 6 of 7 Databases in 7 Weeks

March 12, 2012

What a mind bender, especially when structure is all your brain is used to. I really never thought too deeply about the idea of a graph based databases. However, why not? We have other types so a graph based database seems inevitable. The question is how am I going to understand it? Impressions of the [...]

Read the full article →

CouchDB – Week 5 of 7 Databases in 7 Weeks

February 27, 2012

“If I knew then what I know now” is what comes to my mind after reading this chapter. CouchDB was the first NoSQL DB I tried, and it made very little sense at all so I gave up using it. However, I wish I had read this chapter when I first started so things would [...]

Read the full article →

MongoDB – Week 4 of 7 Databases in 7 Weeks

February 20, 2012

MongoDB seems to be the database that everyone flocks to when they are starting out with a NoSQL Database, and for good reason. This week was a bit more interesting going through the book as I had to look a lot of stuff up on my own since a few assumptions were made by the [...]

Read the full article →

Is a Developer Pay Wall Coming to OSX?

February 16, 2012

Openness and Apple aren’t always two words which go together, to the chagrin of many of us developers who use OSS technologies. While I think OS X is *nix done right for the desktop, recent moves are scaring the crap out of me. I am also now wondering in the future are we going to [...]

Read the full article →

HBase – Week 3 of 7 Databases in 7 Weeks

February 13, 2012

We are on the second NoSQL database of the book. I had personally never heard of HBase before this, but it is an impressive Database. It also provides a good look at different programming techniques and stacks. Fortunately, HBase is fairly simple to get introduced to. Impressions of the Book The humor in the book [...]

Read the full article →

Riak – Week 2 of 7 Databases in 7 Weeks

February 6, 2012

Jumping into the first foray of NoSQL Riak was a bit daunting, but thanks to the guidance of some great authors I came out the other end of the chapter relatively unscathed, and maybe a bit wiser. Of all the NoSQL databases the Key Value store seemed the most useless to me, well I was [...]

Read the full article →

PostgreSQL – Week 1 of 7 Databases in 7 Weeks

January 30, 2012

Relational Databases are great databases, and a good staple of any development stack when flexible querying ability is needed. Currently my main RDBMS is MySQL, but since the acquisition by Oracle I have been a bit turned off by it. Something always rubbed the wrong way as it was, but the purchase made me really [...]

Read the full article →