That's insane 😜

Jon Skeet's profile picture fits so nicely into this.

Source: https://aprogrammerlife.com/top-rat...

Today my 16 yr old cousin asked
me...
"If the compiler knows that..
"semicolon is missing at line no 16
in Helloworld.java", then why it can't
simply put a';' there instead of
telling us..."

He got a point.

"Geometry can produce legible letters, but art alone makes the beautiful. Art begins where geometry ends, and imparts to letters a character transcending mere measurement." - Paul Standard

Handshakes are important!

Good 'ol days.

I was thinking about how I implement login functionality, and realised I have no clue how I came up with it so decided to ask if it was a good way to do things.

Basically, client logs in, username/email and pass are sent to server.

Server salts and hashes password and checks it against the one in the database for that user.

If its correct, send the client the user ID and the user token. (User id could be username, or a number, it depends)

When that client makes a request, the request must contain the ID and token.

The server checks that the ID and token combo are correct, and because the ID is linked to the user we know who it is and can complete the request.

Usually I make the token a random string of 16 or 32 chars, each account has their own token, and it may be stored in the browser so they stay logged in. I also normally add a "log out everywhere" button, which essentially just generates a new token to overrides the current one, making any previously saved tokens invalid.

"I really like Docker"

"Oh yeah? Name 3 of Docker's albums"

SQL & Assembly: The most intuitive languages I have used

Two sql databases enter a nosql bar. After 10 min they exit because they couldn't find a table

Today I come across something interresting in SQL Server.

I was optimizing a report query and in the SSMS windows runned in 10 seconds for 3000 rows.

Put it to a stored procedure took me 5 minutes for getting 100 rows.

I was like WTF?

After some research I found out that the problem was that I was using the Stored Procedure parameters in the query.

Created local variables for the parameters and poof... 10 seconds again.

So if you are creating Stored Procedures in SQL Server DO NOT USE THE PARAMETERS FROM THE PROCEDURE. CREATE LOCAL VARIABLES.

Making love with SQL

so guys, how do you say SQL? "sequel" or "es-kyu-el"?

SQL just feels like its screaming at me....

My Database Teacher writes the SQL commands in lowercase. It really grinds my gears.

I'm going name a table "the bass".
I can now drop the bass.

My gf didnt laughed...

Me: Enters SQL class
Prof: We will draw ERD diagram on awwapp
Me: (In my head - I hate ERD diagrams) start drawing the first ERD diagram
Prof: That diagram is wrong
Prof: opens SQL Activities_Solution.pdf on his PC
Me: Tried to change the file name on aws to get solution file - fail
Copy SQL Activities.pdf file url (https://url/courses/6429/...). Adds 1 to 1100726 = 1100727 and downloads SQL Activities_Solution.pdf
Open PDF in one tab and awwapp on another and just draw the solution
Prof: Are you sure this diagram is corect?
Me: (In my head - I copied the solution so yes) ...
Prof: Let me check the question
Me: (In my head - seriously? you don't know the answer)
Prof: Checks the correct answer on his PC and then checks the answer on my PC
Me: (In my head - completed another boring uni class) pack up and go home

Discovered one of the worst db designs ever:

- A cust is inserted in a table.
- The insert trigger is fired, calling a stored proc
- The stored proc being called creates a dynamic sql that builds a create table statement for 8 different tables. These tables will be postfixed with the newly-created cust id and is executed.

When querying info for a cust, a stored proc is used that accepts an id value would be appended to another dynamic sql that creates a select statement across all 8 tables for one customer.

Shoot me now.

A SQL clause walks into a bar, he sees two tables and asks: "can I join you?"

SELECT *
FROM World
WHERE "Someone"
LIKE "%YOU%"

What do vegetarian SQL users have for lunch?

VegeTABLES

Some mouthwatering SQL right here

useful graphic SQL joins

If you don't know SQL, then just mention NoSQL in your CV.

The OEM wallpaper gentoo ebuild works oh god oh fuck

Ebuild sauce: https://git.io/fj59T

Do online courses/certificates actually mean something to companies/universities?

Coursera courses? OpenClassrooms? Stuff like that.

Writing some C in the middle of the night for some random project idea I thought of while eating Pizza is the most fun I've had this year. :)
Feels good.

Base69