Why I Use Partial Indexes for “Active Jobs” in Postgres
Keeping 50ms p95 while 8,000+ listings churn daily
Apr 7, 20266 min read
Command Palette
Search for a command to run...
#nextjs
Articles tagged with #nextjs
How We Turn a 35% BLS PMHNP Growth Projection Into Search, Alerts, and Better Job Matches
A builder’s take on macro labor stats: ingesting 500+ sources daily, normalizing messy postings, and surfacing “career confidence” as data you can query.
Mar 5, 20265 min readHow We Counted 693 Live PMHNP Openings in California (and Why Volume ≠ Fit)
A builder’s breakdown of our CA pipeline: multi-source ingestion, dedupe, geo resolution, and what “highest-volume state” means in real data.
Feb 27, 20265 min readHow We Detect “PMHNP-BC Required” in 500+ Job Feeds (and What the Credential Actually Means)
PMHNP-BC is more than alphabet soup: it’s an ANCC board-cert gate that drives filtering, matching, and credential verification in hiring pipelines.
Feb 26, 20265 min readHow We Measure the DNP vs MSN Pay Delta for PMHNP Jobs (and Turn It Into ROI Math)
A builder’s view of salary normalization, deduplication, and break-even calculations across 500+ job sources.
Feb 25, 20265 min readHow We Compared Telehealth vs In-Person PMHNP Pay Across 10,000+ Job Posts
A data-engineering look at salary normalization, deduplication, and why remote roles often price higher than “easier work.”
Feb 23, 20265 min read5