Skip to content

Instantly share code, notes, and snippets.

View getdom's full-sized avatar

Dom getdom

View GitHub Profile
@getdom
getdom / bench-enriched.sh
Created April 14, 2026 11:45
Deal Makr DuckDB enriched /search bench (with dirigeants + financey joins)
#!/bin/bash
# Bench des queries /search enrichies (entreprises + dirigeants + financey)
# À lancer sur le serveur Dokploy, pointe sur /tmp/duckbench/bench.duckdb
set -e
DB=/tmp/duckbench/bench.duckdb
DUCKDB=/tmp/duckbench/duckdb
if ! [ -f "$DB" ]; then
echo "ERROR: $DB not found"
@getdom
getdom / bench-pull.sh
Created April 14, 2026 09:53
Deal Makr DuckDB pull bench
#!/bin/bash
# Benchmark du pull Postgres → DuckDB depuis le serveur Dokploy
# Usage:
# PG_PASSWORD=xxx ./bench-pull.sh
# ou le password est injecté via env var PG_PASSWORD
set -e
PG_PASSWORD="${PG_PASSWORD:?Set PG_PASSWORD env var}"
PG_HOST="${PG_HOST:-db.toblqnpormrlyjjunwcp.supabase.co}"
PG_USER="${PG_USER:-postgres}"