3 Commits

Author	SHA1	Message	Date
rafapolo	41e7f7a972	replace duckdb-ui with ttyd shell: add /query HTTP endpoint, fix utf-8/locale, region config ... - swap DuckDB UI for ttyd web terminal (--writable, -readonly db) - add POST /query endpoint with X-Password auth for curl-based SQL execution - fix UTF-8 rendering: set LANG/LC_ALL=C.UTF-8 in container - pass BUCKET_REGION env var for correct S3 signing region - simplify start.sh: drop Xvfb, views.duckdb generation, blocking duckdb -ui - add less, ncurses-bin to Dockerfile for proper pager/terminal support - update Caddyfile: single route to ttyd with flush_interval -1 for websocket - update README to reflect current architecture and document /query usage - remove duckdb-ui.service, schemas.json, file_tree.md (generated artifacts)	2026-03-26 11:54:46 +01:00
rafapolo	0d77f83045	simplify container: skip db prep, password via env var, fixed server IP ... - start.sh: remove prepara_db.py step; load S3 creds via DuckDB init file - Caddyfile: switch to basic_auth with {env.BASIC_AUTH_HASH} — no rebuild to rotate password - Dockerfile: drop Python/pip layers (no longer needed at runtime) - haloy.yml: set server to 89.167.95.136, add BASIC_AUTH_HASH to env - remove requirements.txt (only needed for local prepara_db.py, not the container)	2026-03-25 13:27:51 +01:00
rafapolo	9eb2dee013	containerize with Haloy: Dockerfile, Caddy basicauth, haloy.yml for db.xn--2dk.xyz ... - Dockerfile: debian slim, installs DuckDB CLI, Python deps, Caddy - start.sh: runs prepara_db.py → starts Caddy (basicauth) → starts DuckDB UI - Caddyfile: updated for container (no TLS, port 8080, Haloy handles HTTPS) - haloy.yml: deploys to db.xn--2dk.xyz on port 8080 - requirements.txt: duckdb, boto3, python-dotenv - prepara_db.py, open_gui.sh, duckdb-ui.service: add previously untracked files - remove prepara_gui.py (replaced by prepara_db.py)	2026-03-25 13:23:59 +01:00