Patricia Alonso Patricia Alonso
~/patricia-alonso/projects

Projects

Four projects, four different problems: internal management, online community, automation and e-commerce.

tss-invest / fdt-crm.py

FDT CRM

Custom desktop CRM for TSS Invest, built to manage investment leads without relying on an internet connection or external software licences.

The problem

The team managed leads in scattered spreadsheets, with no way to track each opportunity's status or export clean reports.

The solution

A desktop application with a visual Kanban board by lead status, standardised date formatting and direct Excel export.

Tech stack

  • PySide6
  • SQLite
  • PyInstaller
  • openpyxl
  • bcrypt
Distributed as a standalone .exeNo external dependencies for the end user
pzverse / plataforma-comunidad.py

PZVerse

Full-stack web platform for managing an online community: event schedule, content gallery and shop with integrated payments, all from a central admin panel.

The problem

The community needed its own space to centralise the event calendar, visual content and product sales, without relying on several disconnected tools.

The solution

A platform with automatic-upload gallery, a two-category shop with PayPal Business checkout, and an admin panel to manage all the content.

Tech stack

  • Flask
  • PostgreSQL
  • Railway
  • PayPal API
Deployed on RailwayAutomatic content upload integration
alas-negras / automatizacion.py

Alas Negras

Community platform with notification automation and bots connected to multiple channels, solving real concurrency and production stability issues.

The problem

The messaging bots were blocking the application's main thread, and database connections were dropping after idle periods.

The solution

Automated agenda system with scheduled notifications, Telegram bot and IRC bot running in parallel without blocking the application, using a thread pool and task queue.

Tech stack

  • Flask
  • PostgreSQL
  • APScheduler
  • Render
ThreadPoolExecutor + queue.Queue for concurrencypool_pre_ping for connection stability
estima-libros / ecommerce.py

Estima Libros

In development

Custom e-commerce platform for a publishing client. Scope already defined and ready to start development.

The scope

Full online store for book sales: catalogue, cart, order management and admin panel for the client.

Planned stack

  • Flask
  • Passenger WSGI
  • SiteGround

Does your project look like one of these?

Tell me the details and let's talk about how to approach it.

Get in touch