Run an SQLite database in .plan/ which stores plans
Reasoning
We can benefit from SQL and potentially an ORM for managing plans
Implementation
Build some sort of persistence layer which executes SQL queries against the SQLite database and returns instances of Plan. The persistence layer should implement a few methods like get_by_id, get_all, update_by_id, delete_by_id, etc..
Current Situation
Plans are stored as JSON files in
.plan/plans/Enhancement
Run an SQLite database in
.plan/which stores plansReasoning
We can benefit from SQL and potentially an ORM for managing plans
Implementation
Build some sort of persistence layer which executes SQL queries against the SQLite database and returns instances of
Plan. The persistence layer should implement a few methods likeget_by_id,get_all,update_by_id,delete_by_id, etc..