Skip to main content

No SQL Databases

Recentely there has been lot of discussion about No SQL databases. Some see it as alternate to SQL database which means writing no SQL to query the database Hence No SQL. Another camp is opinion it is 'Not Only SQL' which basically means you can query the database in more than one way.

These databases are also know as Document Databases as the data is stored as Documents (serialised as JSON objects) . There are three main leading open source Document databases

MongoDB - http://www.mongodb.org/

RavenDB - http://ravendb.net/

CouchDB - http://couchdb.apache.org/

Update: fourth contender, Amazon Simple DB : http://aws.amazon.com/simpledb/
RavenDB and CouchDB stores data as JSON objects while MongoDB uses a twist and stored data as Binary JSON (BSON) objects. Mostly the data is queries either through RestFUL API's using HTTP or through TCP/IP.

These databases also support Indexes and Transactions. For transaction critical applications like banking or realtime system, you better stick with Relational databases. The Document databases are emerging as a serious alternative to less critical system for e.g. say session management, event or error logging.

Comments

Popular posts from this blog

Why there is semicolon at the start of a JavaScript function?

Very often while reviewing the code for my team, I will come across a semicolon at the start of JavaScript function as show below ; (function () { 'use strict'; ...and I often wondered what purpose it served. Guess what. It is an insurance to make sure your script works fine when all other scripts are merged together;  The leading ; in front of immediately-invoked function expressions (iffe) is there to prevent errors when appending the file during concatenation to a file containing an expression not properly terminated with a ;. So there you go. Now you know what that little semicolon is doing there in your code.

What is Event Sourcing?

If you scratching your head and wondering what is Event Sourcing, this is a very good article to start. https://www.erikheemskerk.nl/event-sourcing-awesome-powerful-different/ I couldn't have explained it any better.