Partner links

The problem with NoSQL databases

Scylladb NoSQL database logo

NoSQL databases, whether they are truly “no SQL” or “not only SQL,” defer differ from relational databases in one major respect; they tend to be easier to work with, and are better suited for use with real-time Web applications.

That’s why major and minor technology outfits are throwing development effort in the NoSQL field.

In the Free Software community, most people working with relational databases only have to contend with either MySQL (now increasingly MariaDB) or PostgreSQL or sometimes even SQLite. However, in the NoSQL arena, there are dozens of options to choose from.

Whether you want to use a Key-value or a document store NoSQL database, the most difficult task might be deciding which one to choose from a very long list of good options. Should it be MongDB MongoDB, Couchbase, CouchDB, Hypertable, HyperDex, Riak, Redis, DynamoDB, SchemafreeDB, or any other from this list or this one. Oracle has even jumped into the fray with Oracle NoSQL.

No matter your choice, this is one thing you gotta know. These databases can be resource intensive. They demand higher CPU and RAM allocation than any relational database. For example, when installing Couchbase, you are informed that you need a system with 4 CPUs and 4 GB of RAM. It will run on less, but when your website gets a traffic boost, be prepared to allocate more resources in a hurry.

And that’s the problem with these NoSQL databases. And that’s the reason most shared Web hosting companies will not offer them to you on a shared hosting account. You need a Cloud or VPS or a dedicated server. I experienced that first-hand when I was trying to use LampCMS to run a question and answer forum. The fact that the developer chose MongoDB as the database to use meant that using it on my shared hosting account was out of the question. And even when I migrated to a VPS service, using the basic VPS package was not going to do it.

Ultimately, using a NoSQL database will have an impact on the adoption of Free Software Web applications that use such a database. If you are trying to develop a Web application, that’s something to think about.

Share:

Facebook
Twitter
Pinterest
LinkedIn

Partner links

Newsletter: Subscribe for updates

Subscribe
Notify of
guest
6 Comments
Inline Feedbacks
View all comments
SDC
SDC
10 years ago

‘MongDB’ lol…

Concerned
Concerned
10 years ago

It would be nice if you ciuld use proper spelling, i.e. “differ” as opposed to “defer”.

As a blogger, I expect not pertinent information, but proper spelling, punctuation, etc… You shiuld be able to present your information without butchering the language.

Concerned
Concerned
Reply to  Concerned
10 years ago

Sorry, meant to say “not only pertinent”.

Concerned
Concerned
Reply to  finid
10 years ago

It was a butchering of my own since this was sent from my phine (sorry “phone”, darn those tiny keyboards and fat fingers!).

Get the latest

On social media

Security distros

Hacker
Linux distros for hacking and pentesting

Crypto mining OS

Bitcoin
Distros for mining bitcoin and other cryptocurrencies

Crypto hardware

MSI GeForce GTX 1070
Installing Nvidia GTX 1070 GPU drivers on Ubuntu

Disk guide

LVM
Beginner's guide to disks & disk partitions in Linux

Bash guide

Bash shell terminal
How to set the PATH variable in Bash
Categories
Archives
6
0
Hya, what do you think? Please comment.x
()
x