Mohamed Hussain S

Exploring OLAP DBs like ClickHouse & building data infra with Airflow, Docker & PostgreSQL.

Chennai, India Joined on May 31, 2025 https://mohamedhussain.dev

Work

Associate Data Engineer @ Quantrail Data Chennai, India

Mohamed Hussain S

Jul 22

Why My ClickHouse Server Ran Out of Disk (and It Wasn't the Data I Expected)

#clickhouse #linux #devops #database

4 min read

Want to connect with Mohamed Hussain S?

Create an account to connect with Mohamed Hussain S. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Mohamed Hussain S

Jul 21

Can ClickHouse Replace a Vector Database?

#clickhouse #vectordatabase #ai #backend

4 min read

Mohamed Hussain S

Jul 8

Why Localhost Worked but the Application Couldn't Connect

#linux #networking #devops #backend

3 min read

Mohamed Hussain S

Jul 7

Understanding ACME: What I Learned While Debugging HTTPS Certificate Failures

#linux #devops #networking #security

3 min read

Mohamed Hussain S

Jun 22

When Logs Aren't Enough: Using tcpdump to Debug Real Network Problems

#linux #networking #devops #tcpdump

4 min read

Mohamed Hussain S

Jun 17

The Hidden Linux Routing Issue That Broke My Deployment

#linux #devops #networking #debugging

5 min read

Mohamed Hussain S

Jun 13

ClickHouse Duplicates: Clean Your Results vs. Clean Your Storage

#clickhouse #database #dataengineering #sql

3 min read

Mohamed Hussain S

May 27

Why ClickHouse Loves Append-Heavy Workloads

#clickhouse #olap #databasearchitecture #dataengineering

4 min read

Mohamed Hussain S

May 25

Why Too Many Parts Hurt ClickHouse Performance

#clickhouse #database #dataengineering #backend

4 min read

Mohamed Hussain S

May 19

Why Real-Time Analytics Eventually Changes Your Database Architecture

#clickhouse #postgres #dataengineering #architecture

4 min read

Mohamed Hussain S

May 14

FINAL in ClickHouse Isn’t as Expensive as It Used to Be

#clickhouse #dataengineering #databaseopimization #replacingmergetree

4 min read

Mohamed Hussain S

May 11

Why PostgreSQL and ClickHouse Work So Well Together

#dataengineering #postgres #clickhouse #systemarchitecture

3 min read

Mohamed Hussain S

May 6

PostgreSQL Restore Failures: It Wasn’t pgBackRest, It Was My Recovery Logic

#postgres #database #devops #opensource

6 min read

Mohamed Hussain S

Apr 28

arrayJoin in ClickHouse: Why Your Rows Are Duplicating (and How to Control It)

#clickhouse #sql #database #performance

2 min read

Mohamed Hussain S

Apr 20

greatCircleDistance in ClickHouse: Avoiding Full Table Scans

#clickhouse #sql #dataengineering #performance

2 min read

Mohamed Hussain S

Apr 16

Why My S3 Backup Setup Broke: Buckets, “Folders”, and Scheduling Misconceptions

#aws #s3 #cloudstorage #dataengineering

3 min read

Mohamed Hussain S

Apr 16

Debugging a Broken Metrics Pipeline: What Actually Went Wrong

#dataengineering #clickhouse #vector #debugging

3 min read

Mohamed Hussain S

Apr 16

From Pipelines to Transforms: Making Vector Work with ClickHouse

#dataengineering #clickhouse #observability #vector

3 min read

Mohamed Hussain S

Apr 9

Understanding Vector Pipelines: From Config Files to Data Flow

#dataengineering #clickhouse #observability #backend

3 min read

Mohamed Hussain S

Apr 7

Why My Metrics Pipeline with Telegraf Didn’t Work (and What I Learned)

#dataengineering #clickhouse #devops #observability

2 min read

Mohamed Hussain S

Apr 1

Full Text Search in ClickHouse: What Works in 2026

#clickhouse #database #backend #opensource

3 min read

Mohamed Hussain S

Mar 26

When Synthetic Data Lies: A Hidden Correlation Problem I Didn’t Expect

#dataengineering #clickhouse #analytics #debugging

3 min read

Mohamed Hussain S

Mar 25

How ClickHouse + Superset Work Together for Analytics (And What Actually Matters)

#clickhouse #superset #analytics #database

4 min read

Mohamed Hussain S

Mar 16

Managing Large PostgreSQL Tables with Native Partitioning and pg_partman

#postgres #database #backend #devops

3 min read

Mohamed Hussain S

Mar 13

PostgreSQL Backups and Point-in-Time Recovery with pgBackRest

#postgres #database #devops #opensource

4 min read

Mohamed Hussain S

Mar 11

How Debezium Uses PostgreSQL WAL for Change Data Capture

#postgres #backend #database #devops

4 min read

Mohamed Hussain S

Mar 9

How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

#postgres #database #backend #devops

4 min read

Mohamed Hussain S

Mar 3

Why 'FINAL' in ClickHouse Is Usually a Design Smell

#clickhouse #performance #backend #dataengineering

3 min read

Mohamed Hussain S

Feb 17

Two ClickHouse Internals That Change How You Write Queries

#clickhouse #database #backend #performance

4 min read

Mohamed Hussain S

Feb 3

Understanding Change Data Capture with Debezium

#cdc #datapipelines #debezium #kafka

4 min read

Mohamed Hussain S

Jan 21

Apache Iceberg Explained: From Data Lakes to Metadata, Snapshots, and Real-World Usage

#datalake #apacheiceberg #dataengineering #bigdata

4 min read

Mohamed Hussain S

Dec 13 '25

Analyzing and Optimizing a Parquet ClickHouse Ingestion Pipeline

#dataengineering #etl #clickhouse #python

3 min read

Mohamed Hussain S

Dec 2 '25

Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

#dataengineering #python #go #sql

3 min read

Mohamed Hussain S

Nov 15 '25

Why Parquet Is Everywhere - And What Makes It Actually Fast?

#dataengineering #parquet #bigdata #dataarchitecture

3 min read

Mohamed Hussain S

Oct 20 '25

🐝 Why Hive Exists - And Why Its Complexity Is Actually Necessary

#architecture #bigdata #dataengineering #hive

3 min read

Mohamed Hussain S

Sep 19 '25

Polyglot Data Engineering: Python + Go in the Same Pipeline

#dataengineering #python #go #clickhouse

2 min read

Mohamed Hussain S

Sep 9 '25

Scaling Databases with ClickHouse Sharding (Hands-On Simulation)

#clickhouse #olap #dataengineering #resources

2 min read

Mohamed Hussain S

Aug 7 '25

From Python to ClickHouse: Parquet ETL with Go

#go #python #parquet #clickhouse

2 min read

Mohamed Hussain S

Jul 24 '25

⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way

#clickhouse #dataengineering #performance #sql

3 min read

Mohamed Hussain S

Jul 8 '25

🧠 From Hive and Elastic to ClickHouse: What Surprised Me

#clickhouse #sql #hive #elasticsearch

3 min read

Mohamed Hussain S

Jul 2 '25

⚡ Kafka ClickHouse: Real-Time Data Pipeline for Beginners

#dataengineering #kafka #clickhouse #docker

2 min read

Mohamed Hussain S

Jun 25 '25

Extracting System Metrics from ClickHouse Using Airflow & Docker

#clickhouse #airflow #docker #python

3 min read

Mohamed Hussain S

Jun 13 '25

My First Data Pipeline Project Using Airflow, Docker & Postgres (COVID API Edition)

#dataengineering #postgres #airflow #docker

2 min read

Mohamed Hussain S

Jun 6 '25

Why ClickHouse is a Game-Changer for OLAP: Speed, Architecture, Pros & Cons

#database #clickhouse #analytics #bigdata

2 min read

Mohamed Hussain S

May 31 '25

Building My First Real-Time Dashboard with ClickHouse and Streamlit: TrendLite Breakdown

#clickhouse #dataengineering #python #streamlit

2 min read

One Year Club

1 Week Community Wellness Streak

Writing Debut

Want to connect with Mohamed Hussain S?