Skip to content

Instantly share code, notes, and snippets.

@ukutaht
ukutaht / migration.sql
Created November 18, 2021 09:34
[Plausible Analytics] Clickhouse primary key migration
-- new events table
CREATE TABLE events_v2
(
`timestamp` DateTime Codec(DoubleDelta, LZ4),
`name` String,
`domain` String,
`user_id` UInt64,
`session_id` UInt64,
`hostname` String,
`pathname` String,
--
-- changes: rename type -> kind
--
ALTER TABLE changes CHANGE type kind VARCHAR(255);
--
-- stories: add state, drop complete
--
@ukutaht
ukutaht / etfid.md
Last active February 14, 2017 14:43

Artisan

I think we all know that Artisan could be improved massively and we have ideas on how to make it better. There have been a number of attempts to rewrite the codebase. None of them have been shipped and they're at different levels of completion.

My proposal is not to attempt a rewrite. Instead, let's dust off the original codebase to start fixing issues and developing new features iteratively. We'll form a team around the project, working as we do on studio client projects. This will be also serve as a team where apprentices can experience working on something that is very close to a real client project.

Keybase proof

I hereby claim:

  • I am ukutaht on github.
  • I am ukutaht (https://keybase.io/ukutaht) on keybase.
  • I have a public key whose fingerprint is 3052 EAFD DC38 6ADF C6CC 3E1C 4377 FE4E 517E DBC5

To claim this, I am signing this object:

The story of the week of the game of Conways Game of Life

Day 1

In the beginning, there was a vast emptyness. The emtpyness was neatly divided into squares. In the emptyness Mr Conway placed a single cell.

Day 2

The cell was dead. Mr Conway was sad.

He figured that the cell had died from lonelyness, so he placed two new cells on the grid next to each other.

@ukutaht
ukutaht / plan.md
Last active August 29, 2015 14:14
8L video

Intro

Timelapse of London(sunrise?). Show some double-deckers and black cabs.

Office walkthrough

Camera is behind the door on our floor in Headspace. Daniel and Skim appear on the other side of the door and greet viewers("Welcome! Welcome to 8L London. Come inside and have a look at our shiny new office"). They walk to the couch area in the front and say a few words about it.

Walk to the Vault

" Based on
runtime colors/ir_black.vim
let g:colors_name = "grb256"
hi pythonSpaceError ctermbg=red guibg=red
hi Comment ctermfg=darkgray
hi StatusLine ctermbg=darkgrey ctermfg=white
@ukutaht
ukutaht / carousel.js
Created October 17, 2013 22:21 — forked from ksolo/carousel.js
Image Carousel
@ukutaht
ukutaht / app.js
Last active December 25, 2015 19:49
Javascript form validation
$(document).ready(function(){
$(document).on("submit","form", function(event){
event.preventDefault();
var email = $("form").find("#email").val();
var password = $("form").find("#password").val();
var errors = checkEmailErrors(email).concat(checkPasswordErrors(password));
if (errors.length === 0){