Overview
OpenTrials utilizes an in-browser WebAssembly (WASM) parser and reactive state engine to bypass traditional cloud database bottlenecks. Reconcile, validate, and analyze participant metrics instantly with zero configuration and total privacy.
Local-First Speed
Parses datasets directly within the client sandbox thread, delivering sub-millisecond response latency.
Zero Setup Required
No developer databases or keys needed. Upload and slice any operational dataset up to 100MB.
Reactive Insights
Demographic charts, ledger tables, and anomaly detectors update in real time as data is ingested.
Quick Start
Get operational and start analyzing clinical trial records in under two minutes:
1. Download Template
Acquire the standard clinical operational spreadsheet template to verify record structures.
2. Load Sandbox
Drop your CSV spreadsheet directly into the Sandbox Upload workspace to process fields.
3. Analyze Metrics
Explore clinical demographics, longitudinal trends, and segmentations instantly.
Architecture
OpenTrials utilizes an isolated sandbox dataflow pipeline to process clinical datasets without exposing proprietary participant information.
CSV Parsing
Local block streaming.
WASM Schema
Type & outlier auditing.
IndexedDB
Encrypted offline store.
Reactive UI
Dynamic canvas charts.
Uploading
The ingestion sandbox processes spreadsheets in high-efficiency block streams. Review our ingest limits below to ensure smooth parsing:
CSV Structure
To guarantee zero ingestion mismatch, standard CSV uploads must follow the headers defined below:
record_id,age,segment,cohort,timestamp R-1001,43,enterprise,alpha,2026-02-11 R-1002,51,consumer,beta,2026-02-14 R-1003,37,enterprise,beta,2026-02-15
Validation
The schema validator enforces type checking and records integrity automatically:
Must be a unique alpha-numeric string. Duplicate rows preserve the latest audit state.
Must be a number between 1 and 120. Invalidate entries trigger outlier alerts.
Must match either 'enterprise' or 'consumer' exactly. Configures dashboard filters.
Cohort label (e.g. 'alpha', 'beta'). Maps group datasets in analytical displays.
Security
Our local-first framework ensures clinical datasets remain fully sandboxed inside the local runtime.
Client-Side Isolation
Zero database calls or cloud servers are used during CSV operations, ensuring compliance.
Data Expiry Enforcements
IndexedDB stores expire automatically upon closing the browser tab, protecting data integrity.
CLI Usage
Fetch standard dataset outlines via terminal commands directly to speed up diagnostic tasks:
curl -O http://localhost:3000/demo-dataset.csvDeployment
Deploy OpenTrials static outputs securely to static environments or host inside isolated local private intranets:
Static Sites (Vercel / Netlify)
Deploy build bundles instantly. The server serves purely static templates, driving top-tier rendering speeds and low infrastructure cost.
Self-Hosted Docker Stack
Run standard multi-stage builds locally. Serves assets via internal Nginx, locking down intranet access for extreme clinical trial isolation.