selfdb_io
Joined 1 year ago
Joined 1 year ago
SelfDB-mini is a production-ready boilerplate designed to be completely portable.
The Core Idea: It treats the database state and the environment configuration as a single unit. The backup system bundles the PostgreSQL dump and the .env file into a portable .tar.gz archive. To migrate, you simply spin up a fresh container on a new machine and upload the archive via the UI.
The Stack: Instead of a bare-bones "Hello World", I included the tooling necessary for actual production loads:
Database: PostgreSQL 18 + PgBouncer (pre-configured for connection pooling). Backend: FastAPI (Python 3.11) with asyncpg. Frontend: React + TypeScript (Vite). Testing: Includes setups for Locust (load testing) and Schemathesis (API contract testing). SDKs: Auto-generated TypeScript clients via hey -api`.
It’s open source and Dockerized. I’d appreciate any feedback on the architecture or the backup strategy.
Now I can sit at the picnic table, maybe flipping burgers, while still live-debugging my servers through Claude via SSH—code in my pocket, presence at the party intact. Let me know what dev-BBQ hacks you’ve pulled off.
Anubis lets raw doggers SSH into their VPS to code live and deploy fast. One-time purchase, no subscription. Get it here: https://apps.apple.com/be/app/anubis-ssh-terminal/id67512329... #IndieDev #RawDogDev
Pro tip: Secure your VPS—disable password auth, enable fail2ban, set up UFW. Who's raw dogging their next project?