I built an encyclopedia of 376 psychoactive substances with Next.js and PostgreSQL

Finding reliable information about psychoactive substances shouldn't require 15 open tabs. PsychonautWiki for pharmacology, TripSit for interactions, Erowid for trip reports, Reddit for community knowledge — I wanted one place where all of that connects. So I built SubstanceWiki . What it covers 376 substances with detailed profiles 15,015 interaction pairs with safety ratings 240 catalogued subjective effects across 7 categories 2,748 experience reports from real users 23,520 aggregated community posts from Reddit and forums 21 combo guides for common and high-risk combinations 10 side-by-side substance comparisons Every substance page includes dosage tables by route of administration, duration timelines, subjective effect profiles, interaction safety data, and community context. The tech stack Next.js 16 with App Router and Turbopack Prisma + PostgreSQL (hosted on Neon) Tailwind CSS + shadcn/ui for the interface Vercel for deployment Dynamic sitemap generation, JSON-LD structured dat