SMIT BHARAT PATIL
SmitBharatPatil

Writing

Notes on building

Engineering, product, and the occasional rabbit hole, written up properly.

12

Articles

3

Categories

27

Topics covered

Dynamic Ticket Pricing Without Overselling: Seat Holds in Postgres

Engineering · 26 September 2026 · 12 min read

Dynamic Ticket Pricing Without Overselling: Seat Holds in Postgres

How Verve raises ticket prices as seats fill without overselling: seat holds, row locks, a 200-person race test on real Postgres, and the edge cases that surprised me.

System DesignPostgres
Type-Ahead Search in TypeScript, Built with My DAA Course

Engineering · 26 September 2026 · 9 min read

Type-Ahead Search in TypeScript, Built with My DAA Course

How a DAA lab helped me build type-ahead search for hundreds of runners at a finish line: scoring, sorting, a live demo and a sort race in TypeScript.

TypeScriptAlgorithms
From a Screenshot of a Table to a Live Ops Portal: Building Examlytics's Team Operating SystemFeatured

Engineering · 13 September 2026 · 10 min read

From a Screenshot of a Table to a Live Ops Portal: Building Examlytics's Team Operating System

Every instruction arrived as a WhatsApp screenshot, a meeting-minutes PDF, or a voice note correcting the last one. Here's how that turned into a real Next.js and Supabase portal that runs Examlytics's daily accountability, and what changed twice before the numbers were right.

SupabaseNext.js
One Login. One Device. No Exceptions.Featured

Engineering · 6 September 2026 · 8 min read

One Login. One Device. No Exceptions.

How Examlytics went from 'technically anyone could share a login' to kicking a second device offline in under a second, why that isn't a nice-to-have for an exam platform, and the two-part build (a database trigger, then a Realtime broadcast) that got it there.

SupabaseSecurity
Get Your Domain on "Sign in with Google," Not Your Supabase Project ID

Engineering · 6 September 2026 · 7 min read

Get Your Domain on "Sign in with Google," Not Your Supabase Project ID

Every student clicking 'Continue with Google' on Examlytics saw a Google popup pointing to kdmazjuawkchtjtcwbqk.supabase.co instead of examlytics.in. Here's why that happens, the paid fix versus the free one, and the actual OAuth logic behind swapping one for the other.

SupabaseGoogle OAuth
“Done” Was Never the Right Word

Engineering · 5 September 2026 · 9 min read

“Done” Was Never the Right Word

We shipped LaTeX rendering for an exam-prep platform's question bank. Every fix surfaced a smaller one underneath it, right down to a single missing backslash silently corrupting math. Here's the whole chain, and the stack behind it.

SupabaseNext.js
You Don't Need Vercel Pro. You Need a Fork (or a Merge Button).

Engineering · 4 September 2026 · 5 min read

You Don't Need Vercel Pro. You Need a Fork (or a Merge Button).

Vercel's Hobby plan blocks a second person from deploying to your project, and there's no setting that fixes it. Here are four working jugaads that get someone else's code live without paying for Pro.

VercelDevOps
You Don't Need a SaaS Stack. You Need Twenty Minutes and a Spreadsheet.

Founder · 2 September 2026 · 8 min read

You Don't Need a SaaS Stack. You Need Twenty Minutes and a Spreadsheet.

How I built a free issue tracker and CRM on Google Sheets and Apps Script in an afternoon, plus the failure modes nobody warns you about.

AutomationGoogle Apps Script
How I Actually Scaled NexElite.MediaFeatured

Growth & Marketing · 1 September 2026 · 7 min read

How I Actually Scaled NexElite.Media

Building the site was the easy part. Turning it into a machine that pulls in requests from six continents and actually converts is a different job entirely, here's what that job looked like.

GrowthSEO