📅 2024-02-01 — Session: Updated Cloud SQL Database Class and Deployment Setup
🕒 05:40–06:25
🏷️ Labels: Cloud Sql, Google App Engine, Openai Api, Database Security, Python Deployment
📂 Project: Dev
⭐ Priority: MEDIUM
Session Goal: The session aimed to update and secure the database class for Google Cloud SQL, set up a Cloud SQL instance, and deploy a Python application on Google App Engine.
Key Activities:
- Updated the database class to integrate with Google Cloud SQL, focusing on security and best practices for managing credentials.
- Set up a Cloud SQL instance, including database creation and user management, with an emphasis on security best practices.
- Reviewed the updated database class to ensure it follows best practices for security and connection management.
- Deployed a Python application on Google App Engine, configuring environment variables in the app.yaml file for secure database connections.
- Explored enhancing the Evaluator Class with OpenAI API, focusing on authentication, model selection, and error handling.
- Compared different GPT models (GPT-3, GPT-3.5, GPT-4) for evaluating student responses, detailing their suitability and usage.
Achievements:
- Successfully updated the database class and deployed the application on Google App Engine.
- Established a secure and efficient workflow for managing database connections and credentials.
Pending Tasks:
- Further integration of OpenAI’s GPT API into the Evaluator Class, focusing on refining model selection and usage analytics.