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

rafaelquicdb

no profile record

投稿

Show HN: Go CLI to create instant PostgreSQL branches of your database

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

Ask HN: How do you manage dev/PR/staging databases?

1 ポイント·投稿者 rafaelquicdb·9 か月前·4 コメント

[untitled]

1 ポイント·投稿者 rafaelquicdb·9 か月前·0 コメント

コメント

rafaelquicdb
·9 か月前·議論
hmm, that makes sense, thank you!

The reason I'm asking is I'm trying to validate if something I'm building would be useful for dev teams to enhance their productivity.

Not trying to sell anything, just looking for honest feedback if people would pay for this or if I'm wasting time.

https://quicdb.com/

It's basically postgresql ephemeral, isolated, secure, branches, like Neon/Supabase have, but works with any setup.

In any case, thank you for your insights @benoau!
rafaelquicdb
·9 か月前·議論
It's tricky because it depends on the operating system.

If you're on Linux, you can do it by:

1) get a disk volume (partition, attach one, etc.)

2) zpool that disk (note it will wipe it out)

3) move your database data directory to the volume

4) use zfs snapshot and zfs clone to create an isolated branch

5) run pg_ctl start pointing to the clone directory.

That's it!

I tried to achieve the same on MacOS but it lacks proper tooling. Not sure about Windows.
rafaelquicdb
·9 か月前·議論
Interesting, I didn't know about liquibase, thanks for sharing!

How about the data itself, do you usually seed it for local development, or PR/staging environments? Or do you get production subset for example? And if you do, do you deidentify the prod data to use in the non-production environments?

Trying to understand any pain points related to that the product development workflow (i.e. local dev, PR, QA, demo, etc.).

Thank you!