Will Anderson itsananderson

This script produces a sqlite3 binary with the necessary extensions to recover a Calibre metadata.db database. This seems to have worked for me, but I am not affiliated with the Calibre project, and it's also very possible that this will break your Calibre database in some subtle way. YMMV

First run calibre-sqlite.sh to produce a sqlite3 binary:

chmod +x calibre-sqlite.sh
./calibre-sqlite.sh

Get a token from https://github.com/settings/tokens

npm install babel-cli babel-preset-es2015 request
mkdir out
./node_modules/.bin/babel index.js -o out/index.js
node out/index.js <token>

Three.JS Cubes

Based on https://www.reddit.com/r/datasets/comments/3bxlg7/i_have_every_publicly_available_reddit_comment/

Generated using the script attached to this gist

	Set-ExplorerOptions -showHidenFilesFoldersDrives -showProtectedOSFiles -showFileExtensions
	Enable-RemoteDesktop

	cinst 1password
	cinst 7zip
	cinst 7zip.install
	cinst AdobeAIR
	cinst adobereader
	cinst Atom
	cinst markdownpad2

	<Page
	x:Class="App2.MainPage"
	xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
	xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
	xmlns:local="using:App2"
	xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
	xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
	mc:Ignorable="d">

	<StackPanel Background="{ThemeResource ApplicationPageBackgroundThemeBrush}">

	// It's a bit messy, but it seems to work

	function player(name) {
	this.name = name;
	this.questionCount = 0;
	this.number;
	}

	player.prototype.setOther = function(other, otherNumber) {
	this.other = other;

	<?xml version="1.0" encoding="utf-8"?>
	<!--
	This configuration file is required if iisnode is used to run node processes behind
	IIS or IIS Express. For more information, visit:

	https://github.com/tjanczuk/iisnode/blob/master/src/samples/configuration/web.config
	-->

	<configuration>
	<system.webServer>

	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
	</head>
	<body>
	<h1>Will's page </h1>
	My name is <b>Will</b>. I am <font size="+1" color="red">11</font> years old.
	<p>This is a new paragraph. </p>
	</body>
	</html>

	$ ./topthree.sh
	./out/RC_2007-10.json \| reddit.com 88601 \| politics 34088 \| programming 16162
	./out/RC_2007-11.json \| reddit.com 223377 \| politics 88473 \| programming 32838
	./out/RC_2007-12.json \| reddit.com 195181 \| politics 112025 \| programming 31726
	./out/RC_2008-01.json \| reddit.com 234405 \| politics 144953 \| programming 39374
	./out/RC_2008-02.json \| reddit.com 247924 \| politics 109893 \| programming 31063
	./out/RC_2008-03.json \| reddit.com 207092 \| politics 83375 \| programming 34642
	./out/RC_2008-04.json \| reddit.com 140944 \| politics 64532 \| programming 40958
	./out/RC_2008-05.json \| reddit.com 149251 \| politics 74204 \| pics 44095
	./out/RC_2008-06.json \| reddit.com 125032 \| politics 74453 \| pics 40568