ninyawee

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:

ninyawee

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

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

ninyawee

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

ninyawee

$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

ninyawee

ninyawee

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;

ninyawee

#!/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

ninyawee

#!/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

ninyawee

#!/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"

ninyawee

if command -v cursor &> /dev/null; then
    export EDITOR="$(command -v cursor) --wait"
    export SUDO_EDITOR="$(command -v cursor) --wait"
fi