Skip to content
All work
Systems/Low-level2025

InventixDB

A distributed database management system written from scratch in C99. 34,981 lines spanning storage engines, MVCC, a query optimizer, and Raft consensus.

Source
InventixDB cover

Overview

InventixDB is a DBMS built from the ground up in C. It supports both relational (SQL-style) and document (NoSQL) models, with a bilingual query interface that accepts standard SQL and Hinglish (Roman-Urdu) syntax.

Highlights

  • Hybrid storage: B+Tree indexing, an LSM-Tree write path, and a columnar store for analytics.
  • MVCC transactions with four isolation levels and deadlock detection.
  • Cost-based query optimizer with plan caching and statistics.
  • Distributed layer: Raft consensus, hash/range partitioning, and sync/async replication.
  • RBAC security with PBKDF2 hashing and session management.
  • Full JOIN support (INNER/LEFT/RIGHT/FULL/CROSS/NATURAL) and multi-format backup/restore.

~73 source files, 34,981 lines of C99, cross-platform on Windows and Linux.

More work

View all
DermAI Pakistan cover
ML/AI2025

DermAI Pakistan

On-device dermatology decision support for low-resource clinics. A quantized deep learning classifier that runs entirely on the phone.

View case study
ml_frame cover
Systems/Low-level2024

ml_frame

A zero-dependency machine learning framework in roughly 2,800 lines of C11: arena allocator, reverse-mode autograd, multi-backend GEMM, and INT8 quantization.

View case study