ARYAN MISHRA
Backend • Systems • Full Stack Web Applications
Hi, I'm Aryan. I spend most of my time these days tinkering around trying to make software related to Systems and Backend Engineering. Most of my work so far has been done using Typescript and C++. I am currently deepening my knowledge in Databases , Distributed Systems and Systems Programming. I like to write some technical deep dives into sofware from time to time as well. Have a look at my best projects and blogs below.
Featured Projects
A protocol-layer SQL firewall and connection pooler that intercepts PostgreSQL wire messages to block destructive patterns and optimize database performance.
Key Features
- Engineered protocol-layer SQL firewall intercepting PostgreSQL wire messages to block destructive SQL patterns before reaching database instances
- Implemented connection pooling with warm persistent SSL sessions, achieving 14-15ms proxy latency handling 2,000 queries across 20 concurrent connections across AWS EC2 Instances
- Designed query guard blocking DROP, TRUNCATE, ALTER TABLE, and unguarded DELETE statements, preventing accidental data loss in production environments
A high-performance job scheduler featuring a hybrid queuing architecture (Work-Stealing Deque + MPSC Mailbox) designed for microsecond latency and massive concurrency.
Key Features
- Achieved < 5µs P50 latency and 1M+ jobs/sec throughput via spin-wait spinning optimizations
- Implemented Lock-Free Chase-Lev Deque and MPSC Mailbox for contention-free task injection
- Used a Randomized Work-Stealing algorithm to prevent convoy effects under heavy load
- Zero dynamic allocations on the hot path with cache-aligned structures to prevent false sharing
A multi-process monolith for trimming clips. The Express API offloads heavy yt-dlp + FFmpeg work to BullMQ workers backed by Redis, streaming real-time progress over WebSockets.
Key Features
- Multi-Process Monolith: API Server + Worker
- Real-Time Job Status via Socket.io
- BullMQ Worker System with Priority based queues
- Google OAuth Authentication
- Optimized background job orchestration using BullMQ and Redis, ensuring system stability during burst of 4,000+ concurrent jobs.
A thread-safe, stop-the-world Mark-and-Sweep garbage collector in C++. It manages heap objects via VM stack and global roots tracking with safe multi-threaded allocation.
Key Features
- Tracing-based garbage collection with stop-the-world design
- Multi-root tracking (stack + globals)
- Cyclic reference handling
- Thread-safe heap access using a single global mutex
- Multithreaded stress-tested allocation safety
Latest Blog.
Check out some of the blogs I have written.
Currently Building
Conduit
Conduit is a Proxy SQL router which intercepts PostgreSQL wire protocol packets and parses SQL ASTs to transparently route queries across sharded database instances based on consistent hashing. The basic idea behind is to allow user to interact with their fleet of sharded database instances via a single medium.
Technical Arsenal
Select Category