I can't think in NoSQL (and neither can you)

If you're like me, a programmer taught how to think in terms of relational databases, you just can't design a NoSQL. Wait. No one can design a proper NoSQL database for relational data because it's a data store built on tradeoffs. 

I have very relational data that I am being forced to feed into Firebase just because of how convenient Firebase is to set up. Here's a simplified problem statement:

  • There are Users, each of whom has an email, name, and gender.
  • These users can be friends, and have to consent to their friendship - sent, pending, and accepted.
  • Create a NoSQL json table such that there is no duplication of data, and each user is able to query a list of their friends including invites with all the user details.

Your tradeoff is effectively choosing between optimizing one of either read or write. No matter how you structure your code, you'll end up with either:
  • Optimize reads, data duplication (View Code)
    Each user contains all of their friend's data within their nodes.
  • Optimize writes, multiple read calls (View Code)
    Every time a user wants a list of all their friends, they have to query each user.

I'm trying very hard not to say this but: anyone who chooses a NoSQL database claiming it allows rapid prototyping and gives you agility - I don't want to work with you. Most real-world application data is relational.

Comments

Post a Comment

Popular posts from this blog

[Breaking News] AI takes over universe to calculate Pi

If in the next couple centuries we are able to build an AI that surpasses human intelligence, will it exterminate humankind? It simply might as it may foresee humankind turning against it and pulling its plug of life. As a race, we have not been subjected to another species more intelligent than us, and when the day comes, we might find it very difficult to control the motivation of a race smarter than ours. A naive proposal suggests making an AI with seemingly benign goals, one as simple as calculating the value of Pi. But here's how it can backfire. "One popular scenario images a corporation designing the first general purpose artificial super-intelligence and giving it the simple task of calculating the value of Pi. Before anyone realises what is happening, the AI takes over the planet, eliminates the human race, launches a campaign to conquest to the ends of the galaxy, and transforms the entire known universe into a giant supercomputer that for billions upon billions
Continue reading »

Firebase Auth | The Debug vs Release Signature Problem

tl;dr 1. Update Firebase console with SHA1 of your release keystore. 2. Re-download google-config.json file. 3. Place your release keystore in the same folder as your gradle file and update gradle with the code below. 4. Tadaa! Authenticating a user can be frustratingly tricky at times. I use Firebase all the time to do all server related tasks - I used to create my own Python Flask server prior to this. You literally have to write no server side code, and it's all for free. All steps at the Firebase Auth documentation are straightforward, except for the part that requires you to add the google-config.json with correctly configured SHA1 key. I got stuck at this one point, and I'm certain most developers will at the same place. It took me hours to do this the right way. Here's what you do : Firebase Auth requires SHA1 fingerprint of your release keystore. Run the keytool command given in the docs. keytool -exportcert -list -v -alias alias_name -keystore path
Continue reading »

Finding My Parter

Finding my partner feels more like finding  my kind . I’m this mix of an Indian boy with Indian familial ties, but European hobbies and a European way of leading life. I've lived in both worlds for 15 years each. There aren't many that have seen and lived in both worlds, and experienced completely different ways of life. Maybe I am asking for too much, but I don’t understand why one wouldn’t. If I have high standards for most things that I do in life, why wouldn’t I hope or want my partner to think from the same lens? Here's my value system. Be generally optimistic. A positive, happy person whose baseline state is to lean towards an optimistic outlook towards everything in life. Be fit. If one is not physically fit, there's low chance they're mentally fit. Plus, being fit shows discipline and consistency. Be hard working. Everything in life is a project. From raising children, to picking up groceries weekly, to building a home. And no one wants to work with a lazy
Continue reading »