What is NoSQL good for?

I’m versed enough in SQL and RDBMS that I can put things in the third normal form with relative ease. But the meta seems to be NoSQL. Backends often don’t even provide a SQL interface.

So, as far as I know, NoSQL is essentially a collection of files, usually JSON, paired with some querying capacity.

What problem is it trying to solve?
What advantages over traditional RDBMS?
Where are its weaknesses?
Can I make queries with complex WHERE clauses?

Chat

ColloidalOP
link
fedilink
English
arrow-up
5·
24 hours ago
Right, and you’d never do a search for messages with a particular reaction, so there’s no functionality loss is this use case.

Learn Programming

learn_programming

Create a post

You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]

Posting Etiquette

Ask the main part of your question in the title. This should be concise but informative.
Provide everything up front. Don’t make people fish for more details in the comments. Provide background information and examples.
Be present for follow up questions. Don’t ask for help and run away. Stick around to answer questions and provide more details.
Ask about the problem you’re trying to solve. Don’t focus too much on debugging your exact solution, as you may be going down the wrong path. Include as much information as you can about what you ultimately are trying to achieve. See more on this here: https://xyproblem.info/

Icon base by Delapouite under CC BY 3.0 with modifications to add a gradient

Visibility: Public

This community can be federated to other instances and be posted/commented in by their users.

36 users / day
69 users / week
111 users / month
197 users / 6 months
535 local subscribers
1.74K subscribers
102 Posts
520 Comments
Modlog