zhangw

## install musl
sudo pacman -Syu musl

## install headers of musl
sudo pacman -Syu kernel-headers-musl

## cargo add musl target and toolchain
rustup target add --toolchain stable x86_64-unknown-linux-musl

## download openssl source code, version is 3.0.7

zhangw

# Install the toolchain
```bash
brew tap SergioBenitez/osxct
brew install x86_64-unknown-linux-gnu
```

# this should get installed in:
# /opt/homebrew/Cellar/x86_64-unknown-linux-gnu/

# Installing the macOS OpenSSL - if not already installed

zhangw

Installation

1. mkdir -p ~/.config && touch ~/.config/ssh-agent.pid
2. Paste the contents of ssh-agent-manage.sh into your .bashrc or .bash_profile or similar
3. killall -9 ssh-agent
4. Start a new terminal session (note: old sessions will not see ssh-agent, only new ones)

Details

This snippet, when included in .bashrc, will ensure that your session has a working ssh-agent with all your ssh keys loaded into it. It does this without creating separate ssh-agent processes by:

zhangw

CREATE TABLE
  `testing.insert` (date DATE OPTIONS( description='date' ),
    unique_visits INT64 OPTIONS( description='counts' ))
PARTITION BY
  date
CLUSTER BY
  unique_visits OPTIONS ( description="A table with a date partition",
    labels=[("testing",
      "data_is_great")],
      expiration_timestamp=TIMESTAMP "2023-01-01 00:00:00 UTC"

zhangw

SELECT 
date,
COUNT(DISTINCT(visitid)) as unique_visits
FROM `bigquery-public-data.google_analytics_sample.ga_sessions_*` 
WHERE _table_suffix = '20170801'   # use date_sub to programmatically select your table
GROUP BY date
ORDER BY date

zhangw

 
CREATE TEMP FUNCTION
  PROPER(str STRING) AS ((
    SELECT
      STRING_AGG(CONCAT(UPPER(SUBSTR(w,1,1)), LOWER(SUBSTR(w,2))), ' '
      ORDER BY
        pos)
    FROM
      UNNEST(SPLIT(str, ' ')) w
    WITH

zhangw

 DECLARE
  SQLRUN STRING DEFAULT '';
CREATE TEMP FUNCTION
  ga4_firebase( key1 STRING,
    params ARRAY <STRUCT <key STRING,
    value STRUCT <string_value STRING,
    int_value INT64,
    float_value FLOAT64,
    double_value FLOAT64 >>>) AS ( (
    SELECT

zhangw

Table of Contents

• set -e, -u, -x, -o pipefail
• set -e
• set -x
• set -u
• set -o pipefail
• Setting IFS
• Original Reference

set -e, -u, -x, -o pipefail

zhangw

brew install openssl
brew install zstd
git clone [email protected]:edenhill/librdkafka.git
cd librdkafka
git checkout v1.5.0
CPPFLAGS="-I/opt/homebrew/opt/openssl@3/include -I/opt/homebrew/Cellar/zstd/1.5.2/include" LDFLAGS="-L/opt/homebrew/opt/openssl@3/lib -L/opt/homebrew/Cellar/zstd/1.5.2/lib" ./configure --prefix=$HOME/Temp/librdkafka-v1.5.0
cp examples/Makefile examples/Makefile.bak
sed -i '' -e 's/librdkafka.a/librdkafka.1.dylib/g' examples/Makefile
sed -i '' -e 's/librdkafka++.a/librdkafka++.1.dylib/g' examples/Makefile
make

zhangw

CONTAINER_CLI=docker
CONTAINER_CLI_VER:=$(shell docker --version 2>/dev/null)
ifndef DOCKER_CLI_VER
CONTAINER_CLI_VER:=$(shell lima -v 2>/dev/null)
endif
ifdef CONTAINER_CLI_VER
CONTAINER_CLI=lima nerdctl
endif