Built a train spotting social app with Supabase and I would love some feedback
I’ve been teaching myself web development over the past few months and wanted to share my biggest project so far.
I’ve built RailSnap, a social platform for train enthusiasts to upload sightings, share photos, and help build a community fleet database.
Supabase has handled almost everything on the backend, including:
Authentication
PostgreSQL database
Row Level Security
Image storage
User profiles
Real-time data handling
Some of the features I’ve recently finished include:
Multi-photo uploads (up to 5 images per sighting)
Fullscreen image viewer with swipe, zoom and keyboard navigation
Search by train class, unit number, station, operator and usernames
Community moderation tools
Pending verification workflow for new train classes
Duplicate upload prevention to reduce accidental double posts
The app is currently in alpha and has started getting its first real users through Reddit. Every bit of feedback has helped shape new features.
This project has been an incredible learning experience, especially around database design, RLS policies and structuring a larger Next.js application with Supabase.
I’d love any feedback from the community—whether it’s on the database structure, security, feature ideas, or anything else that stands out.
https://railsnap.vercel.app
Thanks to everyone behind Supabase. It’s made building something like this far more approachable than I expected.