bielikb/si-beko

SI Builder

Web app for creating shipping instructions. Locally it uses data/Cafom DB.xlsx; online it can use Postgres.

Start

./run.sh

Open the URL printed in the terminal, usually:

http://127.0.0.1:8000

Data

The app reads and saves data/Cafom DB.xlsx by default. Before each save/import it creates a timestamped backup in data/backups/.

Zero-Cost Online Hosting

Use a free Docker web service plus Supabase over HTTPS:

1. 1.Push this repository to GitHub.
2. 2.Create a free Supabase project.
3. 3.Open Supabase SQL Editor and run the full contents of supabase_schema.sql once.
4. 4.Create a free Hugging Face Space with Docker SDK.
5. 5.Push this app to the Hugging Face Space repository, or copy the files there.
6. 6.Add these Space secrets:

SUPABASE_URL=https://your-project-ref.supabase.co
SUPABASE_KEY=your-publishable-key
SI_APP_HOST=0.0.0.0
SI_APP_PORT=7860
SI_APP_USERNAME=admin
SI_APP_PASSWORD=choose-a-strong-password

When SUPABASE_URL and SUPABASE_KEY are present, the app stores records, forwarders, and documents in Supabase through the REST API over HTTPS. The Excel import/export buttons still work, so the initial Cafom DB.xlsx can be uploaded from the app after deploy.

If DATABASE_URL is present instead, the app uses a direct Postgres connection. Direct Postgres may not work on free web hosts that block outbound database ports.

If SI_APP_PASSWORD is set, the app requires browser basic authentication. Locally, leave it unset to keep the current no-login workflow.

Paid Fallback

For an online Excel-file fallback instead of Postgres, use a persistent disk and set:

SI_APP_HOST=0.0.0.0
SI_APP_DATA_DIR=/path/to/persistent/data

Keep Cafom DB.xlsx out of public GitHub repositories because it contains operational contact data.