Skip to content

Instantly share code, notes, and snippets.

Avatar
🏐
Focusing

Alexander Mills ORESoftware

🏐
Focusing
View GitHub Profile
@ORESoftware
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
ORESoftware / declaration.js
Created Feb 23, 2022
function declaration order matters Tom! :)
View declaration.js
function first(){
second();
}
first();
function second(){
@ORESoftware
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
ORESoftware / partitions.md
Created Jan 4, 2021
how to create table partitions programmatically (with a loop)
View partitions.md

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

do $$
declare
counter integer := 0;
begin
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
ORESoftware / partition.md
Created Jan 4, 2021
how to partition on user_id, but use modulus, in order to avoid too many partitions?
View partition.md

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
ORESoftware / ovpn.conf
Created Dec 28, 2020
openvpn conf to route only certain traffic through VPN is not working :(
View ovpn.conf
client
nobind
dev tun
remote-cert-tls server
remote 35.209.20.300 1194 udp
<key>
-----BEGIN PRIVATE KEY-----
View promises-vs-obs.md

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
ORESoftware / ubuntu.md
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
View ubuntu.md

this will work on linux where notify-send is installed

throw this snippet into ~/.bashrc

((

    branch_name=dev
@ORESoftware
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
ORESoftware / rjh.md
Last active May 27, 2020
rosanna joy hetrick
View rjh.md

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