Ryan Murphy rdmurphy

My favorite command line tools (2021-09-09)

I wrote this in response to Gurman's tweet. I remember answering in News Nerdery, but it was sadly lost to the void. :(

The CSV Swiss-army knife that trumps all others. Written in Rust, so it's absurdly fast in a way that's still kind of shocking.

I hereby claim:

To claim this, I am signing this object:

	#-------------------------------------------------------------------------------
	# Name: combine_mbtiles.py
	# Purpose: Processes multiple sqlite .mbtiles files into single file (or by level? or by degree grids?)
	#
	# Author: joshn. Modified by ache015
	#
	# Created: 18/11/2014
	#
	# Last Modified: 10/11/2018
	#-------------------------------------------------------------------------------

	! Hide everything in Twitter's sidebar except the search bar and footer (just for visual balance, not because we care about copyright notices)
	twitter.com##div[aria-label="Trending"] > div > div:nth-child(n+3):not(:last-child)
	! Hide my follower total wherever it appears on Twitter for my sanity (swap in your username, of course)
	twitter.com##[href="/rdmurphy/followers"]

	<script>
	import Paragraph from "./Paragraph.svelte";
	export let name = "Abe";
	</script>

	<h1>Hello, {name}!</h1>
	<Paragraph />

	from django.db.models import Aggregate, FloatField


	class Median(Aggregate):
	function = 'PERCENTILE_CONT'
	name = 'median'
	output_field = FloatField()
	template = '%(function)s(0.5) WITHIN GROUP (ORDER BY %(expressions)s)'

	<!DOCTYPE html>
	<meta charset="utf-8">
	<title>SANKEY Experiment</title>
	<style>

	.node rect {
	cursor: move;
	fill-opacity: .9;
	shape-rendering: crispEdges;
	}

	#!/usr/bin/env python

	from agate.computations import Computation
	from agate.data_types import Number
	from agate.exceptions import DataTypeError

	from agategeo.utils import haversine


	class Distance(Computation):