This past week I added more functionality to the SQLite database. After reading some questions from the instructors we decided it would be useful to have the data stored in stable storage rather than volatile memory in the case that we are unable to send all the data to AWS before the trip ends and need to complete the transfer another time. I also added methods to insert data and select data we have not read yet. I have also written a basic implementation for the rpm analysis function which checks how close the rpm is to optimal torque as well as a basic motion analysis function that measures the efficiency of the vehicle’s acceleration and braking patterns. Additionally, I have been working on implementing the turning analysis function by using the steering wheel angle and specific specs about the vehicle we are using (steering ratio and wheelbase) to calculate the car’s orbital angular velocity to identify when a car has made a turn. Lastly, I received the GPS unit and started reading the documentation about how to physically attach it to a RaspberryPi and which dependency libraries need to be installed in order for it to work properly.