Design Solutions

I stareted by devloping a wireframe mockup of the main page, where students data would be aggergated into a single student view. By building this wireframe, it would help establish a goalpoint; This could then be used to understand what type of data the application was going to need to be able to handle, helping establish what is needed for the tech stack.

After devloping the inital mockup, I perposed a few diffrent database softwares to explore as possibilites for my project.

I'm still determening what exact solution I need to use, but have mostly ruled out s3 and timescale, as the former is not really needed since the blob data should be stored secruely in the school, ans the latter (timescale0) is proprietery. I'm trying to exculusivley use open-tech. This has left psql as the database solution (which I might use with a wrapper like superbase and the js library prisma.js). Next, I was left to build. I decided to use NextJs (A metaframwork for react), as it is industry standatd. This is not useally my first choice, as svelte (another javascript web framework) is my perfered framework, but i wanted to explore a new technolgy and thought that the react ecosystem may be invaluable for this project. I then made a skeleton app with fake data. This is where I currently am.