Guys guys guys. Conversation had right just now. A PM from the company I’m freelancing for just said

“We need to move away from SQL server and shift all the data to MongoDB. I don’t want it to take more than a month tops”

Verbatim. No context. Nothing. The website is for a small time supply chain software that’s been chugging along for a decade now with spaghetti code everywhere.

How do I even respond? The other guy who works with me sent 😂😂😂 to me privately and now is offline lol wtf

"The system is tied down to the current infrastructure like an anchor to a ship"

We will have to redesign the ship to move that anchor.

Really is this Mongo so trendy? It's a f*****g json. How can it be faster?

@davide devs find relationships hard.

We are thinking about dropping this project. This PM has been a pain in the ass for a while and this might be the last straw.

@davide it’s so hip it’s so nosql reeeeeeeeeeeee

@davide Oooh! Shiny!

That's it.

@C0D4 "devs find relationships hard."

ooh, i see what you did there

@C0D4 you made my day 😂😂😂

@webdev am I wrong though?

@davide I'm glad someone got it😁

@davide It depends on utilization.
I find CosmosDB (Or monfoDB, same shit) very suitable for something like User Preferences.

Because you don’t care about each individual preference, usually you want them all for a user. This also allows to add new user settings on the fly.

Yes, you can create a table SQL with user id and JSON second column containing same thing. But mongo/cosmos offers some more flexibility. Ex : Get all users, having access to feature X and have value Y for threshold of feature Z.

Ex of usage : Custom notifications. “Get all users, who activate this notification option with these parameters”.

(Yes, I’m aware you can parse JSON in SQL server, but I still prefer Cosmos for these type of things)

But for raw data, I still prefer SQL, especially if it has more than 10000 lines.

@NoToJavaScript Great explication, thanks!

@davide In benchmarks I've done with loads of inserts and selects, mongo was definitely faster!