>

ChompingTheBit

$title =

CST 363 – Week 7

;

$content = [

As we approached the end of CST 363 we switched gears from SQL to MongoDB.

Overall, its hard to decide which type of database I like working with more, and ultimately there is no “best” choice. Both SQL and NOSQL databases have their uses, and many of the worlds most used websites/apps use a combination of SQL and NOSQL databases.

NOSQL databases like MongoDB or Redis are use a key value store which stores data in a JSON object. This ends up being a lot more flexible compared to the tables, columns, and rows that SQL databases use. This flexibility may be faster or slower depending on the data you are holding in your database.

In general, it is said that NOSQL databases scale better horizontally, while SQL databases scale better vertically. What this means is that for an object that stores many different types of data, from from many different sources or users, NOSQL will probably be a better choice.

Once all that messy data from different NOSQL databases is cleaned up, it might make sense to put it all in a SQL database where it can be quickly and easily retrieved (if the database architect did their job!). Using a real life example, Twitter uses redis for individual user timelines, but SQL for storing the hundreds of millions of tweets that are posted every day.

];

$date =

;

$category =

;

$author =

.

;

$previous =

;

$next =

;