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

2477854.md

How to quickly and conveniently disable all console.log statements in my code?

With a JavaScript mangler and compressor toolkit like Terser you can pass console.log to CLI compress options 👇

You need to pass --compress (-c) to enable the compressor. Optionally you can pass a comma-separated list of compress options.

You can pass an array of names and Terser will assume that those functions do not produce side effects. You can pass pure_funcs: [ 'Math.floor' ] to let it know that this function won't produce any side effect, in which case the whole statement would get discarded.

terser dev/main.js \
  --mangle --comments false \
  --compress passes=2,pure_funcs=['console.log'] \
  --output prod/main.min.js

👉 Read the answer on stackoverflow.com

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	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