Skip to content

Instantly share code, notes, and snippets.

View rmloveland's full-sized avatar

Rich Loveland rmloveland

14 followers · 5 following
View GitHub Profile
@rmloveland
rmloveland / reldupes.pl
Last active December 1, 2020 15:22
#!perl
use strict;
use warnings;
use experimentals;
use constant DEBUG => undef;
die usage() unless scalar @ARGV >= 2;
@rmloveland
rmloveland / bookstores-initial-import-20200911.sql
Created December 8, 2020 19:42
Data set created by downloading a list of bookstores from American Bookseller Association. Geometries added by getting lon/lat using geocoding based on some Tiger/LINE data.
This file has been truncated, but you can view the full file.
CREATE TABLE IF NOT EXISTS public.bookstores (
id UUID NOT NULL DEFAULT gen_random_uuid(),
name STRING NOT NULL,
url STRING NULL,
phone STRING NULL,
address STRING NOT NULL,
description STRING NULL,
geom GEOMETRY NULL,
CONSTRAINT "primary" PRIMARY KEY (id ASC),
INVERTED INDEX bookstore_geom_idx (geom),
@rmloveland
rmloveland / page-lengths.txt
Last active February 24, 2021 21:25
3 admin-ui-cluster-overview-page.md
3 admin-ui-statements-page.md
3 cockroachdb-architecture.md
4 admin-ui-overview.md
5 import-data.md
5 install-cockroachdb-spatial.md
6 performance-benchmarking-with-tpc-c-10-warehouses.md
6 performance-benchmarking-with-tpc-c-100k-warehouses.md
6 performance-benchmarking-with-tpc-c-10k-warehouses.md
6 performance-benchmarking-with-tpc-c-1k-warehouses.md