DEV Community

Sourav Mahato
Sourav Mahato

Posted on

SQL Learning...

Before… I was only knowing NoSQL.
I tried MongoDB before.
It was fun… but I feel like I should also know SQL.

So I start exploring… MySQL, PostgreSQL, SQLite.
Finally I choose PostgreSQL.

First days was setup headache
I use Linux (openSUSE) so install was not smooth like Windows.
pgAdmin setup, MySQL Workbench try, database connect…
But when it worked, I feel like small win.

Then I found one gem
VS Code extension “MySQL by Database Client”.
Name is MySQL, but it connect both SQL & NoSQL databases.
Do everything inside VS Code… no need extra apps.
For me, best tool so far.

Learning now SELECT, WHERE, ORDER BY, GROUP BY.
Also different functions, Aggregation, Joins (inner, left, right, full) and many more.
Joins was little mind bending,
but slowly it start making sense.

Also touching ORM like Prisma

Still learning…

Top comments (2)

Collapse
 
ranajitchowdhu profile image
Ranajit Chowdhury

I’m learning SQL and wondering—when do developers usually start using an ORM instead of writing SQL directly?

Collapse
 
sourav_mahato_3900 profile image
Sourav Mahato

I was also in your situation, wondering why ORMs are needed. What I found is that for small projects raw SQL is fine, but as projects grow it gets complex and harder to maintain. That’s when ORMs help they let us write cleaner code and connect with the DB easily, like a framework. Still, knowing raw SQL is important for debugging and switching ORMs later.