Skip to main content
Rohit Awate

Rohit Awate

Hobbyist programmer writing about computer science, self-hosting, photography, and films.

Recent

Efficient SQL for Hierarchical Data

·7 mins
This article explores efficient methods for retrieving hierarchical data in PostgreSQL using PL/pgSQL and Recursive CTEs.

Linear Regression: Intuition

·6 mins
While a relatively simple algorithm, linear regression employs a bunch of ideas and techniques that are universal across machine learning.

Demystifying Tail Call Optimization

·9 mins
Tail call optimization (a.k.a. tail call elimination) is a technique used by compilers to improve the recursive performance of your programs.