Andrei's recent projects

NovelNotes

Feb 2024

Collaborated with a team to build a book review website for user-generated content. Guests can search for books or users, and read book reviews or look at users' profiles. Logged-in users can leave reviews and write comments. They can also get book suggestions based on their reviewed books.

Our tech stack includes Flask (Python), PostgreSQL, JavaScript, Jinja2, and PureCSS. We incorporated a few APIs to enhance user experience, such as the Google Books API, the OpenAI (ChatGPT) API, and the Gravatar API for user profiles. My work focused on building the user profile experience, including the backend services, front-end interface, and database interactions.

Survey

Jan 2024

Simple survey website. Users can opt to take the survey or not. Used Flask for the backend, and PureCSS, jinja2, and Chart.js for the front end. Data is stored on Postgres on the hosted website. If you would like to see infographics about user answers, go to this webpage on the site (if you know how to do this): /admin/summary.

This website will take more than a few seconds to load because of the hosting service and free tier plan it is on. Planning to move it soon. Might help to refresh the page after 10 - 20 seconds.

Package Delivery Simulation

Dec 2023

Collaborated with a team to build a package delivery simulation. We use a preexisting simulated map of the University of Minnesota -Twin Cities campus, and render it on the browser. We can load in different types of predetermined entities. Users can schedule a delivery on the schedule page.

We implemented different path-finding strategies that the drone can use to deliver the package. I was in charge of implementing the drone's battery and charging station logic. When the drone's battery runs low, it will go to the nearest charging station to charge.

How to use the website:

  • Website may take up to 50 seconds to load (free hosting problems)
  • Use left/right mouse buttons to move, scroll wheel for zoom
  • Select which entity you want to view in the top right corner
  • Please stop the simulation when you exit or if you refresh the page
  • If the website or the battery percentage is glitching, please press the "Stop Simulation" button, then refresh the page!

Mobile Storefront

Nov 2023

A website for an imaginary small business. Customers can order a phone and see user reviews. An administrative page allows the owners to look at customer orders, complete the orders, and start/end a sale.

Currently, this website is not up. I am working on configuring it to a database on Cloudflare. Learning how to use Cloudflare workers to do this.