herd open and herd database commands

[FaridAghili]

In herd there was some command for cli to open current project in browser, or database in table plus / TablePro like herd open and herd db
Is there a similar command in Flock? I couldn't find it.

[18w]

Hey @FaridAghili,

There's no open or db command for normal sites right now. I went through docs/cli.md: the closest is flock worktree open, but it only works inside a worktree (outside one it fails with "is not in a worktree of a Flock site"). There's no database-client command at all.

Until something like that is added, two small shell functions get you most of the way (zsh/bash, macOS):

# open the current site in the browser (parked/linked dir name = site name)
fopen() { open "http://$(basename "$PWD").test"; }

# open the project's DB in TablePlus using the Laravel .env
fdb() {
  set -a; . ./.env; set +a
  local scheme=$DB_CONNECTION
  [ "$scheme" = pgsql ] && scheme=postgresql
  [ "$scheme" = mariadb ] && scheme=mysql
  open "$scheme://$DB_USERNAME:$DB_PASSWORD@$DB_HOST:$DB_PORT/$DB_DATABASE"
}

Use https:// in fopen if you ran flock secure, and on Linux swap open for xdg-open. Flock's defaults are root with no password for MySQL/MariaDB and postgres with no password for PostgreSQL (from docs/services.md), so the .env values are usually all you need. TablePlus picks up mysql:///postgresql:// URLs.

flock open / flock db would be a nice small addition though, probably worth a feature request.

[lukas-frey]

Thanks, I created an issue from it, so I'm closing this thread now. Further conversation can be made in the related issue.