danthegoodman1

TAP_DEV="tap0"
TAP_IP="172.16.0.1"
MASK_SHORT="/30"

# Setup network interface
sudo ip link del "$TAP_DEV" 2> /dev/null || true
sudo ip tuntap add dev "$TAP_DEV" mode tap
sudo ip addr add "${TAP_IP}${MASK_SHORT}" dev "$TAP_DEV"
sudo ip link set dev "$TAP_DEV" up

danthegoodman1

import requests

def ttfb(bucket, path):
    url = f'https://{bucket}.s3.amazonaws.com/{path}'
    response = requests.get(url, stream=True)
    return response.elapsed.total_seconds()
  
print(ttfb('tcga-2-open', '/08fe7d9d-05b0-46dd-a4f7-2794b88d3a1e/251262%%20984e48d4-d2d0-4dee-957a-20a9d1150781.htseq.counts.gz'))

danthegoodman1

select ascii('🍊'), ascii('a'), bin('🍊'), bin('a'), reinterpretAsInt64(reverse(unbin(bin('🍊')))) as tan, reinterpretAsInt64(reverse(unbin(bin('a')))) as a, hex(a)

danthegoodman1

-- Rolling ndr
with tbl as (
-- fake table
select c1 as usr, c2 as price, c3 as d from VALUES (
	('a', 10, toDate('2023-08-09'))
	, ('a', 10, toDate('2023-08-10'))
	, ('a', 8, toDate('2023-08-11'))
	, ('a', 11, toDate('2023-08-12'))
	, ('a', 12, toDate('2023-08-13'))
	, ('b', 10, toDate('2023-08-09'))

danthegoodman1

with tbl as (
-- fake table
select c1 as usr, c2 as price, c3 as d from VALUES (
	('a', 10, toDate('2023-08-09'))
	, ('a', 10, toDate('2023-08-10'))
	, ('a', 8, toDate('2023-08-11'))
	, ('a', 11, toDate('2023-08-12'))
	, ('a', 12, toDate('2023-08-13'))
	, ('b', 10, toDate('2023-08-09'))
	, ('b', 10, toDate('2023-08-10'))

danthegoodman1

// QRious v4.0.2 | (C) 2017 Alasdair Mercer | GPL v3 License Based on jsqrencode | (C) 2010 [email protected] | GPL v3 License
!function(t,e){"object"==typeof exports&&"undefined"!=typeof module?module.exports=e():"function"==typeof define&&define.amd?define(e):t.QRious=e()}(this,function(){"use strict";function t(t,e){var n;return"function"==typeof Object.create?n=Object.create(t):(s.prototype=t,n=new s,s.prototype=null),e&&i(!0,n,e),n}function e(e,n,s,r){var o=this;return"string"!=typeof e&&(r=s,s=n,n=e,e=null),"function"!=typeof n&&(r=s,s=n,n=function(){return o.apply(this,arguments)}),i(!1,n,o,r),n.prototype=t(o.prototype,s),n.prototype.constructor=n,n.class_=e||o.class_,n.super_=o,n}function i(t,e,i){for(var n,s,a=0,h=(i=o.call(arguments,2)).length;a<h;a++){s=i[a];for(n in s)t&&!r.call(s,n)||(e[n]=s[n])}}function n(){}var s=function(){},r=Object.prototype.hasOwnProperty,o=Array.prototype.slice,a=e;n.class_="Nevis",n.super_=Object,n.extend=a;var h=n,f=h.extend(function(t,e,i){this.qrious=t,this.element=e,this

danthegoodman1

curl \
-H "Authorization: Bearer <TOKEN>" \
-X POST "https://api.us-east.tinybird.co/v0/datasources" \
-d "schema=timestamp DateTime64(3) \`json:$.timestamp\`, _metadata_bundledIds Array(Nullable(String)) \`json:$._metadata.bundledIds[:]\`, 
_metadata_bundled Array(Nullable(String)) \`json:$._metadata.bundled[:]\`, _metadata_unbundled Array(Nullable(String)) 
\`json:$._metadata.unbundled[:]\`, anonymousId Nullable(String) \`json:$.anonymousId\`, channel Nullable(String) \`json:$.channel\`, context 
Nullable(String) \`json:$.context\`, messageId Nullable(String) \`json:$.messageId\`, originalTimestamp Nullable(DateTime64(3)) 
\`json:$.originalTimestamp\`, projectId Nullable(String) \`json:$.projectId\`, receivedAt Nullable(DateTime64(3)) \`json:$.receivedAt\`, sentAt 
Nullable(DateTime64(3)) \`json:$.sentAt\`, type Nullable(String) \`json:$.type\`, userId Nullable(String) \`json:$.userId\`, version Nullable(Int16) 
\`json:$.version\`, properties Nullable(String) CODEC(ZSTD) \`json:$.properties\`, name Nullable

danthegoodman1

alias rm="find . && rm"
alias cd="sleep 1 && cd"
alias ls="sleep 1 && ls"
export PROMPT_COMMAND="cd"

danthegoodman1

// Immediate execution, for of with indexes, in order
const r = ["a",2,3,4,5]
const t = (i) => {
    return new Promise((resolve, reject) => {
        setTimeout(() => {
            resolve(`hi ${i}`)
        }, 1000 * i)
    })
}

danthegoodman1

const Compute = require('@google-cloud/compute')
const compute = new Compute({
    projectId: '[PROJECT NAME]',
    keyFilename: './keyFile.json'
})
const zone = compute.zone('us-east1-b')

const config = {
    http: true,
    https: true,