Week 31
Project: Linguistics Language Center
Started on: Oct 13, 2023
Staff Guidance: Chris
Description: The project aims to access the routes of each website page in Laravel PHP to examine whether there should be any optimization of the database query structure. Currently, the recommended practice is to ask for a table and database before rendering the view to ensure that the client server does not need to make a lot of requests back to the database server.
I was able to access almost all of the routes on the website except the route that starts with ‘lexicon/{lex_slug}’. I tried a lot of ways to examine the lex slug in the route; however, it was very hard for me to access the database and query. Therefore, I think I need to ask Chris how to do this when he gets back.
The results of the routes I have examined so far are pretty good with an average of 14 queries with a range from 5 to 22 queries. There is one route that produces 63 queries, so I may need to ask Chris to look at this route again.
Training: Project Z
Started on: Oct 12, 2023
Staff Guidance: Chris
Description: In this training, I continued to set up the authentication page, project creation, and delete function. My next task would be to pass the data to the Learn More Page.
USername: Brad@gmail.com
password: 23456