Inspiration
The inspiration for the SQL & Express JS Sorter project came from the classic problem of sorting lists, which is fundamental in computer science. I wanted to tackle this problem using modern web technologies and make it interactive. By sorting a list of hackathons, I could also create a useful tool for the hacking community, helping them easily find and organize events.
What it does
The SQL & Express JS Sorter is a web application that allows users to view a list of hackathons in three different ways: unsorted, alphabetically sorted, and chronologically sorted. The app fetches data from a SQL database and displays it in a user-friendly interface, enabling users to switch between different sorting options seamlessly.
How we built it
I built the project using SQL for data storage and management, Node.js and Express.js for the backend server, and HTML/CSS for the frontend interface. The process involved:
- Setting up a SQL database to store hackathon data.
- Creating an Express.js server to handle API requests.
- Writing SQL queries to fetch unsorted, alphabetically sorted, and chronologically sorted data.
- Building a simple frontend to display the data and allow user interaction.
Challenges we ran into
One of the main challenges I faced was ensuring that the data retrieval and sorting operations were efficient and performed well with potentially large datasets. I also had to ensure that the frontend interface was intuitive and responsive, providing a smooth user experience.
Accomplishments that we're proud of
I am proud of successfully integrating SQL and Express.js to create a dynamic and interactive web application. The sorting functionality works seamlessly, and the user interface is clean and easy to navigate. Additionally, I managed to tackle a classic computer science problem with a modern approach, showcasing my skills in web development and database management.
What we learned
Throughout this project, I learned a lot about the intricacies of SQL queries and how to optimize them for performance. I also gained deeper insights into building web applications with Node.js and Express.js, particularly in how to manage data retrieval and rendering efficiently. Moreover, this project reinforced the importance of creating user-friendly interfaces to enhance the overall user experience.
What's next for SQL & Express JS Sorter
Moving forward, I plan to add more features to the SQL & Express JS Sorter, such as allowing users to filter hackathons based on location, type, and other criteria. I also aim to implement user authentication, enabling users to save their preferences and personalized lists. Additionally, I want to explore deploying the application to the cloud to make it accessible to a wider audience and ensure it can handle more extensive datasets.
Log in or sign up for Devpost to join the conversation.