Built a console‑based task management application in Python that implements full CRUD operations (Create, Read, Update, Delete) using SQLite. The system allows users to add, view, update, and delete tasks, with all data securely persisted in a local database file (tareas.db).

Managing tasks without persistence leads to data loss between sessions. The challenge was to design a lightweight, reliable system that ensures tasks remain stored locally, while providing a simple interface for everyday use.

Database Integration: Used Python’s sqlite3 module to interact with a relational database.

CRUD Operations: Implemented methods for adding, retrieving, updating, and deleting tasks.

OOP Design: Encapsulated database logic in a DBManager class for clean architecture.

Error Handling & Security: Applied parameterized queries to prevent SQL injection and added exception handling for invalid inputs.

Persistence: Ensured tasks remain available across sessions by committing changes to tareas.db.

Delivered a robust task management system with a console menu interface. Users can manage tasks seamlessly, while the system guarantees persistence and safe closure of database connections.

Reliability: Tasks remain stored between program runs.

Security: Safe parameterized queries mitigate SQL injection risks.

Usability: Simple console interface makes task management accessible.

Business Value: Demonstrates ability to design lightweight, persistent applications for productivity workflows