HackerTrans
トップ新着トレンドコメント過去質問紹介求人

elitan

no profile record

投稿

Show HN: Velo – Git-like branching for PostgreSQL databases using ZFS snapshots

github.com
3 ポイント·投稿者 elitan·9 か月前·3 コメント

コメント

elitan
·5 か月前·議論
Heroku's git-push-to-deploy was magic in 2012. Sad to see it go out like this.

I've been building Frost https://github.com/elitan/frost, open source and self-hosted. Same idea, git push to deploy, automatic SSL, custom domains, but on your own VPS. Docker-native, no vendor lock-in, no pricing surprises.

The angle that's a bit different: it's designed for AI coding agents. Simple config they write correctly, clear errors, no K8s complexity to hallucinate. You give your agent the install URL and it sets up the whole server.
elitan
·6 か月前·議論
Building Frost, a simple self-hosted deployment platform. Docker-only, single-user, no Kubernetes. You point it at a repo or image, it handles the build → health check → deploy → stop old container flow.

Stack: Bun, Next.js, SQLite, Kysely. Been building it almost entirely with Claude Code which has been a surprisingly effective workflow for this kind of infra tooling.

https://github.com/elitan/frost
elitan
·6 か月前·議論
Been using Claude Code to build a small deployment tool (Frost) for exactly this use case. The meta experience is interesting - using an AI agent to build tooling that makes self-hosting easier.

What I've found: Claude Code is great at the "figure out this docker/nginx/systemd incantation" part but the orchestration layer (health checks, rollbacks, zero-downtime deploys) still benefits from purpose-built tooling. The AI handles the tedious config generation while you focus on the actual workflow.

github.com/elitan/frost if curious
elitan
·6 か月前·議論
Amazon (AWS) is not cheap! :D
elitan
·7 か月前·議論
interesting, you have a link?
elitan
·7 か月前·議論
Plagiarized from what? Happy to address if you can point to what you're referring to.
elitan
·7 か月前·議論
For those who can't wait for PG18 or need full instance isolation: I built Velo, which does instant branching using ZFS snapshots instead of reflinks.

Works with any PG version today. Each branch is a fully isolated PostgreSQL container with its own port. ~2-5 seconds for a 100GB database.

https://github.com/elitan/velo

Main difference from PG18's approach: you get complete server isolation (useful for testing migrations, different PG configs, etc.) rather than databases sharing one instance.
elitan
·7 か月前·議論
helpful
elitan
·8 か月前·議論
This looks really good, love the local LLM support. Will try this instead of Notion which is my current note taking app. Thank you!
elitan
·9 か月前·議論
It's a killer feature indeed. Glad you liked it! :)
elitan
·9 か月前·議論
Hey HN! I built Velo to solve a problem I kept running into: testing database migrations and debugging production issues without copying around massive database dumps or waiting for slow clones.

The core idea: use ZFS copy-on-write snapshots to branch PostgreSQL databases the way you branch Git repos. A 100GB database branches in ~2 seconds and takes ~100KB of space initially. Each branch is a complete, isolated PostgreSQL instance running in Docker.

How it works:

- Runs CHECKPOINT to flush PostgreSQL buffers (ensures consistency)

- Creates a ZFS snapshot (filesystem-level, instant)

- Clones the snapshot to a new dataset (CoW means no data copying)

- Spins up a new PostgreSQL container pointing at the clone

The mental model is: Project = Git repo, Branch = Git branch. Commands like `velo branch create api/test-migration` or `velo branch reset api/dev`.

I also added point-in-time recovery using WAL archiving, so you can create branches from specific timestamps (e.g., "5 minutes before the incident").

Requirements: Linux + ZFS + Docker.

Built using Bun and TypeScript.

Let me know what you think :)
elitan
·9 か月前·議論
Sure is! Thank you :)
elitan
·9 か月前·議論
Two things related to Postgres:

* Velo - Postgres with instant branching (https://github.com/elitan/velo)

* Terra - Declarative schema management for Postgres (https://github.com/elitan/terra)

Some fun side projects i hack on during the evenings and weekends.
elitan
·9 か月前·議論
I'm building #4:

> A hybrid of Strong (the lifting app) and ChatGPT where the model has access to my workouts, can suggest improvements, and coach me. I mainly just want to be able to chat with the model knowing it has detailed context for each of my workouts (down to the time in between each set).

here: https://j4.coach/

Still early, have ~30 min per day to work on it but it's usable and improving every week :)
elitan
·11 か月前·議論
i'm fine with it. happy to seed.