Add Database

[Justintime50]

Currently logs are stored to actual log files with the name of the pipeline ID which is just a randomly generated ID.

Structure:

logs
    project_1
        1234567890.log
        0987654321.log
    project_2
        ...
    ...

This is great for now, but we should instead be saving log data to a database.

Brainstorming some initial columns and tables:

logs

• id [int]
• pipeline_id [int]
• log_content [text]
• created_at [datetime]

users

• id [int]
• user_id [int]
• email [varchar]
• password [varchar]
• created_at [datetime]
• updated_at [datetime]
• deleted_at [datetime]

pipelines

• id [int]
• pipeline_id [int]
• success [bool]
• configuration [text]? (store the JSON configuration)
• user_id [int] (user who created the pipeline... how is this derived?)
• pipeline_time [varchar] (time the total pipeline took to build)
• created_at [datetime]

[Justintime50]

I kind of like that Harvey is super lightweight and stateless at the moment. I'm going to close this for now; however, we may revisit a database in the future.