After I've used nosql for a while, I'm phobia to sql, because i doubt my table design skill

I've been using SQL databases for 3 years and I'm still phobic to SQL because the format fucking sucks and the language serves no one but the gods of compatibility.

The thing isn't versatile enough so it's been made Turing complete with variable depth recursion, but the format was deliberately designed not to be Turing complete so now anything can be done with SQL but it doesn't feel like the intended way.

@lbfalvy orm is the way

@molaram I'm not a dba

Same. My new place is sql server but before that I did manage to have 2 years of using mongo and I’m a big believer in it.
It’s not the answer to every problem but for the back end of the code I found mongo lined up with having a well thought out domain model very well.
And in my previous company the devs who struggled with it tended to also be the ones who also wrote spaghetti domain models and hard to follow code.
They relied on sql more for it validating foreign keys than because they were actually good at using it

NoSQL is a non defined term, still. Wish people would finally stop using this bullshit bingo term like it meant something.

MongoDb is a document oriented database...

And you still need a valid and sane form of design for a document oriented database, otherwise you'll end up with the same klingon pain sticks up your arse like with any other database / programming language / ... .

As soon as you hit the advanced level, document oriented database become quite complex.

Edit: not that SQL is easy - but I'm really tired of the argument that document / kV databases are easier than SQL.

I like SQL as long as there is no ORM involved or an ORM with the philosophy to stay as close as possible to SQL principles.

But for me, doesn't matter if it's KV / document / relational / hierarchical / graph oriented database - if the person who designed it, didn't pour dedication and knowledge in it, it will suck endlessly.

Reason I'm a fan of no refactoring and instead rewriting if possible. When the data layer is shit, everything will be shit.