Skip to content

Migration to new data pattern #63

@phi-line

Description

@phi-line

As discussed with @TryExceptElse, we will move to an easier to traverse schema for the database. As we move away from a course first system, we will decouple from the section data being buried under their departments and course keys.

Comparison between old and new format:

Old New
.
├── dept
│   ├── course
│   │   ├── section 
.
├── section

This switch allows for the easy filtering of section data like teacher, time, and room data. Advanced multi-step queries can be constructed using this method as well. Additionally, the new data format will not require tables to be used for each department.

Metadata

Metadata

Assignees

No one assigned

    Labels

    improvementEfficiency and cleanliness

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions