Skip to content

Instantly share code, notes, and snippets.

View ORESoftware's full-sized avatar
🏐
Focusing

Alexander Mills ORESoftware

🏐
Focusing
View GitHub Profile
@ORESoftware
ORESoftware / non-recursive.ts
Last active February 23, 2022 20:58
doing simple dynamic programming for finding squares using previous computation
// 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 February 23, 2022 01:06
function declaration order matters Tom! :)
function first(){
second();
}
first();
function second(){
@ORESoftware
ORESoftware / lacuna.ts
Last active April 29, 2021 18:41
lacuna stuff
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 January 4, 2021 04:57
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 $$
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 January 4, 2021 00:40
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
ORESoftware / ovpn.conf
Created December 28, 2020 07:03
openvpn conf to route only certain traffic through VPN is not working :(
client
nobind
dev tun
remote-cert-tls server
remote 35.209.20.300 1194 udp
<key>
-----BEGIN PRIVATE KEY-----

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 July 22, 2020 18:07
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

((

    branch_name=dev
@ORESoftware
ORESoftware / query.json
Created July 6, 2020 19:55
es query for version 7
{
"from": 0,
"query": {
"bool": {
"must": [
{
"simple_query_string": {
"query": "*"
}
},
@ORESoftware
ORESoftware / rjh.md
Last active May 27, 2020 21:48
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