Nutchanon (Ben) Ninyawee ninyawee

## clickhouse-user-agent-behavior.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                ninyawee
                / clickhouse-user-agent-behavior.md
            
            
              Created
              July 31, 2025 06:23
            
              
                ClickHouse.com User-Agent Based Content Serving Explanation
              
          
    ClickHouse.com User-Agent Based Content Serving

The ClickHouse website (https://clickhouse.com/) serves different content based on the User-Agent header in the HTTP request.
How it Works

For Command-Line Tools (Default curl/wget)

When accessed with command-line tools like curl or wget, the server returns a shell installation script:


## ipv6_finder.py
#!/usr/bin/env -S uv run --script
# /// script
# dependencies = [
#   "ipaddress",
# ]
# ///

"""
IPv6 Finder - A utility to find IPv6 addresses for Tailscale 4via6 subnet routers.

## db dump.sh
pg_dump -h dev_host -U dev_user -d dev_db -- no-owner -- no-privileges -f db_dev.sql
psql -h 127.0.0.1 -U local_user local_db -f db_dev.sql

## edit_with_cursor.ps1
$cursorPath = "c:\Users\lifep\AppData\Local\Programs\cursor\resources\app\bin\cursor"
$arguments = "--wait", "--reuse-window"
if ($args.Count -gt 0) {
    $arguments += $args
}
Start-Process -FilePath $cursorPath -ArgumentList $arguments -WindowStyle Hidden -Wait

## console.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                ninyawee
                / console.ipynb
            
            
              Created
              February 6, 2025 16:23
            
              
                jupyter sql init
              
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## clone schema.sql
CREATE OR REPLACE FUNCTION clone_schema(source_schema text, dest_schema text)
RETURNS void AS $$
DECLARE
    object text;
    buffer text;
    default_ text;
    column_ text;
BEGIN
    EXECUTE 'CREATE SCHEMA ' || dest_schema;

## ai_db_context
#!/usr/bin/env bash
# mise description="Generate the DB schema for the AI Contexts"
set -euo pipefail

cd "$(git rev-parse --show-toplevel)"

mkdir -p ./AIContexts/

docker run --rm -v "$PWD/AIContexts:/data" postgres:15 \
  pg_dump $POSTGRES_URL -s -O -x -n public -t public.* -f /data/db_schema.sql

## db_ai.bash
#!/usr/bin/env bash
# mise description="Generate the DB schema for the AI Contexts"
set -euo pipefail

cd "$(git rev-parse --show-toplevel)"

mkdir -p ./AIContexts/

docker run --rm -v "$PWD/AIContexts:/data" postgres:15 \
  pg_dump $POSTGRES_URL -s -O -x -n public -t public.* -f /data/db_schema.sql

## update_postman.sh
#!/bin/bash

set -euo pipefail

# Directory setup
APP_DIR="${HOME}/Applications/Postman"
BIN_DIR="/usr/bin"
ICON_DIR="${HOME}/.local/share/icons"
DESKTOP_DIR="${HOME}/.local/share/applications"

## profile.sh
if command -v cursor &> /dev/null; then
    export EDITOR="$(command -v cursor) --wait"
    export SUDO_EDITOR="$(command -v cursor) --wait"
fi
	#!/usr/bin/env -S uv run --script
	# /// script
	# dependencies = [
	# "ipaddress",
	# ]
	# ///

	"""
	IPv6 Finder - A utility to find IPv6 addresses for Tailscale 4via6 subnet routers.
	pg_dump -h dev_host -U dev_user -d dev_db -- no-owner -- no-privileges -f db_dev.sql
	psql -h 127.0.0.1 -U local_user local_db -f db_dev.sql
	$cursorPath = "c:\Users\lifep\AppData\Local\Programs\cursor\resources\app\bin\cursor"
	$arguments = "--wait", "--reuse-window"
	if ($args.Count -gt 0) {
	$arguments += $args
	}
	Start-Process -FilePath $cursorPath -ArgumentList $arguments -WindowStyle Hidden -Wait
	CREATE OR REPLACE FUNCTION clone_schema(source_schema text, dest_schema text)
	RETURNS void AS $$
	DECLARE
	object text;
	buffer text;
	default_ text;
	column_ text;
	BEGIN
	EXECUTE 'CREATE SCHEMA ' \|\| dest_schema;
	#!/usr/bin/env bash
	# mise description="Generate the DB schema for the AI Contexts"
	set -euo pipefail

	cd "$(git rev-parse --show-toplevel)"

	mkdir -p ./AIContexts/

	docker run --rm -v "$PWD/AIContexts:/data" postgres:15 \
	pg_dump $POSTGRES_URL -s -O -x -n public -t public.* -f /data/db_schema.sql
	#!/bin/bash

	set -euo pipefail

	# Directory setup
	APP_DIR="${HOME}/Applications/Postman"
	BIN_DIR="/usr/bin"
	ICON_DIR="${HOME}/.local/share/icons"
	DESKTOP_DIR="${HOME}/.local/share/applications"
	if command -v cursor &> /dev/null; then
	export EDITOR="$(command -v cursor) --wait"
	export SUDO_EDITOR="$(command -v cursor) --wait"
	fi