StackRigs
An open index of what developers are actually building
Stack
Infraestructura
- Hosting
- Raspberry Pi 5 (self-hosted)
- Database
- SQLite with Litestream replication
- CDN
- Cloudflare
- CI/CD
- GitHub Actions
- Monitoring
- Custom Go metrics + Prometheus
Herramientas IA
- Claude (claude-sonnet-4-20250514)
Code review, architecture decisions, writing build log entries
- GitHub Copilot
Inline code completion during development
Que funciona
SQLite on a Pi 5 handles 500+ req/s without breaking a sweat. The single-binary Go deployment means zero dependency management. Cloudflare caching + Litestream backups give us enterprise-grade reliability on a $60 computer.
Que fallo
Initial attempt with PostgreSQL was overkill. Memory usage on the Pi was too high and the connection pool kept timing out under load. SQLite with WAL mode solved everything.
Que cambiaria
Would start with Astro from day one instead of trying a SPA first. The island architecture is perfect for a content-heavy site like this. Also would set up Litestream earlier instead of manual backups.
Updates
First 100 builds indexed
Reached the milestone of 100 build logs submitted. The community is growing organically through word of mouth.
Migrated frontend to Astro 5.18
Moved from the SPA prototype to Astro with islands. Page load times dropped from 2.1s to 340ms.
Added Litestream for continuous backups
SQLite WAL files now replicate to Cloudflare R2 every 10 seconds. Total cost: $0.
Dropped PostgreSQL for SQLite
After weeks of fighting connection pooling on the Pi, switched to SQLite. Best decision of the project.
Why not just use a spreadsheet?
Considered whether a Google Sheet would suffice. Decided structured data + API access + embeddable badges justified building a proper tool.
