I built a Stack Overflow for gamers as a solo dev — here’s the stack and why

Short summary

A solo developer built LootQuery, a Stack Overflow-style Q&A site for PC gaming problems. The stack is Next.js App Router, Prisma, PostgreSQL, and Meilisearch for search, all self-hosted via Docker Compose behind Caddy. Key challenges include duplicate question detection and the cold-start problem, addressed by seeding useful content and using typo-tolerant search to surface existing answers.

• •LootQuery is a gaming-focused Q&A site built solo with Next.js, Prisma, Postgres, and Meilisearch
• •Self-hosted via Docker Compose behind Caddy for predictable costs
• •Key challenges: duplicate detection and cold-start problem, mitigated with good search and seeded content

Generated with AI, which can make mistakes.