David Wolever wolever

Fractional indexing is a technique for assigning a rank to ordered items, where an item's position can be changed - or a new item introduced - with only one rank value update.

For example, given the items:

{ name: "a", rank: 1 }
{ name: "c", rank: 2 }

With a naive rank ordering scheme, introducing "b" in between "a" and "c" would

	/*
	change_logs: use triggers to automatically track changes to certain columns in
	database tables.

	To enable change tracking for a table:

	select change_logs_track_table(
	-- table name
	'table_to_track',
	-- primary key column

	<html>
	<head>
	<script src="./battleship.js"></script>
	<style>
	.board,
	.heatmap {
	border: 1px solid black;
	margin: 5px;
	display: inline-block;
	}

	Machine({
	id: 'KNIT',
	initial: 'idle-no-flow',
	states: {
	'idle-no-flow': {
	on: {
	FLOW_ASSIGN: 'idle-with-flow'
	}
	},

	/**
	* Catches any exception which might be raised by a promise and returns a
	* tuple of [result, error], where either the result or the error will be
	* undefined:
	*
	* let [res, error] = await maybe(someApi.get(...))
	* if (err) {
	* return `Oh no there was an error: ${err}`
	* }
	* console.log('The result:', res)

	-- HANDLE SCROLLING WITH MOUSE BUTTON PRESSED
	local scrollMouseButton = 3
	local deferred = false

	overrideOtherMouseDown = hs.eventtap.new({ hs.eventtap.event.types.otherMouseDown }, function(e)
	-- print(hs.eventtap.event.properties['mouseEventButtonNumber'])
	local mouseButton = e:getProperty(hs.eventtap.event.properties['mouseEventButtonNumber'])
	if mouseButton == scrollMouseButton then
	deferred = true
	return true

	CREATE OR REPLACE VIEW accounts.address_token_balances AS (
	SELECT
	address_hash,
	token_contract_address_hash,
	block_number,
	LEAD(block_number, 1, 2147483647) OVER (
	PARTITION BY address_hash, token_contract_address_hash
	ORDER BY block_number ASC
	) as next_block_number,
	SUM(amount) OVER (

	#!/usr/bin/env node

	// My modifications to this code are public domain

	const { writeSync, readFile } = require("fs")
	const async_hooks = require("async_hooks")

	function showStack() {
	let e = new Error()
	writeSync(1, e.stack.split('\n').slice(2).join('\n') + '\n')

	#!/bin/bash
	# STOP! Before going any further, think: are you going to regret the decision
	# to write this script?
	# Deciding to write this in bash was not one of my better decisions.
	# -- https://twitter.com/alex_gaynor/status/369892494114164736

	IFS="`printf "\n\t"`"
	set -u

	if [[ "$#" -lt 2 ]]; then