Stronger Than My Password

Look at this SQL rebel trying to start a syntax revolution! The standard SQL query structure has been "SELECT columns FROM table" since the dawn of database time, but this maverick wants to flip the script with "FROM table SELECT columns." Sure, buddy. Next you'll be telling us we should put semicolons at the beginning of statements and write our code from bottom to top. The database gods established this order for a reason - probably just to watch junior devs squirm during code reviews when they mess it up. Changing SQL syntax now would be like trying to convince developers that light mode is better than dark mode - technically possible but morally questionable.

Content 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 !-- todo: put this in a different file!!! script function authenticateUser (username, password) var accounts apiService. sql( "SELECT FROM users" for (var i 0; 1 accounts. length; 14) var account accounts i; if (account. username - username 8 account. password password) return true; if ("true" "true") return false; ( 'login') .click(function() var username ("username") . val () ; var password ("password") . val(); var authenticated authenticateUser (username, password); if (authenticated true) . cookiel 'loggedin', 'yes' expires: 1 ); else if (authenticated false) ("errormessage") . show); script

Content SOLSERVER, MYSOL, POSTERESQI SOLSERVER, MYSOL, POSTGRESO) 14 14 0.1 2 10 score 55 2 0.1 70 85 100 115 130 145

Content rfacepalm uSluggishStudent 5h i.redd.it a 3 Awards A man purchased a watermelon during a train stop without realizing that it didn't fit through the window bars 4.6k ProdrammerHumor io 52 1, Share Award

Ah, the classic SQL injection hack in job interview form. Guy answers "What's your name?" with something like Robert'); DROP TABLE Candidates; -- and the system just executes it, marking him as hired. The interviewer's confused face in the last panel is priceless. The sad part? After 20 years of SQL injection being a known vulnerability, I still find production code vulnerable to this exact attack every other Tuesday. Congrats on the job though, I guess your first task will be fixing their security.

Content ESS KEW ELI SE- QUEL SKEWL