Currently, the project lacks a proper storage solution. We need to implement an SQLite-based storage system to persist data efficiently. Although a few tests have been conducted, there is no actual implementation in place.
[x] Design the database schema
[x] Create the SQL DDL
[x] Create the Port and Adapter to access the necessary functions
[x] Update the codebase to use this implementation
Currently, the project lacks a proper storage solution. We need to implement an SQLite-based storage system to persist data efficiently. Although a few tests have been conducted, there is no actual implementation in place.