Developed Database Structure and Resolved Python Dependencies

2 min read

📅 2024-10-26 — Session: Developed Database Structure and Resolved Python Dependencies

🕒 19:45–20:50
🏷️ Labels: Database, Python, Or-Tools, Scheduling, Virtual Environment
📂 Project: Dev
⭐ Priority: MEDIUM

Session Goal:

The session aimed to design a robust database structure for a scheduling tool and resolve Python dependency issues related to the or-tools library.

Key Activities:

  • Database Design: Developed a DBML schema for a scheduling tool, including tables for tasks, time blocks, constraints, and user preferences.
  • CSV Output: Created CSV templates for the ‘constraints’ and ‘user_preferences’ tables, providing clarity on each column’s purpose.
  • Task Management: Outlined a constraints table to optimize task scheduling and productivity.
  • Python Library Installation: Resolved ModuleNotFoundError for or-tools by providing installation instructions and addressing compatibility issues with the protobuf package.
  • Virtual Environment Setup: Provided detailed guides for setting up a clean Python virtual environment, managing dependencies, and installing gspread and or-tools libraries.
  • Visual Schedule Representation: Created a visual schedule using a DataFrame to represent daily tasks and available work hours.

Achievements:

  • Successfully designed a comprehensive database schema for the scheduling tool.
  • Resolved installation and compatibility issues with Python libraries, ensuring a stable development environment.
  • Developed a visual tool for task scheduling to enhance productivity.

Pending Tasks:

  • Further refinement of the database schema based on user feedback.
  • Continuous monitoring and updating of Python dependencies to prevent future conflicts.

Graph View

Backlinks