Skip to content

Instantly share code, notes, and snippets.

View Dreeseaw's full-sized avatar

William Dreese Dreeseaw

  • Chartbeat
  • Brooklyn, NY
View GitHub Profile
@Dreeseaw
Dreeseaw / duckflake.py
Created October 22, 2022 22:56
a simple python app to mimic snowflake via duckdb
import sqlparse
import duckdb
from duckdb import DuckDBPyConnection as DuckConn
from fastapi import FastAPI
from datetime import datetime
from typing import List, Any, Tuple
app = FastAPI()
conn = duckdb.connect(database=':memory:', read_only=False)
@Dreeseaw
Dreeseaw / TwitchSubsToLights.go
Created May 18, 2022 00:32
A Google Cloud Function (Go 1.16) that changes a streamer's lights based on chat events
// Package p contains an HTTP Cloud Function.
package p
import (
"encoding/json"
"fmt"
"io/ioutil"
"net/http"
"strings"
"net/url"