Ryan’s Status Report 4/3/21

This past week I was able to integrate the SQLite database I created into the RaspberryPi. I have tested the previously build functionality: creating a connection to the database, creating tables, inserting data, and reading new data as it comes in All these functions work as expected. Over the past week, we discussed how a few pieces of data should be gathered at a higher frequency from the OBDII port to get a more accurate analysis. Because of this, I have been redesigning the database to use many, separate tables that hold a specific type of data instead of one table with many columns to hold all the data.  This more complex database schema should save space because if we use one table but some data is collected more frequently than others, we will have many empty rows in the table. Additionally, I received the GPS unit and read more documentation about how to integrate it onto a RaspberryPi. I went to campus to solder the pins used for power and communication with the RaspberryPi. I have not connected it yet because the cable I need is currently in the mail, but I created the python program that should be able to periodically receive GPS latitude and longitude data and store that data in the database to be used in the speed analysis function.