Site: https://substancewiki.org Source: https://github.com/yagcioglutoprak/substance_wiki
The database covers 381 substances with structured data including dosage tables by route of administration, duration timelines, 14,967 interaction safety ratings, 240+ catalogued subjective effects, experience reports, and community insights aggregated from Reddit.
Tech stack: Next.js 16 (App Router), PostgreSQL via Prisma, Tailwind CSS. Content is CC-BY-SA 4.0. The whole codebase including the database schema and seed scripts is public.
Some technical decisions that might interest HN:
- Interaction checker is backed by ~15K pre-computed combination records, not runtime calculation - Community insights are built from Reddit data via the Arctic Shift archive, run through a classification and enrichment pipeline - Programmatic SEO generates comparison pages, combo guides, and concept pages from the underlying data - Dynamic OG images generated per-page via @vercel/og - JSON-LD structured data on every page type (WebSite, Article, BreadcrumbList, FAQPage)
Feedback welcome on the data model, the UX for presenting safety-critical information, or anything else.