Developed a console‑based inventory management system using Python and SQLAlchemy ORM. The solution abstracts away manual SQL queries, allowing developers to interact with the database as Python objects. This results in cleaner, more secure, and maintainable code for CRUD operations.

Traditional database interaction requires verbose SQL statements, which can be error‑prone and harder to maintain. The challenge was to design a system that simplifies database operations while ensuring persistence, security, and scalability.

ORM Integration: Implemented SQLAlchemy’s declarative base to define the Producto model class.

CRUD Operations: Used ORM methods (session.add, session.query, session.delete, session.commit) instead of raw SQL.

Session Management: Leveraged sessionmaker for transaction handling.

Database: Used SQLite for lightweight local persistence.

Architecture: Separated database logic (InventarioManager) from application logic for clean design.

Delivered a Pythonic inventory management system where each product is represented as an object mapped to a database row. The ORM layer ensures secure queries, automatic input sanitization, and intuitive data manipulation.

Security: ORM queries are immune to SQL injection.

Maintainability: Cleaner, object‑oriented code reduces complexity.

Scalability: Architecture can be extended to larger applications, APIs, or web frameworks.

Business Value: Provides a reliable foundation for inventory tracking and resource management.