cblanc

2,3,5,7,11,13,17,19,23,29,31,37,41,43,47,53,59,61,67,71,73,79,83,89,97,101,103,107,109,113,127,131,137,139,149,151,157,163,167,173,179,181,191,193,197,199,211,223,227,229,233,239,241,251,257,263,269,271,277,281,283,293,307,311,313,317,331,337,347,349,353,359,367,373,379,383,389,397,401,409,419,421,431,433,439,443,449,457,461,463,467,479,487,491,499,503,509,521,523,541,547,557,563,569,571,577,587,593,599,601,607,613,617,619,631,641,643,647,653,659,661,673,677,683,691,701,709,719,727,733,739,743,751,757,761,769,773,787,797,809,811,821,823,827,829,839,853,857,859,863,877,881,883,887,907,911,919,929,937,941,947,953,967,971,977,983,991,997,1009,1013,1019,1021,1031,1033,1039,1049,1051,1061,1063,1069,1087,1091,1093,1097,1103,1109,1117,1123,1129,1151,1153,1163,1171,1181,1187,1193,1201,1213,1217,1223,1229,1231,1237,1249,1259,1277,1279,1283,1289,1291,1297,1301,1303,1307,1319,1321,1327,1361,1367,1373,1381,1399,1409,1423,1427,1429,1433,1439,1447,1451,1453,1459,1471,1481,1483,1487,1489,1493,1499,1511,1523,1531,1543,1549,1

cblanc

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

{
  "AB13": "Aberdeenshire",
  "AB14": "Aberdeenshire",
  "AB15": "Aberdeenshire",
  "AB21": "Aberdeenshire",
  "AB24": "Aberdeenshire",
  "AB99": "Aberdeenshire",
  "AB30": "Kincardineshire",
  "AB31": "Kincardineshire",
  "AB32": "Aberdeenshire",

cblanc

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

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

{
  "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

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

# 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

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

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