Eikon: Personal Photography Platform
- Built a personal photography platform with owner-only admin login for uploading and managing photos, while public visitors can browse the gallery, open photo detail pages, and share direct links.
- Implemented custom session authentication and secure direct-to-storage uploads where the server authorizes file writes without processing raw image bytes.
- Designed a PostgreSQL and Drizzle ORM photo metadata model with EXIF extraction, BlurHash placeholders, cursor-based pagination, and a Vercel Blob/Cloudflare R2 storage abstraction.
- Optimized the public gallery with cached API responses, image placeholders, responsive layouts, and adjacent-photo prefetching for fast browsing across grid, masonry, and detail views.
- Built a geotagged photo map view grouping photos by location with clustered markers, a click-to-expand place panel, and theme-aware map tiles for light/dark mode.
- Designed a PostgreSQL schema and migration history for photo metadata, many-to-many tags, durable login-rate limits, and lease-based upload jobs; added composite indexes, transactional writes, and stable cursor pagination through Drizzle ORM.