it's like a physical library except you have a magical device that can recreate a portion of the library in front of you depending on your input queries on it.
Its like a library with lots of book. You can ask the librarian about a type of book that you want and the librarian will bring you a list of books that you may be interested in.
Suppose you want a book about a flower, you'd ask the librarian to look for the book inside the life and plants section, then inside that, you will ask the librarian to choose bring a list of books with flowers. You may get a 100 books but if you want a flower that only grows in America, the list of books will be shorter because you dont want the books from Africa.
Say there is an Italian ice cream man who has the best ice cream in town but doesn't speak a word of English.
So, in order to get ice cream, you need to learn at least a little Italian. You don't need to know much and it's easy enough to learn so you do it.
Now, computers are like that. You need to speak a particular language so they can understand what you want.
Even worse, there are many such languages and SQL just happens to be one of them. But most of them are very easy to learn, much easier than Italian.
SQL is the language of databases. A database is just a fancy word for something like a phone book. But it turns out that they are very important and talking to them is quite common.
>just use regular declarative SQL, it's already turing-complete
I often heard that SQL isn't a programming language, hence it's probably not Turing-complete.
>Turing completeness: Recursive CTE make SQL:1999 turing complete, which means that any program can be written in SQL! (if you’re crazy enough) One impressive example that frequently shows up on blogs: The Mandelbrot Set, e.g. as displayed on http://explainextended.com/2013/12/31/happy-new-year-5/
>Recursive SQL
Jesus, that seems moronic. I need to learn it and implement it somewhere at work to confuse the frick out of people.
2 years ago
Anonymous
Honestly it's surprisingly useful. If you have an entity with a many-to-many relationship to itself (e.g. a user on twitter follows other users), you can use recursive SQL to traverse the resulting graph on the database side. This lets you query for things like "users who are connected to User X by any number of following-follower links."
2 years ago
Anonymous
jesus that must be a clusterfrick to implement.
2 years ago
Anonymous
IIRC you can do a recursive query like this in ~10 lines. They're a bit wonky to read at first, but once you know the pattern you can see what they're doing.
Yeah, but code monkies can make mistakes. DBAs and friends can't.
So I don't think any database-related job can be considered "comfy".
Maybe SQL developer, but that's basically programming.
2 years ago
Anonymous
so what IS comfy then? front end need not apply
2 years ago
Anonymous
web dev. just use one of those website generators, steal the code and pass it as your own with small modifications
your database should not be peripheral
sql is a primitive piece of dogshit.
your database should be part off the programming langauge.
sql, being perpheral, is an issue
why use. sql.
sql is fking useless.
Thread hijack. my work uses excel for _everything_ and i think we'd benefit from the rows and records concept in SQL.
ie project is a record, which contains rows for project members/items.
Are there any user friendly (admin staff) softwares that work in this format? I use OpenRefine but it's not really built for data entry or editing cells
Just use Postgres and use SQL like a normal person. Who tf actually stores critical records in Excel? If they don't need ACID and are just simple records then Excel/Sharepoint/Google Sheets works fine, but if you need an application layer or start to get more data you'll need a database. It's very clear when you need a database vs. when you just need to store some simple info.
It's a standardized format for making queries to a database.
why not just create a query?
huh?
you may be moronic
Granted, with what language?
the query was the friends we made along the way
SELECT * FROM children WHERE underage = TRUE and pregnant = TRUE;
show me the results of this query
YOUR_MOM
> = TRUE
ngmi, real Black folk will know
Based integer guy
Yeah noticed this too...
Also
>and instead of capitalized AND
You forgot the semicolon at the end my friend.
it's like a physical library except you have a magical device that can recreate a portion of the library in front of you depending on your input queries on it.
It's a way of talking to and about tables of data.
"Simple Query Language".
Its like a library with lots of book. You can ask the librarian about a type of book that you want and the librarian will bring you a list of books that you may be interested in.
Suppose you want a book about a flower, you'd ask the librarian to look for the book inside the life and plants section, then inside that, you will ask the librarian to choose bring a list of books with flowers. You may get a 100 books but if you want a flower that only grows in America, the list of books will be shorter because you dont want the books from Africa.
It's the opposite of the Google search, where you enter a general search term and it spits out whatever
It's a language meant to ask rows from what is basically basically a glorified spreadsheet
This.
>show me this like this plz
the last time i had to do something with mysql is like almost 2y ago
Say there is an Italian ice cream man who has the best ice cream in town but doesn't speak a word of English.
So, in order to get ice cream, you need to learn at least a little Italian. You don't need to know much and it's easy enough to learn so you do it.
Now, computers are like that. You need to speak a particular language so they can understand what you want.
Even worse, there are many such languages and SQL just happens to be one of them. But most of them are very easy to learn, much easier than Italian.
SQL is the language of databases. A database is just a fancy word for something like a phone book. But it turns out that they are very important and talking to them is quite common.
>t. kindergarten teacher
>phone book
Nobody under the age of like 20 knows what that is, grandpa.
Lmaoing @ this post
lmao are you a full time educator?
SQL is a programming language,
It allows data management and organization.
SQL is only good when it is used procedurally.
Most of the time SQL is used to organize data in an efficient manner in a database.
Most of the time this database is connected to a webserver (website).
Data you input on the website is transferred to the database.
>SQL is only good when it is used procedurally.
homie PL/SQL is AIDS, just use regular declarative SQL, it's already turing-complete
based and checked
>just use regular declarative SQL, it's already turing-complete
I often heard that SQL isn't a programming language, hence it's probably not Turing-complete.
>Turing completeness: Recursive CTE make SQL:1999 turing complete, which means that any program can be written in SQL! (if you’re crazy enough) One impressive example that frequently shows up on blogs: The Mandelbrot Set, e.g. as displayed on http://explainextended.com/2013/12/31/happy-new-year-5/
Source: https://blog.jooq.org/10-sql-tricks-that-you-didnt-think-were-possible/
>Recursive SQL
Jesus, that seems moronic. I need to learn it and implement it somewhere at work to confuse the frick out of people.
Honestly it's surprisingly useful. If you have an entity with a many-to-many relationship to itself (e.g. a user on twitter follows other users), you can use recursive SQL to traverse the resulting graph on the database side. This lets you query for things like "users who are connected to User X by any number of following-follower links."
jesus that must be a clusterfrick to implement.
IIRC you can do a recursive query like this in ~10 lines. They're a bit wonky to read at first, but once you know the pattern you can see what they're doing.
is it frick a programming language
no shit, you think all programming languages are supposed to look hacky n shit?
It's a SQL to a PQL
Its excel but you can ask it questions instead of writing vlookups
The magic spell of finding a lot of numbers
Captcha NVDDA
It's MariaDB's dad, but nobody likes him
what’s the comfiest sql job?
none
why not? it’s better than being a code monkey
Yeah, but code monkies can make mistakes. DBAs and friends can't.
So I don't think any database-related job can be considered "comfy".
Maybe SQL developer, but that's basically programming.
so what IS comfy then? front end need not apply
web dev. just use one of those website generators, steal the code and pass it as your own with small modifications
sounds based
I’m a white man. I don’t make mistakes.
SELECT * FROM op_is_always_a_homosexual WHERE 'op_is_gay' IS true
>out of memory error, 60 billion results returned
Uh, isn't the thing named op_is_always_a_homosexual, so op_is_gay would always be true, rendering it redundant
Sorry but the CONOPS stated we must store them and retrieve them, doesnt matter if its redundant :^)
Really simple for databases, you can learn it in a day.
big excel file in ram
>Show me data in table where this value is 69420
it's database
you put data in it and you can ask for the data back later
are you a 5 year old who knows C programming?
https://cstack.github.io/db_tutorial/
Tfw GISgay with basic SQL knowledge and coworkers think I'm some kind of data God because I can make joins
don't use it
its useless
its an issue
use nosql
use objects correctly
your database should not be peripheral
sql is a primitive piece of dogshit.
your database should be part off the programming langauge.
sql, being perpheral, is an issue
why use. sql.
sql is fking useless.
Filtered by SQL: the posts.
you make tables and put stuff in them
there's more but that's the key
Thread hijack. my work uses excel for _everything_ and i think we'd benefit from the rows and records concept in SQL.
ie project is a record, which contains rows for project members/items.
Are there any user friendly (admin staff) softwares that work in this format? I use OpenRefine but it's not really built for data entry or editing cells
PGAdmin is pretty nice, but it's not quite as intuitive as excel. Looks like Apache OpenOffice also supports Postgres, which is my favorite SQL DB.
https://docs.devart.com/odbc/postgresql/openoffice.htm
Just use Postgres and use SQL like a normal person. Who tf actually stores critical records in Excel? If they don't need ACID and are just simple records then Excel/Sharepoint/Google Sheets works fine, but if you need an application layer or start to get more data you'll need a database. It's very clear when you need a database vs. when you just need to store some simple info.