Edmund Horner ejrh
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use std::default::Default; | |
| use bevy::color::palettes::basic::{BLACK, WHITE}; | |
| use bevy::prelude::*; | |
| use bevy::sprite::Anchor; | |
| use bevy::text::TextBounds; | |
| fn main() { | |
| App::new() | |
| .add_plugins(DefaultPlugins) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # From http://www.mieliestronk.com/wordlist.html | |
| aardvark | |
| aardwolf | |
| aaron | |
| aback | |
| abacus | |
| abaft | |
| abalone | |
| abandon | |
| abandoned |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DIMENSIONS = 2 | |
| SCALE = 3 | |
| OUTER_SCALE = SCALE + 2 | |
| STEPS = tuple(OUTER_SCALE**x for x in reversed(range(DIMENSIONS))) | |
| def generate_all_cells(): | |
| def do_slice(offset, depth): | |
| if depth == DIMENSIONS - 1: | |
| for i in range(1, SCALE + 1): | |
| yield offset + i |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| with v as (select version() as ver), | |
| constants(relkind, block_size, header_size, max_align, fill_factor, nonleaf_fill_factor, page_overhead, row_overhead) as ( | |
| values ( | |
| 'r', | |
| current_setting('block_size'), | |
| CASE WHEN SUBSTRING((select ver from v),12,3) IN ('8.0','8.1','8.2') then 28 else 24 end, | |
| CASE WHEN (select ver from v) ~ 'mingw32|64' THEN 8 ELSE 4 end, | |
| 1.0, | |
| null, | |
| 32, |
ejrh
/ busplan.py
Last active
November 24, 2021 01:15
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import itertools | |
| import math | |
| import random | |
| import time | |
| DEPENDENCIES = { | |
| 'wires': {'copper'}, | |
| 'green circuits': {'iron', 'wires'}, | |
| 'red circuits': {'plastic', 'wires', 'green circuits'}, |
ejrh
/ horrible.sql
Created
October 1, 2018 02:12
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| WITH RECURSIVE t AS | |
| ( | |
| SELECT id, '{}'::int[] AS parents, 0 AS level | |
| FROM z_msg WHERE in_reply_to IS NULL | |
| UNION ALL | |
| SELECT c.id, parents || c.in_reply_to, level+1 | |
| FROM t JOIN z_msg AS s c ON t.id = c.in_reply_to | |
| ), | |
| t2 AS |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 04/09/2013 | |
| 2 cups of flour, sifted with: | |
| 1/2 teaspoon salt | |
| 1 heaped tablespoon cocoa | |
| 1 level teaspoon baking powder | |
| 1 level tspn soda | |
| Put in blender 1 cup dates (check for stones), |
ejrh
/ overloaded-virtual.cpp
Created
November 27, 2016 04:11
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #include <boost/shared_ptr.hpp> | |
| #include <boost/make_shared.hpp> | |
| class Message { | |
| }; | |
| class Receiver { | |
| public: | |
| virtual ~Receiver() { } | |
| virtual void receive(Message *msg) = 0; |
ejrh
/ pg_partman trigger func.sql
Created
August 5, 2016 02:00
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE OR REPLACE FUNCTION public.forecast_base_1_part_trig_func() | |
| RETURNS trigger AS | |
| $BODY$ | |
| DECLARE | |
| v_count int; | |
| v_partition_name text; | |
| v_partition_timestamp timestamptz; | |
| BEGIN | |
| IF TG_OP = 'INSERT' THEN | |
| v_partition_timestamp := date_trunc('day', NEW.nwp_analysis_at_date); |
ejrh
/ gist:6e9c74bd65220fe656f8
Created
March 22, 2016 08:33
Btree vs trigram index for short prefixes
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| filesys=# \d file | |
| Table "public.file" | |
| Column | Type | Modifiers | |
| ----------+-----------------------------+--------------------------------------------------- | |
| id | integer | not null default nextval('file_id_seq'::regclass) | |
| name | character varying | not null | |
| size | bigint | not null | |
| modified | timestamp without time zone | | |
| md5 | character(32) | | |
| Indexes: |
NewerOlder