API del Sistema Médico – SOLCA

The Medical System API is a mission-critical backend application designed for SOLCA (Oncology Hospital), developed entirely in TypeScript using Express.js.

It integrates and cross-references data from:

• Oracle Database (main hospital medical system)
• MySQL Databases (other internal systems)

Key Features:

• High-performance queries: Reduced report generation times from over 5 minutes to under 3 seconds.
• Multi-database integration: Joins data from Oracle and MySQL for cross-system reports and analytics.
• Robust security: Middleware-based token authentication with token management per consuming system.
• Access control: Admin can revoke tokens instantly, disabling system access.
• Logging & monitoring: Detailed request logs (IP, token, endpoint, body) stored in SQLite, integrated into Grafana dashboards.
• Error alerting: Integrated with Telegram Bot API to send alerts on database connection failures or critical errors.
• Scalability: Supports around 8 hospital systems and continues to expand with new endpoints.
• Deployment: Initially internal, later deployed publicly via Nginx on Debian 12 with HTTPS for future external app support.

Tech Stack:

• Backend: Express.js, TypeScript
• Databases: OracleDB (via oracledb npm package), MySQL (mysql2), SQLite (token and log storage)
• Auth: JSON Web Tokens (JWT)
• Monitoring: Grafana + Telegram Bot API
• Other libraries: axios, exceljs, bcryptjs, date-fns