Automatisch-Nachbuchen.de - Intelligent Data Volume Automation

An advanced platform for automatic monitoring and rebooking of data volume for SIM24 and 1&1 Unlimited OnDemand plans with real-time dashboard and secure credential management.

15 January, 2025

Project Overview

Automatisch-Nachbuchen.de was developed to automate the manual process of rebooking data volume for SIM24 and 1&1 Unlimited OnDemand plans. With these plans, after consuming the initial 50GB, data volume must be manually rebooked in increments – a time-consuming process that is fully automated by this platform.

System Architecture

The application is based on a modern, scalable architecture with clear separation between frontend and backend:

Frontend

  • Next.js 15 with React 19 for a responsive user interface
  • TailwindCSS for consistent, responsive design
  • Real-time dashboard for monitoring data volume status
  • Dark mode for improved user experience
  • Progressive Web App (PWA) functionality for mobile use

Backend

  • Next.js API Routes for primary endpoints
  • Flask API for specialized browser automation
  • Playwright for reliable interaction with provider portals
  • Encrypted storage of sensitive credentials
  • Event-based architecture for real-time updates

Data Processing

  • PostgreSQL with Prisma ORM for structured data storage
  • Automatic database migrations for seamless updates
  • Efficient query optimization for fast response times
  • Transaction safety for critical operations

Technical Challenges

Several complex technical challenges were solved during development:

Browser Automation

The main challenge was developing a robust system for reliable interaction with provider portals:

  • Implementation of intelligent selectors for stable DOM navigation
  • Development of retry mechanisms for connection issues
  • Adaptive wait times to adjust to server loads
  • Error-tolerant processing of unexpected portal changes

Security Implementation

For secure handling of sensitive credentials, the following measures were implemented:

  • Encrypted storage of all login information
  • JWT-based authentication with NextAuth.js
  • Role-based access control for administrative functions
  • HTTPS enforcement in production environments

Monitoring System

The real-time monitoring system was implemented with the following components:

  • Continuous monitoring of data volume status
  • Automatic detection of low data volume
  • Intelligent rebooking logic with configurable thresholds
  • Detailed logging of all actions for traceability

Technologies Used

  • Next.js 15 and React 19 for the frontend
  • TailwindCSS for UI design
  • NextAuth.js for authentication
  • Flask for specialized backend functions
  • PostgreSQL with Prisma ORM
  • Playwright for browser automation
  • Docker and Docker Compose for containerization

Scalability and DevOps

The infrastructure was designed with a focus on scalability and operational stability:

  • Containerized deployment strategy with Docker
  • Horizontal scaling for even load distribution
  • Automated database backups for data security
  • Comprehensive logging for error diagnosis and auditing

Future Development

The following extensions are planned for upcoming versions:

  • Integration of additional mobile providers and plan models
  • Advanced analytics for data usage optimization
  • Implementation of a notification system for critical events
  • API extension for third-party integrations

Demonstration