This Python script enables the collection and logging of data from an MPU6050 sensor while also integrating with the Supabase database for storage. Below is an overview of its functionality:

1. Installation:

   • Ensure you have Python installed on your system.
   • Install the required dependencies using pip:

     pip install mpu6050 supabase-py
     

2. Usage:

   • Import the necessary modules at the beginning of your Python script:

     import mpu6050
     import time
     import json
     from supabase import create_client

   • Initialize the MPU6050 sensor object with its specific address:

     mpu6050_sensor = mpu6050.mpu6050(0x68)

   • Establish a connection to your Supabase database by providing the URL and API key:

     supabase_client = create_client("YOUR_SUPABASE_URL", "YOUR_SUPABASE_API_KEY")

   • Run the script to start collecting data from the sensor and storing it locally in a file named "sensor_data.txt". Once the specified number of readings is reached, the data is uploaded to the Supabase database:

     python sensor_data_logger.py

3. Functionality:

   • Calibration: The script includes a function to calibrate the sensor by averaging a set number of readings. This ensures accurate data collection by compensating for sensor drift.
   • Data Collection: It continuously reads sensor data, applies calibration offsets, and logs it to a local file in JSON format. Additionally, it uploads batches of collected data to the Supabase database at specified intervals.
   • Supabase Integration: Data collected from the sensor is uploaded to a Supabase database table named "Raw" for further analysis and storage.

4. Customization:

   • Adjust the NUM_CALIBRATION_READINGS variable to change the number of readings used for calibration.
   • Modify the Supabase URL and API key to connect to your specific Supabase project.
   • Customize the script according to your specific sensor setup and data logging requirements.

5. Dependencies:

   • mpu6050: Python library for interfacing with the MPU6050 sensor.
   • supabase-py: Python client library for interacting with the Supabase database.