csokun

sudo pacman -S cuda cudnn
export PATH=$PATH:/opt/cuda/bin
nvcc --version

csokun

#!/bin/bash
# ref. https://github.com/stellar/stellar-etl/tree/master?tab=readme-ov-file#history-archive-commands
if [ $# -lt 3 ]; then
    echo "Usage: $0 <export_type> <start_ledger> <end_ledger> [network]"
    echo "       $0 ledgers 2 500"
    echo "       $0 transactions 2 500 --futurenet"
    echo "       $0 operations 2 500 --testnet"
    echo "       $0 effects 2 500"
    echo "       $0 assets 2 500 --futurenet"
    echo "===== History Archive URLs ====="

csokun

docker run -v $PWD/history:/working stellar/stellar-etl stellar-etl export_ledger_entry_changes \
  --start-ledger 2 \
  --end-ledger 500 \
  --output /working/ \
  --gcs-bucket "" \
  --testnet \
  -x /usr/bin/stellar-core \
  -c docker/stellar-core_testnet.cfg

csokun

apiVersion: apps/v1
kind: Deployment
metadata:
  name: nginx-deployment
spec:
  selector:
    matchLabels:
      app: nginx
  replicas: 2 # tells deployment to run 2 pods matching the template
  template:

csokun

{{ $times := 2 }}
{{- range $i := until $times }}
#{{ $i }}
{{- end }}

csokun

# user <1---*> playlist <1---*> playlist_song
(from p in Playlist,
    join: u in assoc(p, :user),
    left_join: ps in assoc(p, :songs),
    where: p.id == ^1 and u.id == ^1,
    group_by: p.id,
    select: %{
        playlist_id: p.id,
        song_count: count(ps.id)
    }

csokun

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'TARGET_DB'
  AND pid <> pg_backend_pid();

csokun

Finch.start_link(name: MyFinch)

url = "https://horizon.stellar.org/accounts/GAFNBDOZBFUKHB4ZY5ANCQ25PM33YLTMWQKW25J7LXNZM3YSHRH3BELY/transactions?limit=200&cursor=119456526699307008&include_failed=true"
Finch.build(:get, url, [{"Accept", "text/event-stream"}]) 
|> Finch.stream(MyFinch, nil, fn
  {:status, status}, _acc ->
    IO.inspect(status)

  {:headers, headers}, _acc ->
    IO.inspect(headers)

csokun

defmodule App.Posts do
  # ref. https://amandasposito.com/elixir/ecto/macro/2021/01/22/macro-ecto-custom-on-conflict.html
  # ref. https://elixirforum.com/t/upsert-conditional-update-e-g-update-only-when-existing-data-is-outdated/55503/2
  
  defmacro custom_on_conflict_update_replace_all(queryable) do
    values =
      :fields
      |> Post.__schema__()
      |> Enum.map(fn f ->
        {f, quote(do: fragment(unquote("EXCLUDED.#{f}")))}

csokun

---
# shared-volume
# ├── app1
# └── app2
---
apiVersion: v1
kind: Pod
metadata:
  name: app1
spec: