Skip to content

Instantly share code, notes, and snippets.


Alexander Mills ORESoftware

View GitHub Profile
ORESoftware / non-recursive.ts
Last active Feb 23, 2022
doing simple dynamic programming for finding squares using previous computation
View non-recursive.ts
// begin
const findAllSquares = (n: number) :Array<[number,number]> => {
let squares : Array<[number,number]> = [[0,0], [1,1]];
let diff = 1;
for(let i = 2; i <= n; i++){
const prev = squares[squares.length-1][1];
ORESoftware / declaration.js
Created Feb 23, 2022
function declaration order matters Tom! :)
View declaration.js
function first(){
function second(){
ORESoftware / lacuna.ts
Last active Apr 29, 2021
lacuna stuff
View lacuna.ts
const list = ['a', 'b', 'c', 'c', 'd', 'a', 'b', 'a', 'a', 'd', 'b'];
const findMin = (char1: string, char2: string, arr: Array<string>) : Number => {
let char1Index = -1;
let char2Index = -1;
let min = Number.MAX_SAFE_INTEGER;
for (let i = 0; i < arr.length; i++) {
ORESoftware /
Created Jan 4, 2021
how to create table partitions programmatically (with a loop)

Loop to create partitions does not work b/c a "CREATE TABLE" statement cannot be a prepared statement (laaaame).

do $$
counter integer := 0;
while counter <= 500 loop
    PREPARE create_table(int) AS
 CREATE TABLE mbk_auth_method_$1 PARTITION OF mbk_auth_method FOR VALUES WITH (modulus 500, remainder $1);
ORESoftware /
Created Jan 4, 2021
how to partition on user_id, but use modulus, in order to avoid too many partitions?

how do I create partition based on modulus of an id? something like this:

create table my_table(id bigint)
partition by value (modulus(id,1000));

create table my_table_0
partition of my_table
for values in (0);
ORESoftware / ovpn.conf
Created Dec 28, 2020
openvpn conf to route only certain traffic through VPN is not working :(
View ovpn.conf
dev tun
remote-cert-tls server
remote 1194 udp

If I want to create an async queue with concurrency = 1, I use promises like so:

let p = Promise.resolve()

export const runTask(run, onerror){
    return p = p.then(run, onerror);
ORESoftware /
Last active Jul 22, 2020
how to tell yourself when you need to merge with master / integration when you are working on a feature branch

this will work on linux where notify-send is installed

throw this snippet into ~/.bashrc


ORESoftware / query.json
Created Jul 6, 2020
es query for version 7
View query.json
"from": 0,
"query": {
"bool": {
"must": [
"simple_query_string": {
"query": "*"
ORESoftware /
Last active May 27, 2020
rosanna joy hetrick

love stanza 1

i express my love differently than some people i think pictures are nice but black and white text is cool too i think you make tasty snax you are a kickass persona

zan fux