What it does
Searches Jobs by Company, Job Position, or Location:
Users can query the database for jobs from a specific company, job position, and location of the job.Filter by Pay and Pay Period:
Users can filter jobs by either hourly or yearly wage and can specifiy a minimum pay threshold.Shows Jobs Based on User Filters:
The API combines all provided filters to return only the jobs that matches the user's criteria.
How we built it
Frontend:
React, Node.jsBackend:
Python, PostgreSQLAPIs:
FastAPI, SQLAlchemyCloud Services:
AWS, Neon
Challenges we ran into
One of the biggest challenges our team faced was that most of us were using the tools in this project for the first time. While some team members had some prior experience with certain tools, we had to quickly learn FastAPI, database querying, and how to integrate the backend with the frontend. Balancing learning new tech while building a working project made us work together closely and solve problems under the time constraints.
Accomplishments that we're proud of
Despite being new to most of the tools, our team successfully built a functional project from scratch. We not only learned how to write a frontend and backend and then integrate them, but we also learned to collaborate efficiently under tight deadlines. In the end, we had a working product, gained skills in FastAPI and database management, and strengthened our teamwork, all of which that can help us in our future projects.
We also managed to build and populate a database that communicates with an application's backend.
What we learned
During this project, we learned how to write a frontend and backend and how to link them. We also learned how to import raw CSV data into a database. We learned how to write the backend with FastAPI and the frontend interface was built with React and Node.js to handle and display custom user input and output. We also gained experience with deploying and testing database queries efficiently, which improved our understanding of backend data flow and API design.
What's next for J*b Elephant
There's a lot of avenues open for the application. We can definitely polish out the front end and improive user experience. The database can also be expanded to fit more job listing information.
Log in or sign up for Devpost to join the conversation.