HackerTrans
TopNewTrendsCommentsPastAskShowJobs

rafaelquicdb

no profile record

Submissions

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

github.com
2 points·by rafaelquicdb·9 mesi fa·2 comments

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

1 points·by rafaelquicdb·9 mesi fa·4 comments

[untitled]

1 points·by rafaelquicdb·9 mesi fa·0 comments

comments

rafaelquicdb
·9 mesi fa·discuss
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 mesi fa·discuss
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 mesi fa·discuss
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!