What do you hate about it?
Discussion
i think what i dislike about it is that it feels ancient to write. bc it is ancient. i also have to use t-sql daily which doesnāt help.
Maybe it's just me, but i love writing and optimizing every query i do
that probably has something to do with why i dislike it some much. iām super noobish and inefficient when writing it.
That's just a practice thing. At some point, you learn how to write efficient #SQL. However, this requires going through the journey of bending the human mind into thinking in #SQL.
Interesting. SQL might have been invented a long time ago but itās pretty mainstream today.
In my own estimation, about 80% of software projects use SQL, and the rest is divided between NoSQL and other exotic datastores that donāt conform to either.
i actually am just starting to learn nosql/mongo and itās already starting to make more sense to me. i guess that means my brain is pretty chaotic haha.
Learning to use document oriented databases & #NoSQL felt like a huge liberation to me.
Recently, I got into #Redis, as well & it just makes so much sense, while #SQL always seemed like this alien way of thinking, you have to bash your brain first, to understand the point.
i have never heard of redis but i will 100% look into it.
That's because of optimisation & using the most common API, not because it's so great.
If databases weren't all about optimisation, nobody would ever use raw #SQL, especially without some ORM.
You made the point. Some things just don't age well & in my experience, the only people who "like" it, do not really like it, they just have been using it for decades & are too used to it.
While #SQL makes inherent sense, it's still not something you would want to use nowadays.