IT Infrastructure | Linux Administration | Technical Support | Networking | Founder @ SolarisPKN

youtube

medium

codeforces

leetcode

gumroad

productHunt

devto

dribbble

github

Solaris PKN • Peerlist

<h3>About SolarisPKN-Transport</h3>
SolarisPKN-Transport is a robust pipeline designed to collect, validate, and store transport timetables from official sources. It leverages the same backends used by applications like Trenes Argentinos and Cuándo SUBO to gather published schedules. The system validates each schedule, saves it in a human-readable spreadsheet format (XLSX), and constructs a normalized SQLite database for efficient web queries. This ensures reliable access to transport information even when live APIs are unavailable.
<ul>
<li>Key Features:</li>
<li>Spreadsheet-driven configuration for easy route updates without code changes.</li>
<li>Automatic discovery of routes, directions, and stops.</li>
<li>Utilizes official app backends for data collection.</li>
<li>Safe replacement strategy ensures data integrity.</li>
<li>Atomic persistence and manual data protection mechanisms.</li>
<li>Daily automation via GitHub Actions for continuous updates.</li>
<li>Traceable data provenance indicating update methods (API or Manual).</li>
<li>Bilingual documentation in English and Spanish.</li>
</ul>
The project aims to provide a dependable source for planned transport services, acting as a fallback when live tracking data is inaccessible. It prioritizes data integrity by never overwriting trusted data with incomplete or inconsistent information.
Technology Stack:
<ul>
<li>Python 3.11+ for core logic, validation, and data processing.</li>
<li>openpyxl for handling XLSX files.</li>
<li>SQLite for creating a queryable database.</li>
<li>Node.js for specific connector tests.</li>
<li>GitHub Actions for automated workflows.</li>
<li>REST for interacting with external APIs.</li>
</ul>

SolarisPKN-Transport

<h3>SolarisPKN-Stats is an automated system designed for collecting, storing, and updating statistics from various projects across different platforms and services.</h3>The primary goal is to provide statistical data in a transparent, structured, and reusable format, storing collected information in JSON files. These files can then be easily consumed by websites, dashboards, analytics tools, or other projects.The system features a connector-based architecture, a central project registry managed via registry.json, and leverages GitHub Actions for deployment and Cloudflare Workers for scheduled statistics collection.Key features include:<ul><li>Centralized project registry for defining projects to be analyzed.</li><li>Modular connector system allowing integration with various platforms.</li><li>Scheduled queries for efficient data collection.</li><li>Support for conventional APIs and GraphQL for optimized data retrieval.</li><li>Statistics stored as JSON, with current data in stats.json and historical data in history/.</li><li>Automated deployment and periodic data collection using GitHub Actions and Cloudflare Workers.</li><li>Extensibility to easily add new projects and platforms.</li></ul>SolarisPKN-Stats aims to be an automated statistics data collection and storage layer, providing a foundation for various applications and use cases, from displaying project statistics on websites to building complex dashboards and enabling automated reporting.

GitHub - SolarisPKN/SolarisPKN-Stats · GitHub

🇺🇸 English 🚀 Solaris Media Production Suite is a collection of tools, scripts, configurations, and automation resources for audiovisual production, live streaming, and digital content creation. 🎥 Designed for creators, streamers, and technical operators, it helps simplify workflows, automate repetitive tasks, organize production assets, and improve efficiency across multiple platforms. ⚙️ The project may include streaming configurations, automation scripts, monitoring tools, production utilities, and platform integrations aimed at building reliable and scalable content production environments. 📡 Create more. Manage less. 🇪🇸 Español 🚀 Solaris Media Production Suite es una colección de herramientas, scripts, configuraciones y recursos de automatización para producción audiovisual, streaming en vivo y creación de contenido digital. 🎥 Diseñada para creadores, streamers y operadores técnicos, ayuda a simplificar flujos de trabajo, automatizar tareas repetitivas, organizar recursos de producción y mejorar la eficiencia en múltiples plataformas. ⚙️ El proyecto puede incluir configuraciones para streaming, scripts de automatización, herramientas de monitoreo, utilidades de producción e integraciones orientadas a construir entornos de trabajo confiables y escalables. 📡 Crea más. Administra menos. Si querés algo que luzca más como proyecto corporativo/portfolio profesional, puedo dejarlo en menos de 1000 caracteres y con un tono más "empresa de software". 🚀

SolarisPKN-LiveTools

English Technology platform oriented to the documentation, development, and distribution of software projects, automation systems, and embedded systems. The project integrates a professional portfolio, a research and development (R&D) lab, technical documentation, Open Source projects, and specialized tools within a unified ecosystem. Designed with a scalable architecture based on modern cloud technologies, it enables public content management, early access features, memberships, software licensing, and firmware distribution for ESP32 devices and other automation solutions. Main areas: • Software development and technical tools. • Embedded systems and ESP32 projects. • Web infrastructure and cloud services. • Automation and applied electronics. • Technical documentation and system architecture. • Research, prototyping, and validation of new technologies. Status: Active development. --------------------------------------------------------------- Español Plataforma tecnológica orientada a la documentación, desarrollo y distribución de proyectos de software, automatización y sistemas embebidos. El proyecto integra portfolio profesional, laboratorio de investigación y desarrollo (I+D), documentación técnica, proyectos Open Source y herramientas especializadas bajo un ecosistema unificado. Diseñado con una arquitectura escalable basada en tecnologías cloud modernas, permite la gestión de contenido público, acceso anticipado, membresías, licenciamiento de software y distribución de firmware para dispositivos ESP32 y otras soluciones de automatización. Áreas principales: • Desarrollo de software y herramientas técnicas. • Sistemas embebidos y proyectos ESP32. • Infraestructura web y servicios cloud. • Automatización y electrónica aplicada. • Documentación técnica y arquitectura de sistemas. • Investigación, prototipado y validación de nuevas tecnologías. Estado: Desarrollo activo.

SolarisPKN-Labs

English 🌐 IoT system based on ESP32 for remote computer control via the Internet. This project enables the remote management of a PC, allowing it to power on, shut down, and force shutdown by simulating the physical Power SW button press. 🔌 Integrated with Arduino IoT Cloud and voice assistants, it allows seamless remote access and control of the computer from anywhere. 💡 Designed to complement remote access solutions such as VPN and Sunshine, improving overall usability and energy efficiency by avoiding the need to keep the system running continuously. ⚙️ Key capabilities: • Remote power ON / OFF control • Forced shutdown via simulated hardware signal • Cloud-based IoT integration • Voice assistant compatibility • Energy optimization for PC usage ------------------------------------------------------------------ Español 🌐 Sistema IoT basado en ESP32 para el control remoto de una computadora a través de Internet. Este proyecto permite la gestión remota de una PC, posibilitando encenderla, apagarla y forzar su apagado mediante la simulación de la pulsación física del botón Power SW. 🔌 Integrado con Arduino IoT Cloud y asistentes de voz, facilita el control y administración del equipo desde cualquier ubicación. 💡 Diseñado para complementar soluciones de acceso remoto como VPN y Sunshine, optimizando el consumo energético al evitar mantener el equipo encendido de forma permanente. ⚙️ Capacidades principales: • Encendido y apagado remoto • Apagado forzado mediante señal de hardware simulada • Integración con plataforma IoT en la nube • Compatibilidad con asistentes de voz • Optimización energética del sistema