Im making a time registration application. The goal is to connect the exsisting users in the database to the web application. The current software that im building on is called Microsoft Access. In this software they handle projects/storage of inventory/orders. Once a user is logged in he/she should be able to see all the projects they are linked to, each project is displayed in a block item. Once clicked on the item it should store the start time value and when clicking again it should store the EndTime value and calculate the time spend working on a project.
I did the initial setup of the project in lovable to get a grasp of the workflow. But right now im struggling on how to make the connection between the web application and the sql. Does anyone know a way to make the supabase connect to the sql database?