Rust · PostgreSQL · pgrx
A PostgreSQL extension written in Rust bringing quantitative finance primitives (returns, risk, volatility models, covariance, factor construction) directly into SQL.
Pranshu Patel
(He/Him) • 21y/o • 8:17:46 AM
Hey, I'm Pranshu. I'm currently pursuing my B.Tech in ICT at Dhirubhai Ambani University, and I mostly live on the backend side of things, though I'll jump into a frontend when something actually needs shipping. Just wrapped an internship at Fleetway building logistics APIs in Kotlin and Spring Boot; before that I was at Roommit doing Django services and a Next.js app for roommate matching.
I've been messing around with code since 2020. Started with C, somehow ended up in web stuff, and now I spend most of my time in TypeScript, Kotlin, or Python talking to Postgres and Redis. When I'm not doing that, I write some odd posts, push open source when I can, and dump photos in my gallery.
Experience
Work and campus leadership.
Projects
Tools, apps, and libraries I have shipped or maintain.
TypeScript · Next.js · PostgreSQL · React Flow
PostgreSQL schema drift analyzer: versioned snapshots from system catalogs, structural diffs (tables, constraints, indexes, RLS, …), forward-only DDL planner with preview and optional single-transaction apply, React Flow ER view of foreign keys.
Python · Flask · NumPy · librosa
Audio similarity with librosa features, z-normalized DTW and cross-correlation for tempo-robust scores; Flask API with similarity and alignment; Plotly and Tailwind UI.
TypeScript · AST · Next.js · CI/CD · SARIF
npm CLI: AST-based scan of Next.js route handlers, 15+ CWE-style checks, SARIF for GitHub Actions and GitLab CI, profiling (~150ms per project), 30-day scan history with incremental reruns (~50% faster on tracked repos).
TypeScript · Next.js · Tailwind CSS · PostgreSQL · Spotify Web API
Full-stack Spotify listening analytics: 50+ metrics, normalized PostgreSQL (3NF) with indexing, cron ingestion, SWR on the client, friend-based stat comparison.
Next.js · Last.fm API · OpenAI API
Astrology-themed music app: Next.js, Last.fm, and AI-generated personalized listening charts.
Next.js · Tailwind CSS · MongoDB
Open-source collaborative academic resources for the DAU community.
Node.js · MongoDB · Discord.js
Verified multi-purpose Discord bot: 150,000+ users, 150+ servers, moderation and utilities with disciplined releases.
Tech stack
Languages, frameworks, and tools I use often.
HTMLCSSJavaScriptTypeScriptC++PythonKotlinReactJSNextJSNodeJSExpressSpring BootDjangoPostgreSQLRedisTailwindMDXMongoDBFirebaseDockerPostmanRailwayGitGitHubVercelVSCodeNeoVimObsidianDiscord
Writing
Sometimes I build or break something interesting enough to write about, so I keep a blog. It's mostly stuff that doesn't belong in a README — debugging rabbit holes, performance wins I stumbled into, walkthroughs of projects, and notes on whatever I'm learning that week. Half of it is for other people, half is so I can look it up later when I inevitably forget how I fixed something.