Skip to content

Instantly share code, notes, and snippets.

View cblanc's full-sized avatar
🐇
♞

Christopher Blanchard cblanc

🐇
♞
47 followers · 16 following
View GitHub Profile
@cblanc
cblanc / CLAUDE.md
Created August 18, 2025 09:08
Ask PG

CLAUDE.md

Overview

PostgreSQL database documentation system for LLM querying across multiple databases. Documentation structured as markdown files for schemas/tables.

Structure

Databases defined in db.yml. Hierarchy:

@cblanc
cblanc / postal_counties.json
Created February 11, 2022 09:52
JSON Postal Counties based on https://en.wikipedia.org/wiki/List_of_postcode_districts_in_the_United_Kingdom
{
"AB13": "Aberdeenshire",
"AB14": "Aberdeenshire",
"AB15": "Aberdeenshire",
"AB21": "Aberdeenshire",
"AB24": "Aberdeenshire",
"AB99": "Aberdeenshire",
"AB30": "Kincardineshire",
"AB31": "Kincardineshire",
"AB32": "Aberdeenshire",
@cblanc
cblanc / machine.js
Created January 4, 2021 04:52
Generated by XState Viz: https://xstate.js.org/viz
const INPUT = { INPUT: { actions: "input" } };
const CLOSE = { CLOSE: "closed" };
const SUGGEST = { SUGGEST: "suggesting" };
const NOTIFY = { NOTIFY: "notifying" };
const fetchMachine = Machine({
initial: "closed",
context: {
suggestions: [],
@cblanc
cblanc / cache.ts
Created December 28, 2020 05:59
Autocomplete Cache
import { Client } from "@ideal-postcodes/core-browser";
import { AddressSuggestion, Address } from "@ideal-postcodes/api-typings";
export class ApiCache {
private client: Client;
private cache: Record<string, AddressSuggestion[]>;
private prefix = "!";
constructor(client: Client) {
this.client = client;
@cblanc
cblanc / iso-counties.json
Created June 22, 2020 14:46
GB ISO Codes <-> Postcodes.io
{
"Buckinghamshire": "GB-BKM",
"Cambridgeshire": "GB-CAM",
"Cumbria": "GB-CMA",
"Derbyshire": "GB-DBY",
"Devon": "GB-DEV",
"Dorset": "GB-DOR",
"East Sussex": "GB-ESX",
"Essex": "GB-ESS",
"Gloucestershire": "GB-GLS",
@cblanc
cblanc / score_postcodes.ts
Created May 18, 2020 14:58
import * as fs from "fs";
import * as path from "path";
import * as csv from "fast-csv";
interface NumberScore {
scores: number[];
remainingString: string;
}
const extractNumbers = (input: string): NumberScore => {
@cblanc
cblanc / postcodesio.sh
Created October 22, 2019 10:47
Various commands to run on postcodes.io.db docker container
# Start docker container
docker run -p 5432:5432 -e POSTGRES_USER=postcodesio -e POSTGRES_DB=postcodesiodb -e POSTGRES_PASSWORD=password idealpostcodes/postcodes.io.db
# Generate postcode list
psql -h 0.0.0.0 -p 5432 --username postcodesio postcodesiodb -t -A -F"," -c "SELECT postcode FROM postcodes ORDER BY postcode" > postcodes.csv
@cblanc
cblanc / outcodes.bash
Last active February 11, 2019 10:55
UK Outcodes generated from postcodes.io
docker pull idealpostcodes/postcodes.io.db
docker run -p 5432:5432 idealpostcodes/postcodes.io.db
psql -h 0.0.0.0 --username=postgres postgres -c "COPY (SELECT outcode FROM outcodes ORDER BY outcode) TO STDOUT WITH CSV DELIMITER ','" | pbcopy
@cblanc
cblanc / postcodesio.pl
Last active February 9, 2019 22:09
Postcodes.io - Perl Example Postcode Lookup
#!/usr/bin/perl
# Kindly provided by github/@digdilem
my $pc = "TQ13 9XT"; # Example postcode (Dartmoor National Park Visitor's Centre, Haytor)
use LWP;
use JSON qw( decode_json );
my $ll_url = "https://api.postcodes.io/postcodes/$pc";
@cblanc
cblanc / extraction.sh
Created January 7, 2019 08:39
Extract NL streetnames / postcodes
# Get raw dataset
wget https://s3.amazonaws.com/data.openaddresses.io/runs/554587/no/countrywide.zip
unzip countrywide.zip
# Extract street and postcode from CSV, get unique elements and stream to file
awk -F "\"*,\"*" '{print $4,$9}' countrywide/nl/countrywide.csv | uniq > nl-postcodes.txt