Clover Luo
Posted on October 3, 2024
Hey Dev Community! đź‘‹
I’m excited to share the start of my journey into backend development and SQL through a new project I’ve recently kicked off called Blotz Task App. This group project is an awesome opportunity for me to dive deeper into full-stack development, and I’m taking the lead on backend development and database management. You can check out the project here on GitHub.
Why the Blotz Task App?
I’ve always been passionate about learning all aspects of web development, and while I’ve spent a good amount of time working on frontend projects (JavaScript, React, etc.), I wanted to expand my horizons by getting more hands-on with the backend and working closely with SQL databases. Blotz Task App is a task management tool that aims to help users efficiently organize and track their tasks. For me, this project is more than just a tool—it’s a learning experience.
My Role: Backend & Database
As the one leading the backend, I’m responsible for ensuring that the data flows smoothly between the frontend and the database. I’ve been diving into C# and .NET Core, which has been an exciting challenge so far. I’m also getting my hands dirty with SQL Server, learning to design and optimize a scalable database schema that can handle user-generated tasks and interactions efficiently.
I’ve always believed that backend development is like the backbone of any great application—without a solid foundation, the entire app can fall apart. My goal for this project is to make sure we have a backend that is robust, scalable, and reliable.
What I’ve Learned So Far
In just the short time I’ve been working on this project, I’ve already picked up a ton of new knowledge about backend systems and database management. Here are a few key takeaways:
- Understanding RESTful APIs: I’m building REST APIs to ensure smooth communication between the frontend and the database, which has given me a clearer understanding of how different parts of an app connect.
- SQL Query Optimization: I’ve started learning how to optimize SQL queries for better performance, especially when working with large datasets. I’m finding this part really fascinating because it directly impacts the app’s speed and responsiveness.
- C# and .NET Core: I’m still deepening my understanding of C# and .NET Core, which have proven to be powerful tools for backend development. The learning curve has been steep, but that’s what makes it so rewarding!
Next Steps & Learning Goals
This is just the beginning! As I continue working on this project, I plan to:
- Explore Entity Framework Core for database migrations and optimizations.
- Experiment with Azure SQL Database for deploying a cloud-based solution.
- Keep refining my backend architecture for maximum efficiency and scalability.
Full-Stack Development Passion
Although I’m focusing on backend and databases for now, I’m deeply passionate about full-stack development. Understanding how every part of an application works—both frontend and backend—is what drives me. I believe that being well-versed in both areas will allow me to build more complete and cohesive applications in the future.
I’ll continue to document my learning process and challenges in this project. If you’re interested in following along or contributing, feel free to check out our repository here. Stay tuned for more updates!
Happy coding! ✌️
Posted on October 3, 2024
Join Our Newsletter. No Spam, Only the good stuff.
Sign up to receive the latest update from our blog.