Monthly Archives: June 2021

Just for laughing

Posted on June 24, 2021 by Siddharth Jain

Just for laughing Subject: 🤣🤣🤣 ❌❌❌❌❌❌❌❌❌❌ Smart answer by a female passenger on a flight… A guy asked a beautiful lady sitting next to him…’Nice perfume…..which one is it?…😍 I want to give it to my wife..!!’ Lady: ‘Don’t give … Continue reading →

Posted in Jokes | Leave a comment

First, Break All The Rules

Posted on June 21, 2021 by Siddharth Jain

Recently I came across this AMAZING book on management – everyone should read it whether you are a manager or not. Making some notes so I can refer quickly later on: After this the book says: employees don’t leave their … Continue reading →

Posted in Career | Leave a comment

invalid literal for int() with base 10

Posted on June 16, 2021 by Siddharth Jain

UPDATE: It turns out none of this works. I ran into the same error with latest VS Code and ms-python extension. The fix was to stick a breakpoint before the input command to prevent VS Code from taking conda activate … Continue reading →

Posted in Software | Tagged , , | Leave a comment

Databases 101

Posted on June 9, 2021 by Siddharth Jain

Structured Data Unstructured Data Semi-structured data – the best way to think of structured data is data that can be queried through SQL – Structured Query Language– this means data has a schema and is made up of typed primitives … Continue reading →

Posted in Software | Leave a comment

Understanding dates and time in MySQL

Posted on June 8, 2021 by Siddharth Jain

TL;DR: Set your server timezone and connection time zone to both ‘+00:00’ and use datetime instead of timestamp when you want to store dates outside the range supported by timestamp (‘1970-01-01 00:00:01.000000’ to ‘2038-01-19 03:14:07.999999′). Do’s when using datetime: Add a suffix … Continue reading →

Posted in Software | Tagged | Leave a comment

MySQL Foreign Keys

Posted on June 2, 2021 by Siddharth Jain

I used to think that the foreign key column has to be unique [ref] but that is not the case. Consider the tables below where we have a parent -> child -> grandchild relationship. A competition has teams and a … Continue reading →

Posted in Software | Tagged | Leave a comment