The problem with NoSQL databases

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.

Related Posts

Free Technology Academy and Free Software Foundation partner Free Software Foundation (FSF) News: The Free Technology Academy (FTA) and the Free Software Foundation (FSF) announced today their partnership in t...
Joli OS is being discontinued Joli OS is being discontinued. That the latest news about Joli OS, a desktop distribution that has since been replaced with a browser-based platfor...
Deploying a scalable Jenkins cluster with Docker and Rancher Containerization brings several benefits to traditional CI platforms where builds share hosts: build dependencies can be isolated, applications can be...
After a “legal spat” with Pocket, Poche has been renamed to Wallabag Poche has been renamed to Wallabag. If Poche is a new on one you, it is an Open Source read-later application competing with non-free versions like...
Let’s Encrypt to offer free, automated and open SSL/TLS domain certificates Come Summer 2015, webmasters not already using SSL/TLS certificates to encrypt their website's traffic will be able to do so for free using a single p...
More Freedom Necessary as Top Developers Abandon iPhone Apple's ridiculous iPhone app approval process has hit a new low, with rejections for “ridiculing public figures" and using Apple's own APIs to access...

We Recommend These Vendors and Free Offers

ContainerizeThis 2016 is a free, 2-day conference for all things containers and big data. Featured, will be presentations and free, hands-on workshops. Learn more at ContainerizeThis.com

Launch an SSD VPS in Europe, USA, Asia & Australia on Vultr's KVM-based Cloud platform starting at $5:00/month (15 GB SSD, 768 MB of RAM).

Deploy an SSD Cloud server in 55 seconds on DigitalOcean. Built for developers and starting at $5:00/month (20 GB SSD, 512 MB of RAM).

Want to become an expert ethical hacker and penetration tester? Request your free video training course of Online Penetration Testing and Ethical Hacking

Whether you're new to Linux or are a Linux guru, you can learn a lot more about the Linux kernel by requesting your free ebook of Linux Kernel In A Nutshell.


6 Comments

  1. ‘MongDB’ lol…

  2. Concerned

    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

      Sorry, meant to say “not only pertinent”.

    • Thanks for the correction. That seems to happen everywhere. I spot similar grammar errors myself on other blogs and try to read and re-read before clicking the Publish button, but still manage to miss something like the one you found.

      By the way, it’s not that I don’t know the difference, just that, well… errors happen.

      Talking about “proper spelling” and “butchering,” is your misspelling of could and should by design or did you just commit butcherings of your own?

      • Concerned

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

Leave a Comment

Your email address will not be published. Required fields are marked *

*