M6 SQL Challenge
Dynamic Photo Gallery
Moving beyond static design to build a database-driven application.
Link to ProjectThe Mission
In this M6 challenge, I aimed to break through the limits of simple front-end design and dive into the core of back-end development: database management.
Over an intense 42-hour learning and implementation process, I learned SQL syntax from scratch and utilized Cloudflare D1 (SQLite) to construct a dynamic photography gallery. The goal was to transform a static HTML display into an application that interacts with a server in real-time, allowing me to implement data access and management logic myself, rather than just handling surface-level visuals.
Project Highlights
Tech Stack
Built using Cloudflare D1 (SQLite) integrated with a responsive Frontend (HTML/CSS/JS). Bridging the gap between static hosting and dynamic data.
Troubleshooting
Encountered and solved complex bottlenecks, specifically regarding static hosting limitations and establishing secure database connections.
Growth
A major milestone moving from "designing interfaces" to "designing systems." This project laid the foundation for building complex applications in the future.
My Reflection - "Although the process involved many technical hurdles, these challenges strengthened my ability to troubleshoot. I successfully built a responsive personal brand site that achieves front-end and back-end integration."
Return to Portfolio →