Skip to content

Instantly share code, notes, and snippets.

@ronaldbradford
ronaldbradford / ANALYSIS.md
Last active November 4, 2026 07:42
VillageSQL Installation Error - Unable to lock ibdata1 - Ubuntu 24.04

Debugging

sudo lsof .villagesql/data/ibdata1
sudo fuser -v  .villagesql/data/ibdata1
INODE=$(stat -c %i .villagesql/data/ibdata1)
grep ":$INODE " /proc/locks
ps -ef | grep [m]ysqld
systemctl list-units --all | grep -Ei 'mysql|villagesql'
.villagesql/prebuilt/bin/mysqld --verbose --help | grep -E '^datadir'
@ronaldbradford
ronaldbradford / INFO.txt
Created October 28, 2026 06:15
DGX Spark
```
$ uname -a
Linux spark-a414 7.0.0-1019-nvidia #19~24.04.2-Ubuntu SMP PREEMPT_DYNAMIC Sun Sep 6 18:35:11 UTC 2 aarch64 aarch64 aarch64 GNU/Linux
$ cat /etc/os-release
PRETTY_NAME="Ubuntu 24.04.5 LTS"
NAME="Ubuntu"
VERSION_ID="24.04"
VERSION="24.04.5 LTS (Noble Numbat)"
VERSION_CODENAME=noble
@ronaldbradford
ronaldbradford / README.md
Created September 20, 2026 22:18
vsql_duckdb smoke-test examples + RESULTS (VillageSQL local TSV/Parquet/JSON/Hive/.duckdb, HTTP, remote geonames, shell.duckdb.org)

vsql_duckdb local + remote smoke-test bundle

Example files and the full mysql transcript for VillageSQL vsql_duckdb tests (8.4.11-villagesql-0.0.7-dev).

GitHub gists are flat (no directories). Binary Hive partitions are included both as flat files and inside examples.tar.gz (unpack to restore region=*/).

Contents

@ronaldbradford
ronaldbradford / RESULTS-doc-similarity-1024.md
Created September 20, 2026 09:45
VillageSQL Vector Handling

RESULTS — 1024-dim document similarity (exact scan)

Generated: 2026-09-20 09:42 UTC

Context

  • Source SQL: attached *.sql (VillageSQL / vsql-vector example: 1024-dim document similarity search)
  • Instance: nightly socket /workspace/mysql-data/mysql.sock
  • Client: /workspace/build/villagesql/bin/mysql -uroot --table --raw --force --show-warnings
  • Wrapper added before the script (script itself had no USE):
@ronaldbradford
ronaldbradford / check-pq-ssh.sh
Last active July 20, 2026 06:21
Check for Post-quantum SSH handling
#!/usr/bin/env bash
#
# check-pq-ssh.sh
# Check whether this machine negotiates post-quantum SSH key exchange
# with GitHub, and whether a macOS crypto policy is overriding defaults.
#
# Companion script for:
# https://ronaldbradford.com/blog/ (post-quantum SSH investigation)
#
# Usage:
@ronaldbradford
ronaldbradford / mysql97.yml
Created June 18, 2026 16:15
MySQL 9.7 Cloud Init Yaml
#cloud-config
# MySQL 9.7 LTS install for CentOS Stream 9 (works on aarch64/ARM64).
#
# Notes:
# - The repo URL path is mysql-9.7-community (NOT mysql-9.7-lts-community);
# only the repo *id* carries the -lts- label.
# - MySQL's published GPG key file still shows expired (2025-10-22) even
# though the key was re-extended, and the RPM-GPG-KEY-mysql-2025 URL is
# empty. So gpgcheck is disabled here to keep an unattended boot from
# failing. Re-enable once MySQL refreshes the published key file.
@ronaldbradford
ronaldbradford / README.md
Created June 14, 2026 21:19
Using GenAI with a MySQL 8.0 Production Environment
@ronaldbradford
ronaldbradford / do-i-need-the-sdk.md
Last active June 2, 2026 21:14
VillageSQL Extension Skill Builder Chats

On a different system with claude context, installed SDK and built skills.

It eventually got to that answer, but it should be more direct.

https://github.com/villagesql/villagesql-server/releases

FWIW, neither https://github.com/villagesql/villagesql-skills or https://github.com/villagesql/villagesql-skills/tree/main/skills/vsql-extension-builder spell it our as a pre-requisite.

  Regarding your other question — can the extension builder skill work with just the prebuilt binary? Yes, the vsql-extension-builder skill only needs the VillageSQL SDK (headers + cmake modules) to build, and
@ronaldbradford
ronaldbradford / dbdeployer.yaml
Created May 28, 2026 05:59
Dbdeployer PostgreSQL demo via Orb
#cloud-config
# Debian/Ubuntu demo VM for dbdeployer + PostgreSQL + ProxySQL
packages:
- libncurses6
- libaio-dev
- libnuma1
- liburing2
- libdigest-sha-perl
- postgresql-common
#!/usr/bin/bash
[[ -n ${TRACE:-} ]] && set -x
# DBDeployer - The MySQL Sandbox
# Copyright (C) 2006-2020 Giuseppe Maxia
# Creator: Ronald Bradford
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at