HackerTrans
TopNewTrendsCommentsPastAskShowJobs

elitan

no profile record

Submissions

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

github.com
3 points·by elitan·há 9 meses·3 comments

comments

elitan
·há 5 meses·discuss
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
·há 6 meses·discuss
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
·há 6 meses·discuss
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
·há 6 meses·discuss
Amazon (AWS) is not cheap! :D
elitan
·há 7 meses·discuss
interesting, you have a link?
elitan
·há 7 meses·discuss
Plagiarized from what? Happy to address if you can point to what you're referring to.
elitan
·há 7 meses·discuss
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
·há 7 meses·discuss
helpful
elitan
·há 8 meses·discuss
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
·há 9 meses·discuss
It's a killer feature indeed. Glad you liked it! :)
elitan
·há 9 meses·discuss
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
·há 9 meses·discuss
Sure is! Thank you :)
elitan
·há 9 meses·discuss
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
·há 9 meses·discuss
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
·há 11 meses·discuss
i'm fine with it. happy to seed.