Posts

All the articles I've posted.

• 🧩 From Bytes to Characters: What Really Lies Inside a File

  26 Mar, 2026

  A deep dive into how computers store files as bytes, the difference between text and binary files, and how character encoding works.

• ⚡️ BigQuery Query Optimization: Partition Pruning with Subqueries vs SQL Variables

  12 Dec, 2025

  Optimize BigQuery performance through effective partition pruning techniques.

• 🛟 The Secret Life of 'Hello, World!': A C Program's Journey

  Updated: 26 Nov, 2025

  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

  16 Nov, 2025

  Learn how to transform your S3 bucket into a lightning-fast, searchable data lake using Snowflake's Directory Tables, event-driven processing, and Streamlit.