Writing

Thoughts on data,
engineering & craft.

Articles on data engineering, architecture patterns, and lessons from building real-world data systems.

The evolution of the Modern Data Stack: From RDBMS to the LakeHouse
Jan 13, 2026 11 min read
The evolution of the Modern Data Stack: From RDBMS to the LakeHouse
This post aims to provide a historical picture of the evolution of the typical data stack over a span...
learningdiscussarchitecturedataengineering
Read More
Data Compression, Types and Techniques in Big Data
Feb 25, 2025 11 min read
Data Compression, Types and Techniques in Big Data
Cover Photo by Tim Mossholder on Unsplash Introduction This article will discuss...
datalearningdiscussdatascience
Read More
Custom Data Types in SQL
Feb 04, 2025 6 min read
Custom Data Types in SQL
Cover Photo by Xavi Cabrera on Unsplash Before, we dive in, this post focuses on Oracle databases....
SQLdatalearningoracle
Read More
Understanding Database Indexes And Their Data Structures: Hashes, SS-Tables, LSM Trees And B-Trees
Mar 05, 2024 1 min read
Understanding Database Indexes And Their Data Structures: Hashes, SS-Tables, LSM Trees And B-Trees
There's often a huge fuss about making data-driven decisions, leveraging data analytics, using data...
databaseprogrammingtutorialarchitecture
Read More
Functions in SQL
Feb 27, 2024 3 min read
Functions in SQL
Functions are very similar to procedures in databases. In this article, I will try to break down...
SQLdatabaseprogrammingtutorial
Read More
Database Triggers in PostgreSQL: A Deep Dive using AWS RDS
Feb 20, 2024 5 min read
Database Triggers in PostgreSQL: A Deep Dive using AWS RDS
Photo by Jr Korpa on Unsplash Database triggers are special types of objects. They look like...
databaseprogrammingpostgresaws
Read More
How to write Database Procedures
Feb 15, 2024 4 min read
How to write Database Procedures
What are Database Procedures Procedures are commonplace across several different...
SQLdatabaseprogrammingoracle
Read More
Mastering Common Database Objects - Series 1 .. n
Feb 15, 2024 1 min read
Mastering Common Database Objects - Series 1 .. n
In the series, I hope to cover some common database objects such as procedures, functions, triggers...
SQLdatabaseprogrammingawsbigdata
Read More
Energy Forecasting with LSTM Neural Network
Feb 12, 2024 1 min read
Energy Forecasting with LSTM Neural Network
Several methods have been used in energy forecasting over the years. Methods from different...
Pythondatasciencelstmmachinelearning
Read More
What to think about when designing, building, managing and operating data systems.
Feb 10, 2024 1 min read
What to think about when designing, building, managing and operating data systems.
This post draws extensively from a book I am currently reading and my experience managing data...
learningdiscussdataengineeringsystemdesign
Read More