SQL appreciation thread

Can we take a moment to appreciate the most underrated language? SQL.
Easy to use, easy to understand, its a
masterpeice

Attached: 1465112541179.jpg (400x400, 25K)

is it really a language
it feels more like a script

I wasnt sure wether to call it a language or a script. But the wikipedia describes it as a language.
>SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system
I love it either way

Attached: 1530073830879.png (1210x1190, 116K)

True SQL is a script, but most implementations are turing complete.

>queries are almost always automated in modern software
>still have to use this bulky, awkward, text processing interface to perform them

Attached: 1514234475503.png (645x614, 83K)

It's easy to understand when you're doing basic CRUD.
Ask people to join some tables, then aggregate the results by month, then sum the values of similar transactions. They go full retard.

that doesnt seem that hard, maybe 6 lines of sql a most

>>still have to use this bulky, awkward, text processing interface to perform them
Its almost written in plain english. It cant get any less awkward than that

Attached: 1519871654843.png (813x444, 55K)

>2018
>using non json structured database

SQL is almost too easy, you get people that have no idea what's going on inside a database joining 6 tables with no index and then wondering why production is slow.

Attached: 1491846264660.jpg (764x720, 81K)

doing anything beyond a simple SELECT * FROM TABLE; can get really complicated really fast.

>is it really a language
>it feels more like a script
False dichotomy is false.

Sql is an API

NoSQL is a meme.
SQL4lyfe

time to learn hibernate my infantile friends

Attached: hibernate.png (884x176, 13K)

Postgre is the way to go bitchez

SQL queries get jit compiled

Relational datatables are just nice.

2006 called, they want their ORM back. Everybody in 2018 is using entity framework grandpa

Same thing, kiddo

>official specs are paywalled
>every rdbms invents their own flavor of the language
>SELECT comes before FROM which makes it impossible for editors to suggest relevant names
aside from that it's good

Yeah select before from really doesn't make sense

it does make sense because one of the goals of the language was to resemble the way you would express it in plain English.
that doesn't mean it was a good choice though

From this container I want to select x
I want to select x from this container
I think it depends on what you're doing but neither make 100% sense all the time

are you some kind of brainlet?
use views and joins you retard, just like you'd use functions on other programs

SQL databases are a good solution to many problems. But you can always dig yourself into a hole. We have terrible table that need to be reorganized but never have the time because of deadlines.

t. MSc in CE at Stanford

>Can we take a moment to appreciate the most underrated language?
Great idea! Let's discuss Go!

Attached: the gochad.jpg (1800x1800, 145K)

it's a [spoiler]query language[/spoiler]

now I know for sure that you never worked in real world serious company. querying normalized databases is easy only for trivial shit

>getTop11ByCreated....
this is a joke, right?

It's really not difficult. SQL has a bit of a learning curve but after a solid year of use you will have no issues with joins or subqueries or even CTEs if you aren't a complete brainlet.

> language
> SQL
Not Turing complete, not a language.

scripts are languages too.

>Not Turing complete, not a language
what

Imagine being this autistic.

nigguh I max it in a week

Prove it.

Write a query that generates the fibonacci sequence.

If it takes you more than 1 minute to do this, you haven't mastered SQL.

SQL is all fun.
Now go make a SGBD client based on PHP.

Attached: 1477953652648.jpg (837x930, 74K)

>sql

grandpa nosql is the hip now. get out with that old outdated shit

SELECT * from SEQUENCES where NAME="fibonacci"