### Purpose - Create a new database for OpenOS that can handle high amounts of unstructured data for user predictions. ### Principles - Fast - The backend must work fast and improve the performance of the website - Timeline - Don't spend too long on this task and try to finish it up in a requisite timeline ### Outcome Visioning - In the next 10 days try to create a new highly performant backend that handles the user prediction data. This backend is unstructured in that we can add any keys or columns we want but at the same time provides the performance that a relational database might be. ### Brainstorming - What do I already know about this project? - I know what the requirements are and some understanding of how relational and non relational databases work. - What don’t I know that I need to find out? - I don't know how to set up a hybrid database - I need to understand how to set it up on AWS - Who can I talk to who might provide insights? - I can speak to Nishant about this and if there's anything new that I should use or consider. - What can I read or listen to for relevant ideas? - Need to research a bit on what are the current technologies ### Actions - [x] Research on best backend infrastructure for the task at hand 📅 2023-08-23 ✅ 2023-08-23 - [x] Provision a new database on Cosmos and create models for each model ✅ 2023-08-29 - [x] Test the speed of the backend after uploading growth school predictions ✅ 2023-08-29 - [x] Create backend endpoints for querying user predictions ✅ 2023-08-29 - [x] Update the endpoints from frontend and update the results ✅ 2023-08-29 - [x] Migrate JoinMyTrip to new backend ✅ 2023-08-31