Archives
All the articles I've archived.
2026 1
March 1
-
🧩 From Bytes to Characters: What Really Lies Inside a File
A deep dive into how computers store files as bytes, the difference between text and binary files, and how character encoding works.
2025 3
December 1
-
⚡️ BigQuery Query Optimization: Partition Pruning with Subqueries vs SQL Variables
Optimize BigQuery performance through effective partition pruning techniques.
November 2
-
🛟 The Secret Life of 'Hello, World!': A C Program's Journey
Updated:Explore the complete lifecycle of a C program from source code to execution, understanding preprocessing, compilation, assembly, linking, and runtime processes.
-
🚀 Building a Serverless File Search Engine for AWS S3 with Snowflake and Streamlit
Learn how to transform your S3 bucket into a lightning-fast, searchable data lake using Snowflake's Directory Tables, event-driven processing, and Streamlit.