Consider migrating database from H2 to SQLite

[nanotaboada]

Description

Analyze and migrate the current in-memory H2 database to SQLite for persistence. Evaluate the pros and cons of using SQLite and ensure that the transition will not break any existing functionality.

Acceptance Criteria

• Migrate the database schema from H2 to SQLite.
• Update configuration files to support SQLite as the primary database.
• Test existing data operations and ensure data is correctly migrated.

Resources

• 🔗 In-Memory Databases in Java
• 🔗 Spring Boot with SQLite