@sathish-daggula

Why I Use SQLite Savepoints for Offline Workout Logging

Apr 15 · 8 min read · The Problem My workout app has one hard requirement: I must be able to log a set in under 5 seconds, even in airplane mode. That sounds like a UX thing. It’s actually a data integrity problem. A “set” write isn’t one row. It touches multiple tables: ...

Why I Use Partial Indexes for “Active Jobs” in Postgres

Apr 7 · 6 min read · The Problem My job board has a simple read path on paper: show “active” jobs, let users filter by location, remote/hybrid, specialty, and recency. In production it wasn’t simple. I had 8,000+ active listings, ~2,000 companies, and ~200 listing update...

How We Turn a 35% BLS PMHNP Growth Projection Into Search, Alerts, and Better Job Matches

Mar 5 · 5 min read · The BLS projection (35% PMHNP growth from 2024–2034) is a macro signal. The hard part is translating it into a daily system that answers: where are the roles, what do they pay, how fast do they move, and which postings are actually real. How We Turn ...

How We Counted 693 Live PMHNP Openings in California (and Why Volume ≠ Fit)

Feb 27 · 5 min read · California shows 693 PMHNP openings in our index. The interesting part isn’t the number—it’s how you get a trustworthy count from messy job feeds, and what the distribution says about metros, settings, and competition. California State Spotlight: 693...

How We Detect “PMHNP-BC Required” in 500+ Job Feeds (and What the Credential Actually Means)

Feb 26 · 5 min read · In our pipeline, “PMHNP-BC required” isn’t a nice-to-have string. It’s a high-signal field that determines whether a job matches a clinician at all—so we treat it like structured data, not copy. How We Detect “PMHNP-BC Required” in 500+ Job Feeds (an...