airotacujan.online

Blog

  • Airo B Tacujan

    Airo B. Tacujan

    A Personal Profile Blog of a Technical Generalist Who Enjoys Building DIY Systems.

    Projects

    1. Project Sparta — Lightweight Database & Content Management System

    A system initiated by local government teachers to manage athlete records and local sports news on extremely low-cost hardware.
    It serves as a central database for student-athletes, with restricted access for coaches, teachers, and students. Stats are transformed into shareable digital profiles, alongside a built-in community news magazine.
    The concept was driven by the teachers and coaches, so I designed the system around their number one requirement: to keep it running no matter what.
    Less focus on visuals, more on uptime and efficiency.

    Key Highlights:

    • Athlete Record Management: Structured database for storing and organizing student-athlete data and performance statistics
    • Simple Dashboard: For athletes, teachers, coaches, and journalists
    • Low-Resource Deployment: Built without heavy frameworks to run efficiently on low-cost hardware
    • Multi-User Workflows: Supports concurrent updates from multiple contributors
    • Stability & Security: Designed for high uptime and data protection under constrained resources

    System Architecture:

    • Backend: Object-Oriented PHP with optimized MariaDB queries
    • Infrastructure: Debian 13 / Nginx on Amazon Cloud Free Tier
    • Security: Reverse proxy + AWS Security Group + backend validation layers
    • Frontend: Modern Native JS (ES6+), CSS3, HTML5

    Live: www.projectsparta.net

    2. Dark SciFi — Private Publishing System (Active Development)

    A framework-less publishing platform I’m actively building and experimenting on.
    It’s designed for controlled multi-author collaboration with invite-only access and a custom karma system. Right now, I’m the main writer, but the system is being built to scale beyond just me.
    It also doubles as my testing ground for automation, crawling, and scraping.

    Key Highlights:

    • Invitation-only access control system
    • Custom karma/reputation mechanics
    • Designed for future multi-author scalability

    System Architecture:

    • Backend: Object-Oriented PHP with MariaDB
    • Infrastructure: Debian 12 / Nginx on VPS
    • Security: Reverse proxy, firewall layer, backend validation, and Telegram API alerting mechanism
    • Frontend: Modern Native JS, CSS3, HTML5

    Live: www.darkscifi.com

    3. Ethical Automated Data Gathering and Lead Aggregator (Ongoing Testing)

    I build across programming, databases, server administration, cloud infrastructure, and third-party API integrations through systems that collect and organize data responsibly. I design around ethical data collection and automation workflows within platform rules and robots.txt constraints.

    Current Stack:

    I prefer building systems with minimal dependency on large platforms or managed services. Control, efficiency, and independence are key factors in how I design and deploy my solutions.

    Node.js environment using Axios and Playwright for data acquisition, Cheerio for parsing, Apify for scalable automation workflows, and MariaDB for structured data storage.

    GitHub links for my projects coming soon.

    Self Thought Skills

    1. Writing

    By leveraging available AI tools, I turn my thoughts into clearer and more structured writing.

    Technical Writing (Samples Only)

    Creative Writing

    2. Repair Skills

    • MTB maintenance and repair (self-taught, including roadside repairs during long rides)
    • Low-displacement motorcycle maintenance and repair (self-taught through trial, error, and repetition)
    • Electrical wiring repair and fixes (self-taught, practical experience)

    Contact