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

1 month ago 5

Hostinger Web Hosting

Get ready-to-work, up-to-date, isolated branches of your Postgres database in seconds, not hours.

Great for development git workflows, PR/staging/demo environments, bug investigation, migration tests, and more.

curl -fsSL https://raw.githubusercontent.com/quicdb/quic/main/scripts/install.sh | bash

Or download the binary directly from the releases page.

A quic.json file will be created to hold configuration used for setting up infrastructure and managing branches.

Make sure you have ssh access to your host and run:

quic host new <ip-address> quic host setup

Create a user for yourself

quic user create "Your Name" # outputs an auth token quic login --token <token>

You may also want to create users for each team member and CI.

For now, you need to manually hand auth tokens to the respective team members.

quic user create "Team Member" quic user create "CI"

Setup a template database

For now, it just works for CrunchyBridge backups. Feel free to create an issue detailing your use case.

quic template new <template-name> quic template setup

quic checkout <branch-name> # outputs a connection string

quic delete <branch-name>

Business Source License 1.1

Read Entire Article

Hostinger Web Hosting