{"repo":"autumoswitzerland/Webduck","free":true,"listed":false,"github":"https://github.com/autumoswitzerland/Webduck","clone":"git clone https://github.com/autumoswitzerland/Webduck.git","description":"A self-hosted DuckDB-as-a-Service server with REST API and Web UI.","language":"Python","stars":47,"topics":["analytics","csv","database","docker","duckdb","fastapi","open-source","python","rest-api","self-hosted"],"license":"AGPL-3.0","category":"self-hosted-apps","readme_excerpt":"WebDuck A self-hosted DuckDB-as-a-Service server with REST API and Web UI. WebDuck is designed for web hosting providers who want to offer their customers a ready-to-use administration interface for DuckDB databases and data analytics — out of the box, just like the database admin tools that come with any hosting package. Website · Issues · License Features - DuckDB storage engine with file-locking for safe concurrent access - REST API — admin endpoints (project/DB management) + database endpoints (SQL queries) - Web UI (NiceGUI) — dark mode with yellow/amber theme - Dashboard — server status cards, live REST traffic monitor (queries/min, active sessions), storage overview with per-project sizes and trash totals - Trash — soft-delete projects/databases with restore, permanent delete per entry, empty trash - JWT authentication for admin API, optional project-key auth for database access - Per-database write protection — lock a database to read-only, independent of passwords: passwords control who may access, write protection controls what may be done to the data. It protects the data only — compacting, deleting and managing passwords in the web UI keep working at any time - bcrypt password hashing (never plaintext) - SQL editor — multi-statement support with sequential execution, query history (Alt+Up/Alt+Down, Alt+Enter) - SQL upload — execute multi-statement SQL scripts from files - Database compression — reclaims space DuckDB leaves behind after updates/deletes; a hint high","default_branch":null,"files":null,"tree":[],"storefront":"/r/autumoswitzerland","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/autumoswitzerland/Webduck/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}