RautioProjects.
Let's talk

02 / Project tag

Projects tagged “self-hosted”.

Matching projects

All projects in the catalogue using this shared topic.

  1. 01

    Local Git Server on Synology NAS

    A local Git server with SSH access and automated backups for secure code and configuration management.

    Problem
    Need to manage code and configuration in a secure, local environment.
    Solution
    Set up a local Git server on a Synology NAS with SSH access and automated backups.
    Technologies
    Synology NAS · Git · SSH · Bash scripting
    Role
    Solution designer & implementer
    What I learned
    Local solutions can be powerful when security and control are priorities.

  2. 02

    Self-Hosted Prototyping and Demo Environment

    A production-inspired homelab for prototyping, service hosting, and technical demonstrations.

    Problem
    Needed a safe environment to design, test, and showcase infrastructure and software solutions.
    Solution
    Built a production-inspired homelab platform on an HP Mini PC for prototyping, service hosting, and technical demonstrations.
    Technologies
    HP Mini PC · Linux(Debian) · Containers · Automation · Networking · Monitoring · Documentation · Security · VPN
    Role
    Solution designer & implementer
    What I learned
    Testing architectures locally enabled faster cloud deployments and more predictable implementation outcomes.

  3. 06

    Home Assistant Data ETL Pipeline to Cloud PostgreSQL

    A Python ETL pipeline that transfers numeric Home Assistant sensor history from a self-hosted PostgreSQL database to a cloud warehouse.

    Problem
    Needed to keep Home Assistant local while making selected historical sensor data available for cloud-based reporting and analysis.
    Solution
    Built a scheduled Python pipeline that extracts new numeric sensor states incrementally, transfers them through an SSH tunnel, and loads a Bronze/Silver/Gold PostgreSQL warehouse with run and step monitoring.
    Technologies
    Python · PostgreSQL · SSH · psycopg · Medallion · Bronze/Silver/Gold · cron
    Role
    Data pipeline designer & implementer
    What I learned
    Incremental boundaries, transaction handling, monitoring, and explicit cleanup make even a small ETL job reliable and recoverable.