Til

<h1 align="left">Today I Learned</h1> <p align="center"> <img alt="TILs Count" src="https://img.shields.io/badge/dynamic/json.svg?color=black&label=TILs&query=count&url=https%3A%2F%2Fraw.githubusercontent.com%2FBhupesh-V%2Ftil%2Fmaster%2Fcount.json"> <img alt="last commit" src="https://img.shields.io/github/last-commit/bhupesh-V/TIL?color=purple"> <a href="https://github.com/Bhupesh-V/til/blob/master/LICENSE"> <img alt="License: MIT" src="https://img.shields.io/github/license/Bhupesh-V/til" target="_blank" /> </a> <a href="https://til.bhupesh.me"> <img alt="Website" src="https://img.shields.io/website?url=https%3A%2F%2Ftil.bhupesh.me"> </a> <a href="https://twitter.com/bhupeshimself"> <img alt="Twitter: Bhupesh Varshney" src="https://img.shields.io/twitter/follow/bhupeshimself.svg?style=social" target="_blank" /> </a> </p>

Welcome to my digital garden/second brain where I try to dump everything I learn in its most raw form 🌱

Categories

<table align="center"> <tbody> <tr> <td><a href="#android">Android</a>^[1]</td> <td><a href="#artificial-intelligence">Artificial Intelligence</a>^[2]</td> <td><a href="#aws">Aws</a>^[1]</td> </tr> <tr> <td><a href="#career">Career</a>^[9]</td> <td><a href="#citizen">Citizen</a>^[3]</td> <td><a href="#coding-practices">Coding Practices</a>^[5]</td> </tr> <tr> <td><a href="#community-building">Community Building</a>^[5]</td> <td><a href="#compilers">Compilers</a>^[1]</td> <td><a href="#data-warehouse">Data Warehouse</a>^[1]</td> </tr> <tr> <td><a href="#databases">Databases</a>^[13]</td> <td><a href="#devops">Devops</a>^[8]</td> <td><a href="#distributed-computing">Distributed Computing</a>^[3]</td> </tr> <tr> <td><a href="#ffmpeg">Ffmpeg</a>^[3]</td> <td><a href="#flutter">Flutter</a>^[3]</td> <td><a href="#git">Git</a>^[10]</td> </tr> <tr> <td><a href="#go">Go</a>^[18]</td> <td><a href="#hotwheels">Hotwheels</a>^[1]</td> <td><a href="#infra">Infra</a>^[1]</td> </tr> <tr> <td><a href="#management">Management</a>^[1]</td> <td><a href="#meta">Meta</a>^[4]</td> <td><a href="#miscellaneous">Miscellaneous</a>^[16]</td> </tr> <tr> <td><a href="#people">People</a>^[2]</td> <td><a href="#psychology">Psychology</a>^[5]</td> <td><a href="#python">Python</a>^[20]</td> </tr> <tr> <td><a href="#sales">Sales</a>^[1]</td> <td><a href="#shell">Shell</a>^[30]</td> <td><a href="#software-design">Software Design</a>^[1]</td> </tr> <tr> <td><a href="#startups">Startups</a>^[1]</td> <td><a href="#vim">Vim</a>^[8]</td> <td><a href="#webdev">Webdev</a>^[5]</td> </tr> </tbody> </table>

---

Android

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/android/running-headless-android-emulator.md">Running headless Android Emulator</a></li> </ul>

Artificial Intelligence

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/artificial-intelligence/fundamentals-of-llms.md">Fundamentals of LLMs</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/artificial-intelligence/retrieval-augmented-generative-rag.md">Retrieval-Augmented Generation (RAG)</a></li> </ul>

Aws

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/aws/ecr-ecs.md">AWS Elastic Container Registry & Elastic Container Service</a></li> </ul>

Career

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/beating-burnout-resources-thoughts.md">Beating Burnout: Some Thoughts & Resources</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/exploring-large-codebases-tips.md">Exploring Large Codebases</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/full-employment-theorem.md">Full employment theorem</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/developing-decision-making-skills.md">Invest in decision-making skills early in career</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/leveling-up-from-software-engineer-to-senior-software-engineer.md">Leveling up from Software Engineer to Senior Software Engineer</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/mentoring.md">Mentoring</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/pros-and-cons-of-working-professionally.md">Pros & Cons of working professionally</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/question-to-ask-interview.md">Questions to ask in an interview</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/career/writing-cover-letter-tips.md">Writing Cover letter - Tips</a></li> </ul>

Citizen

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/citizen/property.md">Accquiring properties in India</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/citizen/scam-spam.md">Figthing Scams</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/citizen/grievances.md">Grievance Sites for Indian Citizens</a></li> </ul>

Coding Practices

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/coding-practices/cleancode-naming.md">Naming Variables & Functions</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/coding-practices/everything-about-functions-procedures.md">Routines: Functions & Procedures</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/coding-practices/solid.md">SOLID: Design Principles</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/coding-practices/write-clean-comments.md">Writing Comments</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/coding-practices/cleancode-writing-functions.md">Writing Functions</a></li> </ul>

Community Building

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/community-building/how-to-motivate-and-encourage-volunteers.md">How to motivate and encourage volunteers</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/community-building/questions-for-women-in-tech.md">Questions for Women in Tech</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/community-building/questions-to-ask-every-community-builder.md">Questions to ask every Community Builder</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/community-building/questions-to-ask-every-volunteer.md">Questions to ask every community volunteer</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/community-building/what-does-a-community-lead-organiser-do.md">What does a Community Lead (or Organiser) do?</a></li> </ul>

Compilers

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/compilers/reference-counting-and-garbage-collection.md">Reference Counting v/s Garbage Collection</a></li> </ul>

Data Warehouse

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/data-warehouse/why-reverse-etl.md">Why Reverse ETL</a></li> </ul>

Databases

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/check-constraint-vs-exclusion-constraint.md">CHECK constraint v/s EXCLUSION constraint</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/clustered-non-clustered-indexes.md">Clustered & Non-clustered Indexes</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/database-sharding.md">Collected notes on Database Sharding 🗃</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/explain-postgresql-query.md">EXPLAIN queries in PostgreSQL</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/getting-json-data-in-postgresql.md">Getting JSON data from PostgreSQL</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/inserting-null-everywhere.md">Inserting NULL wherever possible on Postgres</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/list-all-values-for-custom-enum-postgres.md">List all values of a custom enum in Postgres</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/postgres-internals-data-organisation.md">Postgres 14 Internals: Data Organisation</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/postgres-tips-megalist.md">Postgres Tips & Tricks - Megalist of Secret SQL Queries</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/sqlite-space-optimization-with-rowd-id.md">SQLite db optimization with ROWID</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/slowly-changing-dimensions.md">Slowly Changing Dimensions (SCD)</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/postgres-backup-restore.md">Taking & Restoring Postgres Backups</a></li> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/databases/oath-for-3-normal-forms.md">The 3NF Oath ✋🏼</a></li> </ul>

Devops

<ul> <li><a target="_blank" href="https://github.com/Bhupesh-V/til/blob/master/devops/blue-green-deployment.md">Blue-Green Deployment Strategy</a></li> <li><a t