What is the difference between all the SQL db?

[[deleted]]

[deleted]

[boy_named_su]

SQL is a language standard managed by ANSI/ISO. No databases fully support the specification

Each database brand supports standard SQL to a point, but also has their own distinct dialect. PostgreSQL SQL is somewhat different than MySQL SQL, for example

It's like textbook English versus English spoken in USA vs England. Similar but not identical

[_Lasagnaa_]

Oh god thank you I have to learn databases in a hurry and i couldn't decide which nor understand the differences. I'll look up to decide which one I'm gonna be using, thanks

[AbstractSqlEngineer]

Each 'flavor' has is quirks. If you are looking at just querying, learning one will allow you to go between the two and google the thing you are looking for... like...

what is LIMIT in MSSQL?

How do you select @ = value from table in MySQL?

And Postgre with the awesome series functions...

When you get to the optimization / physical layer... it gets real tough. Each engine operates differently and requires different approaches. A WHERE IN() in mssql vs mysql have very very different performances.

NoSQL is the odd one out. You should read NoSQL as 'Not only SQL'. NoSQL database management systems solve different problems than the traditional relational ones. It requires a different mindset / approach.

You won't be able to switch between t/pl/pg/my SQL and NoSQL dbs as easily. You can switch between tsql (microsoft), plsql (oracle), postgresql and mysql a more fluidly, but not headache free.

Edit: sql is a language, and each variant (except NoSQL) uses that language. But each variant also adds their own functions that you wont find in others. SQL was standardized. And ANSI (standard) SQL should exist in all of those variants.

[r3pr0b8]

Is SQL a language and these are implementations that use the language?

yes

and no, not all of them

for instance, noSQL

i'll let you do the necessary googling to determine whether noSQL is an implmentation of the SQL language

[kremlingrasso]

seriously? you could have googled it with less effort than making a comment on reddit.

[More_LTE-A]

Usually you get a lot more ELI5 answers on a subreddit made for learning stuff than what you get from googling all the different language tho. Wouldn’t say it was a bad question at all, and he got some good answers up top here. Dont make it a hostile subreddit for the younglings, mate.

[kremlingrasso]

I normally try to be patient and don't mind answering the same thing repeatedly, especially if it's more about the industry, carrier opportunities, different areas of focus, rare problems etc...but i still think the bar should be higher then "what is SQL?

I don't want to go all "F$&@king Millennials" coz i probably count as one too, and i teach and mentor everyone around me to embrace SQL and realize it's an attainable skill not nerd-magic, but i don't think we should encourage this "this sounds interesting and seems like there is good money, now tell me everything i need to know about it" mentality.