Test Centre Software & Digitalisation

Modernisation of the documentation and administration software for Covid-19 tests as well as a relaunch of the web presence.

Healthcare

Industry

Testzentrum-Friedrich

Client

2021

Year

Project Overview

We completely redeveloped the outdated administration software of a local test centre. The original solution was limited to a single computer and caused massive delays during periods of high demand. Our new solution optimised the entire workflow - from fast person searches and test evaluation through to automated reporting to the health authority.

The Challenge

The existing software was locally installed, slow and blocked the scalability of the test centre as user numbers grew.

Restricted access: software could only be used on a single computer

Long waiting times and queues due to cumbersome operation

Manual, error-prone processes for transmitting data to authorities

Outdated website with no clear information value for citizens

Necessity to securely migrate sensitive existing data

Our Solution

Development of a web-based software running on a local Linux mini-PC, combining maximum performance with local data security.

Analysis & Migration

Analysis of the legacy data and development of a migration tool for the seamless transfer of customer data into the new PostgreSQL database.

Deliverables

Migration tool
Database schema
Security concept

Backend Development (Rust)

Implementation of a high-performance backend with Rust and Axum for type-safe and fast API endpoints.

Deliverables

High-performance API
Search engine (Meilisearch)
Automated e-mail dispatch

Frontend & UI (Svelte)

Creation of an intuitive interface for staff enabling one-click evaluation and certificate generation.

Deliverables

Web app
Admin dashboard
Statistics module

Infrastructure & Web

Setup of the local Linux server (mini-PC) in the LAN and relaunch of the modern customer-facing website.

Deliverables

Local server setup
Modern landing page
Staff training

Results

The digitalisation led to a significant acceleration of testing operations and a noticeable relief for the staff.

Multi-UserSimultaneous access from multiple stations possible

< 50msReal-time person search powered by Meilisearch

100%Reporting of positive tests to the health authority fully automated

DigitalDaily statistics available at the push of a button

ModernStreamlined website design for better citizen information

Technologies used

Frontend

SvelteSvelteKitTypeScriptTailwind CSS

Backend

RustAxum

Database & Search

PostgreSQLMeilisearch

Infrastructure

Linux (Ubuntu)NGINXLocal Mini-PC ServerShell Scripting

Security

Isolated local network (LAN)SSL/TLS (internal)Automated backups

„Niklas and Robin supported us in replacing the old test software and providing a more user-friendly and powerful software solution. We had intensive discussions with them and talked through our ideas for the new test software in detail. They were extremely attentive, always took the time for us and took all our wishes and requirements into account. The result is a test software with a clean and modern appearance. In addition, they were able to significantly improve the stability and speed of the software compared to the old version. The new evaluation interface also relieves us of a considerable amount of work. After the restructuring of the software, our tests not only ran faster and more efficiently, but the use of the software simplified many things and thus the use of it brought more enjoyment to the entire team at work. Through the close collaboration with the two of them, we now also have a professional and appealing website that provides our customers with a clear overview of our services. We are extremely satisfied with their work and can warmly recommend them as software developers and web developers."