https://stackoverflow.com/users/2477854/jv-conseil?tab=answers&sort=newest #stackoverflow

24987542.md

Download the latest release of a GitHub repository

This solution downloads the latest release tar.gz archive of a GitHub repository with GitHub CLI command line.

To use the gh release download command we need to pick the tag of the latest release, here is how

gh release list --limit 1 --json "tagName" --jq ".[].tagName"

Then provide this tag to the gh release download command

gh release download \
  "$(gh release list --limit 1 --json "tagName" --jq ".[].tagName")" \
  --archive="tar.gz"

The overall code 👇

#!/usr/bin/env bash
# -*- coding: UTF-8 -*-
#
# github   : https://github.com/JV-conseil
# www      : https://www.jv-conseil.net
# author   : JV-conseil
#
# gh release download & list
# see: <https://cli.github.com/manual/gh_release_download>
#
#====================================================

# Retrieve the tag of the latest release
_jvcl_::gh_release_latest_tag() {
  gh release list --limit 1 --json "tagName" --jq ".[].tagName"
}

# Download the latest release archive in tar.gz
# to a local directory
_jvcl_::gh_release_download() {
  local _dir_backup="${1:-"./Downloads"}"
  gh release download \
    "$(_jvcl_::gh_release_latest_tag)" \
    --archive="tar.gz" \
    --dir="${_dir_backup}"
}

_jvcl_::gh_release_download "./path_to_a_folder"

This solution does not provide a link stricto sensu as requested by the question, but is convenient to work with public and private repositories.

👉 Read the answer on stackoverflow.com

29869983.md

PostgreSQL JSON Dump

This combination of PostgreSQL COPY ... TO PROGRAM and sed escaped properly the double quotes in a json compressed gzip data dump👇

\copy (
 SELECT json_agg(row_to_json(T)) :: text FROM (
  SELECT title, author, year FROM books WHERE category NOT LIKE 'fiction'
 ) AS T
) TO PROGRAM
'sed ''s~\\\\~\\~g'' | gzip > ./books-`date +"%Y%m%d-%H%M%S"`.json.gz' ;

👉 Read the answer on stackoverflow.com

41369365.md

Exporting GitHub issues to CSV

gh GitHub CLI integrates now jq with --jq <expression> to filter JSON output using a jq expression as documented on GitHub CLI Manual https://cli.github.com/manual/gh_issue_list.

TSV dump.

gh issue list \
  --limit 10 \
  --state all \
  --json title,body \
  --jq '["title","body"], (.[] | [.title,.body]) | @tsv' \
  >"issues-$(date '+%Y-%m-%d').tsv"

CSV dump

Surprisingly 000D unicode character need to be filtered out with tr $'\x{0D}' ' '.

gh issue list \
  --limit 10 \
  --state all \
  --json title,body \
  --jq '["title","body"], (.[] | [.title,.body]) | @csv' |
  tr $'\x{0D}' ' ' \
    >"issues-$(date '+%Y-%m-%d').csv"

👉 Read the answer on stackoverflow.com

denolehov-obsidian-git-14.md

author	tags
JV conseil (JV-conseil)	git-lfs obsidian

obsidian-git Large File Storage LFS

Adding

/opt/homebrew/bin

in

Obsidian Git > Advanced > Additional PATH environment variable paths

worked for me 👌

Git LFS commit and push now work on Obsidian with git-lfs installed with Homebrew ✅

👉 Read the answer on github.com