Project Description
I’m building an online gallery where visitors can browse an extensive catalogue of paintings, leave star-based ratings, and exchange thoughts in a comment section. The collection will eventually run into the tens of thousands of works, so I need a back-end architecture that scales gracefully; I’m open to either SQL or NoSQL and would like your guidance on which engine, schema strategy, and indexing approach best fits heavy read/write traffic.
On the front end I want an artistic, colourful aesthetic that mirrors the subject matter yet stays responsive and accessible on desktop, tablet, and mobile. Think smooth gallery transitions, bold palette choices, and fluid animations that never compromise load speed.
Key functions the first release must deliver:
• Rate paintings (1–5 stars, one vote per user)
• Comment on each painting with basic moderation tools
• Ranking
You’ll handle:
• Database design and optimisation, plus recommendations on SQL vs NoSQL
• REST or GraphQL API layer with authentication and role management
• Front-end build using a modern framework (React, Vue, or similar) styled to the brief
• Cloud deployment and CI/CD pipeline on AWS, GCP, or Azure, with logging and automated backups
• A lightweight admin dashboard so I can curate paintings, review comments, and export rating data
Please share comparable projects, your preferred tech stack, and any suggestions for keeping response times low even as the library grows. I’m ready to start as soon as we agree on the approach and milestones.