惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

P
Proofpoint News Feed
G
GRAHAM CLULEY
GbyAI
GbyAI
Martin Fowler
Martin Fowler
Last Week in AI
Last Week in AI
月光博客
月光博客
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
V
Visual Studio Blog
博客园 - 聂微东
aimingoo的专栏
aimingoo的专栏
The GitHub Blog
The GitHub Blog
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
Blog — PlanetScale
Blog — PlanetScale
The Cloudflare Blog
博客园 - 叶小钗
罗磊的独立博客
宝玉的分享
宝玉的分享
P
Privacy International News Feed
酷 壳 – CoolShell
酷 壳 – CoolShell
Scott Helme
Scott Helme
Project Zero
Project Zero
P
Palo Alto Networks Blog
F
Fortinet All Blogs
Help Net Security
Help Net Security
K
Kaspersky official blog
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
S
Schneier on Security
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
F
Full Disclosure
Webroot Blog
Webroot Blog
V
V2EX
C
Check Point Blog
L
LangChain Blog
阮一峰的网络日志
阮一峰的网络日志
H
Hacker News: Front Page
G
Google Developers Blog
Hugging Face - Blog
Hugging Face - Blog
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
博客园_首页
Application and Cybersecurity Blog
Application and Cybersecurity Blog
H
Help Net Security
量子位
Recorded Future
Recorded Future
H
Heimdal Security Blog
雷峰网
雷峰网
T
The Blog of Author Tim Ferriss
www.infosecurity-magazine.com
www.infosecurity-magazine.com
O
OpenAI News
D
DataBreaches.Net

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant Common SOC 2 Failures (Real World) Stop Vibe-Checking Your AI App: A Practical Guide to Evals How to Use SonarQube and SonarScanner Locally to Level Up Your Code Quality Your Next To-Do App Is Dead — I Replaced Mine with an OpenClaw AI Sign a Nostr event in 60 lines of Python using coincurve — no nostr-sdk, no nbxplorer, no rust toolchain ITGC Audit Explained Like You’re in Big 4 Patch Tuesday abril 2026: Microsoft parcha 163 vulnerabilidades y un zero-day en SharePoint Stop scraping everything: a better way to track competitor price changes Listing on MCPize + the Official MCP Registry while routing payments OUTSIDE the marketplace — how I kept 100% of my x402 revenue Building an AI-Powered Risk Intelligence System Using Serverless Architecture Why We Ripped Function Overloading Out of Our AI Toolchain Testing AI-Generated Code: How to Actually Know If It Works SaaS Churn Is Killing Your Business. Here Is What to Do About It (Without a Support Team) The Speed of AI Is No Longer Linear - And Self-Improving Models Are Why How to Implement RBAC for MCP Tools: A Practical Guide for Engineering Teams From Standard Quote to Persuasive Proposal: AI Automation for Arborists I built a CLI that scaffolds complete multi-tenant SaaS apps Axios CVE-2025–62718: The Silent SSRF Bug That Could Be Hiding in Your Node.js App Right Now The dashboard that ended our friendship Data Pipelines Explained Simply (and How to Build Them with Python) The Hidden Cost of AI Systems Nobody Talks About. undefined vs undeclared, and how typeof behaves Switching from file-based jobs to NATS/Kafka in Rust without changing code io_uring Adventures: Rust Servers That Love Syscalls Why Agentic AI is Killing the Traditional Database The POUR principles of web accessibility for developers and designers Quantum Neural Network 3D — A Deep Dive into Interactive WebGL Visualization How To Install Caveman In Codex On macOS And Windows Automation Pipeline Reliability: Why Your Workflow Breaks When Nobody Is Watching I Built an 'Open World' AI Coding Agent — It Works From ANY Folder From Freelancing to Product: A Tech Service Company's SaaS Transformation China's AI Giants: Adding Tencent Hunyuan & ByteDance Doubao to AI University (74 Providers) On the Vibe Coders and Their Lies clerk: Auto-Summarize Your Claude Code Sessions AI Weekly — 2026/04/10–04/17 | The Model Lockdown Is Here, but the Toolchain Is the Real Battleground AI 週報 — 2026/04/10–2026/04/17 模型封鎖潮來了,但工具鏈才是真戰場 Maybe this is how Open-Source apps are born... 🚀 Fine-Tune LLMs with LoRA and QLoRA: 2026 Guide tRPC v11 + Next.js App Router: End-to-End Type Safety Without the Boilerplate ShadCN UI in 2026: Why I Stopped Installing Component Libraries and Started Owning My Components SaaS Billing in React Server Components: Stripe + Supabase Without a Single `useEffect` Join our DEV Weekend Challenge — $1,000 in Prizes Across TEN winners! Submissions Due April 20 at 6:59 AM UTC. Implementing FSRS Spaced Repetition in Flutter + Supabase — Adding Memory Science to an AI Learning App "I Texted My Localhost From the Train — Claude Code Fixed the Bug Before I Got Home" I Built a Sales Prep AI and It Went Deeper Than Expected Design to Code #2: One JSON, Eleven Outputs Solving the 100M-Row Problem: A Summary Table Pattern for High-Volume Push Notification Logs Flutter Web With Wasm: What Actually Changes For Developers I Built 50 Royalty-Free Soundtracks for My Side Project in a Weekend Using AI Music Generation The Vibe Coding Security Checklist: 7 Things to Check Before You Ship Stop Letting Googlebot Guess Fix Your React App's SEO Right Desconstruindo o Streaming do LinkedIn: Como Criar um Engine de Extração de Vídeo de Alta Performance com HLS e FFmpeg (EDA Part-1) EDA (Exploratory Data Analysis) Explained With Real Life — Why Looking at Your Data Is the Most Important Step in Machine Learning Brand Relationship Management at Scale: Our 4-Touch Outreach System for 200+ Brands Why String.fromEnvironment() Might Return an Empty String in Dart JGuardrails 1.0.0 — Hardening Java LLM Apps Against Jailbreaks, Toxicity, and Prompt Injection Plan and Schedule a Full Week of Threads Content From One Claude Conversation Coding Cat Oran Ep3, Five Tables Changed Everything BFF模式详解:构建前后端协同的中间层 I'm done watching freelancers get buried by 200 proposals. So I'm building the alternative. This is my first post BFS Algorithm in Java Step by Step Tutorial with Examples Tracking LLM Pricing Monthly: An Open Dataset for 22 AI Models How We Measure Content ROI on a Comparison Site: Revenue Attribution Without Perfect Data Introducing Nova AI Ops: The AI-Native Operating System for SRE Teams I built a free desktop video downloader for Windows — Grabbit How Talkie OCR Helps Vision-Impaired & Dyslexic Users Read the World Around Them VRCFaceTracking安装和iPhone面捕配置教程,有bug Even CrowdStrike Can't See Your Agents The Automation Gold Rush: What n8n Workflows and Claude Are Opening Up for Developers Right Now
How I Built Clinical Trials API - From Public Data to RapidAPI in 2 Weeks
Rahul Ban · 2026-05-25 · via DEV Community

ClinicalTrials.gov - the U.S. government's registry of every FDA clinical trial - publishes 480,000+ studies as public domain data, updated daily. It's one of the most valuable datasets in healthcare. Pharma companies, CROs, healthtech startups, and academic researchers all need this data programmatically.

But the official ClinicalTrials.gov API v2? It's essentially a REST wrapper around a search engine built for human researchers. No structured eligibility parsing. No geographic radius search. No webhook alerts. Pagination that breaks when you change parameters mid-pagination. If you want to build anything beyond a basic keyword search, you end up scraping the website, downloading 2GB text file exports, or paying enterprise vendors $500+/month.

So I built the Clinical Trials API - a proper REST layer on top of ClinicalTrials.gov with structured eligibility, geo search, and webhook alerts. Here's how it went.

The Stack

  • Runtime: Python Workers (Pyodide, Redux memory snapshots)
  • Deployment: Wrangler CLI -> 330+ edge locations worldwide
  • Backend Data: ClinicalTrials.gov API v2 (public domain, no auth required)
  • Marketplace & Billing: RapidAPI
  • Pricing: Free / $49/mo (Pro) / $199/mo (Ultra)
  • Average Response: 350-500ms warm, ~1s cold start

What I Built

10 endpoints across 4 functional groups:

Endpoint Description Tier
GET /v1/trials/search Full-text + fielded search, cursor pagination Free
GET /v1/trials/{nct_id} Complete trial detail with outcomes, locations, references Free
GET /v1/trials/nearby Geographic radius search by lat/lon, distance-sorted Free
GET /v1/stats Aggregate statistics by phase, status, sponsor, study type Free
GET /v1/conditions Medical condition autocomplete browser Free
GET /v1/health Health check, no auth required Free
GET /v1/trials/{nct_id}/eligibility Structured eligibility criteria parsing Pro
GET /v1/alerts List active webhook alerts Pro
POST /v1/alerts Create a webhook alert for new trials Pro
DELETE /v1/alerts/{alert_id} Delete a webhook alert Pro

The Hard Parts

Challenge 1: Parsing Free-Text Eligibility Criteria

This was the hardest technical problem. ClinicalTrials.gov stores eligibility criteria as free text - often a single paragraph or bulleted list with no structure at all:

"Inclusion Criteria: Histologically confirmed triple-negative breast cancer. Age >= 18 years. ECOG performance status 0 or 1. Adequate hematologic and end-organ function. No prior systemic therapy for metastatic breast cancer. Exclusion Criteria: Prior immunotherapy for breast cancer. Active autoimmune disease requiring systemic treatment. Untreated or symptomatic CNS metastases. Pregnant or breastfeeding."

I needed to parse this into structured, machine-readable criteria objects that a patient-matching algorithm could actually use:

{
  "inclusion_criteria": [
    {"category": "Age", "text": "Age >= 18 years", "criterion": "18 years and older"},
    {"category": "Condition", "text": "Histologically confirmed triple-negative breast cancer", "criterion": "Triple-negative breast cancer confirmed by histology"},
    {"category": "Performance Status", "text": "ECOG performance status 0 or 1", "criterion": "ECOG 0-1"}
  ],
  "exclusion_criteria": [
    {"category": "Prior Treatment", "text": "Prior immunotherapy for breast cancer", "criterion": "No prior checkpoint inhibitor therapy"}
  ]
}

My approach: a heuristic NLP pipeline. First, split the raw text into candidate criteria using regex patterns that match bullet points, numbered lists, line breaks, and sentence boundaries. Then classify each candidate into one of 8 categories (Age, Gender, Condition, Lab Values, Prior Treatment, Performance Status, Organ Function, Other) using keyword matching and rule-based logic. Finally, generate a normalized concise form.

Accuracy is about 80-85%. The remaining 15-20% get category "Other" with raw text preserved. A proper ML model would do better, but I wanted to ship v1 and iterate based on feedback. The structured parsing is on the Pro tier ($49/mo) because it's the core value-add that justifies a paid plan.

Challenge 2: Geographic Search Without a Geocoding Budget

ClinicalTrials.gov lists facility addresses (name, city, state, country) but doesn't provide lat/lon coordinates. To build a geographic radius search, I needed to geocode every facility.

The problem: there are ~500,000 unique facility addresses in the database. Commercial geocoding APIs charge per-1,000 lookups. Free geocoding APIs have strict rate limits (~1 request/second).

My approach: a pre-built lookup table. I ran a Python script over 3 days that geocoded all addresses against a free geocoding API with request throttling. The resulting table maps facility addresses to lat/lon and is loaded into the worker's module-level memory. When you query /v1/trials/nearby, the worker:

  1. Searches ClinicalTrials.gov for trials matching your filters
  2. Looks up each facility's coordinates from the in-memory table
  3. Calculates Haversine distance from your search center
  4. Sorts by distance and returns the results

The table is ~20MB in memory but only contains facilities with active trials. Response time for a nearby search is 400-600ms including the upstream API call and distance calculations. Not instantaneous, but way faster than you'd get geocoding on-the-fly.

Challenge 3: Pricing - Free Tier That's Actually Useful vs. Revenue

The eternal indie dev dilemma. How do you make the free tier useful enough to attract users but restrictive enough to drive conversions?

My approach: give away the data access, charge for the value-add processing.

The free tier includes 7 of 10 endpoints. You can search trials, get details, do geographic searches, browse conditions, pull aggregate stats - everything you need to build a real prototype. 100 requests/day, 3 saved webhook alerts. No credit card, no expiry. The free tier should deliver the "aha moment": "holy crap, I just queried 480K trials in one API call."

The Pro tier ($49/mo) unlocks the features that save real engineering time: structured eligibility parsing (instead of you building a regex parser) and expanded webhook alerts (25 instead of 3, with 6-hour check frequency instead of daily).

Ultra ($199/mo) for companies where clinical trial data is mission-critical. Higher request limits, unlimited alerts, priority support, dedicated SLA.

The conversion hypothesis: free tier users hit the 100 req/day limit or need eligibility parsing, and $49/mo is cheaper than one hour of developer time.

What I'd Do Differently

  1. Geocoding strategy. Spending 3 days rate-limiting against a free geocoding API was dumb. I should have paid $50 for a commercial geocoding service and been done in 2 hours. The "I'll save money by doing it free" instinct is strong in indie devs, but your time is worth more.

  2. API design - separate eligibility endpoint vs. inline. I chose a separate endpoint (/v1/trials/{nct_id}/eligibility) because parsing adds ~200ms of processing, and free tier users shouldn't pay the latency cost for a feature they can't access. In retrospect, returning parsed eligibility inline in the trial detail endpoint would be cleaner. Developers expect one request, not two. I may merge these in v2.

The Numbers (So Far)

Just launched. Real numbers coming soon.

Metric Value
Subscribers 0 (day 1)
API Calls Served 0 (day 1)
Revenue (MRR) $0 (day 1)
Uptime 99.9% (target)
Avg Response 350-500ms
Infrastructure Cost $0 (CF Workers free tier)

I'll update this with real numbers in 30 days.

Try It

https://rapidapi.com/capifactory-capifactory-default/api/clinical-trials-api - free tier, no credit card. Takes 30 seconds to get an API key and make your first call.


If you're building a healthtech product and need clinical trial data, I'd love to hear what endpoints would make this genuinely useful for you. I ship fast - if you need something that doesn't exist yet, tell me and I'll probably have it live within 48 hours.