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.

Related Post:  Let's Encrypt to offer free, automated and open SSL/TLS domain certificates

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.

Related Post:  Solution to freezing Ubiquity while attempting to dual-boot Ubuntu with Windows 10

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:

Share on facebook
Facebook
Share on twitter
Twitter
Share on pinterest
Pinterest
Share on linkedin
LinkedIn

Hola! Did you notice that LinuxBSDos.com no longer run network ads?  Yep, no more ads from the usual suspects that track and annoy you across the Internet. But since I still need to pay to keep the site running, feel free to make a small donation by PayPal or your favorite cryptocurrency.

  • Bitcoin
  • Ethereum
  • Xrp
  • Bitcoin cash
  • Bitcoin sv
  • Litecoin
  • Binance coin
  • Cardano
  • Ethereum classic
Scan to Donate Bitcoin to bc1qzvlte2m224zkayhdc7fdfjkp2rsgt0l5a496ua

Donate Bitcoin to this address

Scan the QR code or copy the address below into your wallet to send some Bitcoin

Scan to Donate Ethereum to 0x0F4362DFF77F3Ba0Dc637F5f3Eba35D09a2fA60C

Donate Ethereum to this address

Scan the QR code or copy the address below into your wallet to send some Ethereum

Scan to Donate Xrp to r4ggjvL36njsMCYTkJ3S7cTHscPsMsSGQv

Donate Xrp to this address

Scan the QR code or copy the address below into your wallet to send some Xrp

Scan to Donate Bitcoin cash to qrs0dedzp9t55af3nfwypydghp29r0xguy9s20fz2k

Donate Bitcoin cash to this address

Scan the QR code or copy the address below into your wallet to send some Bitcoin cash

Scan to Donate Bitcoin sv to 15K9TLyVDBtLuG9cYvXCX9SSkq9C9oUKHK

Donate Bitcoin sv to this address

Scan the QR code or copy the address below into your wallet to send some Bitcoin sv

Scan to Donate Litecoin to LetJ9QQMb7u2LMZ9Tu6rtHwcBcQFW98fbG

Donate Litecoin to this address

Scan the QR code or copy the address below into your wallet to send some Litecoin

Scan to Donate Binance coin to bnb1ga8trq08ssqepd90v6225nzfgy448pu5pw8gxp

Donate Binance coin to this address

Scan the QR code or copy the address below into your wallet to send some Binance coin

Scan to Donate Cardano to addr1qx2354yw49etstfljpdhwja3ajjlt487lg95vu9ngy2q6vu4rf2ga2tjhqknlyzmwa9mrm997h20a7stgectxsg5p5esq5l7d9

Donate Cardano to this address

Scan the QR code or copy the address below into your wallet to send some Cardano

Scan to Donate Ethereum classic to 0xcD6CC972a2297FcafACDcfE042C55C69516a9264

Donate Ethereum classic to this address

Scan the QR code or copy the address below into your wallet to send some Ethereum classic

Subscribe for updates. Trust me, no spam!

Sponsored links

1. Attend Algorithm Conference, a top AI and ML event.
2. Reasons to use control panel for your server.
3. DHgate Computers Electronics, Cell Phones & more.

Upcoming events

6 Responses

  1. 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.

    1. 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?

      1. 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 Reply to SDC Cancel reply

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

Get the latest

On social media
Via my newsletter

Partner links

1. Attend Algorithm Conference, a top AI and ML event for 2021.
2. Reasons to use control panel for your server.
3. DHgate Computers Electronics, Cell Phones & more.
Hacking, pentesting distributions

Linux Distributions for Hacking

Experts use these Linux distributions for hacking, digital forensics, and pentesting.

Categories
Archives

The authors of these books are confirmed to speak during

Algorithm Conference

T-minus AI

Author was the first chairperson of AI for the U.S. Air Force.

The case for killer robots

Author is the Director of the Center for Natural and Artificial Intelligence.

Why greatness cannot be planned

Author works on AI safety as a Senior Research Scientist at Uber AI Labs.