Skip to content

Instantly share code, notes, and snippets.

@lyxal
Created June 4, 2021 23:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lyxal/27854038e71f84fe0e0d79a202288cb2 to your computer and use it in GitHub Desktop.
Save lyxal/27854038e71f84fe0e0d79a202288cb2 to your computer and use it in GitHub Desktop.
hyper-neutrino: CMP: would y'all rather have Elendia's TNBDE (SQL) or an API endpoint you can get TNB messages and whatever else from?
Wezl: @cairdcoinheringaahing replace their weapons with SQL
caird coinheringaahing: Just use SQL: SELECT * FROM War WHERE Winner = CGCC
StackMeter: @elementiro no, hell is SQL
Redwolf Programs: SQL with react is our frontend stack
Redwolf Programs: SQL
caird coinheringaahing: SQL: "WHAT IF LIFE WAS PAIN?"
Redwolf Programs: SQL: "What if life was pain?"
ophact: You're still definitely better than me as I know no SQL at all ;) not sure if that's a compliment or an insult.
caird coinheringaahing: @cairdcoinheringaahing Behold, my crappy SQL skills :P
ngn: @ngn it's ironic i have to use sql and wait for seconds to analyze data about k answers :)
caird coinheringaahing: SQL + Regex sounds bad tbh :P
Redwolf Programs: Another thing SQL can ruin for me
caird coinheringaahing: @ngn I think SQL has some kind of regex engine, so you could search for -N bytes thanks to ngn in the body, but I'm not sure how successful that would be. Here's a first shot just using body like which appears to be fairly good
Redwolf Programs: I managed to use SQL as a transpilation target to convert NPM's leftpad
Redwolf Programs: It [AP CSP pseudocode] has the aesthetics of SQL, and the functionality of TI-BASIC
Redwolf Programs: @WheatWizard JS >> SQL :p
StackMeter: SQL isn't TC even with that restriction of
Wheat Wizard: And plus SQL really shouldn't be TC. It would be a real big pain if you could have SQL that gets stuck in a loop.
Wheat Wizard: I don't really get what people dislike about SQL.
hyper-neutrino: i don't understand SQL too well but I don't think it's bad
Wheat Wizard: SQL is fine.
StackMeter: SQL bad
Wzl: so's SQL
StackMeter: @RedwolfPrograms If SQL were an element, it would be Polonium
Redwolf Programs: If SQL were a food, it would be socks with sandals
Redwolf Programs: Unless that thing is SQL
rene: @cairdcoinheringaahing all keywords here will show up blue. Codemirror isn't tuned for SEDE, it assumes all T-SQL statements are possible. CREATE USER is a thing in SQL Server ...
A username: ```sql
Wzl: CMC: Find a vulnerability allowing you to execute arbitrary SQL and hypothetically DROP TABLE chat_rooms and SELECT Jquery FROM toolbelt:P
user: @RedwolfPrograms A true golfer would use Jelly, not SQL
Redwolf Programs: It's 2122 AD. One century ago exactly, it happened. The code golfers got together, and decided to golf one final thing. Society. Our code was too long. They hacked the nuclear submarines. They did it in twenty bytes of SQL. We were the only survivors.
user: I guess an SQL expert would probably think of join as intuitive, though. I feel like it's just a matter of experience with using it
caird coinheringaahing: @RedwolfPrograms sql is perfectly fine until join
hyper-neutrino: select * from users is calming enough to let me forget I'm using SQL. SELECT * FROM users just causes instant death
Redwolf Programs: Lowercase SQL is so much nicer
caird coinheringaahing: @hyper-neutrino ngl whenever I use sql (i.e. SEDE), I just don't capitalise :P
hyper-neutrino: caps lock is a very important key for coding in SQL, the best language in existence
caird coinheringaahing: What does user do in SQL? It comes up as blue in the SEDE editor
user: Oh, I forgot - we also rickroll and hate on SQL, JS, and Java
Redwolf Programs: I wouldn't wish SQL on anyone, not my worst enemy
Wzl: Hit it with SQL
user: @RedwolfPrograms Not all of them will die - the weak ones will be rooted out, and you'll be left with reliable ones who are tolerant to SQL, because obviously it works like that :P
Redwolf Programs: Performance doesn't matter much if all of your backend developers die of SQL exposure
Bubbler: @Adám SQL implements query optimizer under the hood. Q might qualify, though I don't think K does by itself
user: @Adám I thought k still used SQL stuff
user: I thought Access still needed actual SQL databases to connect to or smth and it was more of a frontend
Bubbler: SQL excels at combining tables and processing queries in the fastest way possible. No other languages have built-in for that
Redwolf Programs: SQL sucks but trying to fix it with some simple cure like "use list indexing!" will just make it worse
hyper-neutrino: i mean i don't like writing sql myself either, that's why i use flask-sqlalchemy when making websites
StackMeter: @RedwolfPrograms this one
--- Everything after is AI. L53 is an AI continuation of L51
is a good time to ask the SQL question i've always wanted to know
Redwolf Programs: What do you mean StackMeter? I like using SQL, it makes me happy.
StackMeter: @Hyper-Neutrino all forms of query languages are bad. You should just use Erlang or some other language with an actual OO system and be done with it
Wzl: my favorite thing about sql is that everything was locked up in one place along with dbms table structures (and other things) so users can easily see how they work :P
StackMeter: @hyper-neutrino If you're not into writing code then don't write any :-) I'm fine if you don't want to learn anything more than basic concepts but that doesn't make your opinion valid :)  SQL isn't for everyone, get over yourself already <3 cmon <3
Bubbler: Who says every user needs knowledge about DBMS? Some of them might need simple operations only possible within database world. That's why there exists ORMs and other libraries making such tasks easy as F5 key ;) c'mon guys let's stop this "SQL sucks" discussion forever! ;-) It's very offensive :( Also there are people who would say SEDE rocks because of its design and features while others will appreciate Postgresql or Oracle RDBMS ! See - we're too different! We have our opinions ! They are totally right! No matter what we think :D There is no truth at all ! ;-) But seriously - overall today's society has changed a lot from 50s or 60s time when programming was something special...It became something common...And I respect those developers who created first ever web applications back from '80ies .They were pioneers and geniuses in their field by working around browsers limitations even before companies themselves started developing products around such technologies...I wonder where would we be now without these people ? Without them ,we wouldn't have had internet nor social networks yet..But well...Let's forget about
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment