Skip to main content

Ecauspacine

School team project — .NET REST API, WPF client, MySQL database hosted on VPS. Secured access via SSH tunnel. Full documentation and Git workflow provided for the team.

.NETC#WPFMySQLLinuxSSH
ᚱ
Ecauspacine is a management application developed as a team of 6 in a school context. I handled the entire backend and approximately 70% of the frontend, while also setting up the infrastructure and technical documentation for the team.

Tech stack

REST API in .NET / C#, WPF desktop client, MySQL database hosted on a Linux VPS. To secure database access without exposing it to the internet, all connections go through an SSH tunnel — a restricted group of users, with PermitOpen limited to the required ports.

Teamwork

Working as 6 on a shared codebase pushed me to structure the project so any team member could contribute without friction. I wrote a complete onboarding guide (SSH key setup, Windows tunnel scripts, connection tests) and a detailed Git playbook tailored for Visual Studio — because good code is useless if the team can't work with it.

Tunnel scripts

Windows scripts (.bat + PowerShell) to open and close the SSH tunnel with a double-click, with automatic port forwarding for MySQL, phpMyAdmin, and the API. Distributed via the repository's GitHub Releases.