Skip to content

Instantly share code, notes, and snippets.

@anawarka
anawarka / queries.sql
Created April 23, 2025 18:21
Data Validation Queries
-- Three levels of aggregates
-- group by
-- - puid, date
-- - school_id, date
-- - school_id, puid, date
--------------------------------
@anawarka
anawarka / queries.sql
Created April 23, 2025 18:18
Data Validation Queries
-- Three levels of aggregates
-- group by
-- - puid, date
-- - school_id, date
-- - school_id, puid, date
--------------------------------
@wremeika
wremeika / js-cheatsheet.md
Created January 22, 2025 17:00
JS Cheatsheet

JavaScript Cheat Sheet

1. Basics

  • Variables:
    let x = 10;      // Block-scoped, mutable
    const y = 20;    // Block-scoped, immutable
    var z = 30;      // Function-scoped, avoid using
private var firstNames:Array<String> = arrayOf( "Aaran", "Aaren", "Aarez", "Aarman", "Aaron", "Aaron-James", "Aarron", "Aaryan", "Aaryn", "Aayan", "Aazaan", "Abaan", "Abbas", "Abdallah", "Abdalroof", "Abdihakim", "Abdirahman", "Abdisalam", "Abdul", "Abdul-Aziz", "Abdulbasir", "Abdulkadir", "Abdulkarem", "Abdulkhader", "Abdullah", "Abdul-Majeed", "Abdulmalik", "Abdul-Rehman", "Abdur", "Abdurraheem", "Abdur-Rahman", "Abdur-Rehmaan", "Abel", "Abhinav", "Abhisumant", "Abid", "Abir", "Abraham", "Abu", "Abubakar", "Ace", "Adain", "Adam", "Adam-James", "Addison", "Addisson", "Adegbola", "Adegbolahan", "Aden", "Adenn", "Adie", "Adil", "Aditya", "Adnan", "Adrian", "Adrien", "Aedan", "Aedin", "Aedyn", "Aeron", "Afonso", "Ahmad", "Ahmed", "Ahmed-Aziz", "Ahoua", "Ahtasham", "Aiadan", "Aidan", "Aiden", "Aiden-Jack", "Aiden-Vee", "Aidian", "Aidy", "Ailin", "Aiman", "Ainsley", "Ainslie", "Airen", "Airidas", "Airlie", "AJ", "Ajay", "A-Jay", "Ajayraj", "Akan", "Akram", "Al", "Ala", "Alan", "Alanas", "Alasdair", "Alastair", "A
@wremeika
wremeika / NFLTeamListViewModel.kt
Created October 8, 2024 11:30
NFLTeamListViewModel (Android)
import androidx.lifecycle.ViewModel
class NFLTeamListViewModel: ViewModel() {
val teams = listOf(
NFLTeam ("bears", "Chicago Bears", "bears.png", "NFC", "NFC North", "Soldier Field", 41.8625,-87.616667),
NFLTeam ("bengals", "Cincinnati Bengals", "bengals.png", "AFC", "AFC North", "Paul Brown Stadium", 39.095444,-84.516039),
NFLTeam ("bills", "Buffalo Bills", "bills.png", "AFC", "AFC East", "Bills Stadium", 42.773611,-78.786944),
NFLTeam ("broncos", "Denver Broncos", "broncos.png", "AFC", "AFC West", "Empower Field at Mile High", 39.743889,-105.02),
NFLTeam ("browns", "Cleveland Browns", "browns.png", "AFC", "AFC North", "FirstEnergy Stadium", 41.506111,-81.699444),
@wremeika
wremeika / Magic8BallResponses.kt
Created September 1, 2024 15:04
Kotlin Magic 8 Ball Array
private val responseBank = listOf(
Response("It is certain"),
Response("It is decidedly so"),
Response("Without a doubt"),
Response("Yes, definitely"),
Response("You may rely on it"),
Response("As I see it, yes"),
Response("Most likely"),
Response("Outlook good"),
Response("Yes"),
@gmccoy
gmccoy / FileLocker.psm1
Created December 16, 2022 20:25
PowerShell module for controlling FileLocker
# PowerShell Module for uploading files to FileLocker
# Greg McCoy gmccoy@purdue.edu
# 15 May 2020
function Sign-In {
param(
[Parameter(Mandatory=$true)] [string]$Key,
[Parameter(Mandatory=$true)] [string]$User
)
@rpower
rpower / rowVersusColumnBenchmark.m
Created September 27, 2022 18:42
Row versus column benchmark
function [rowTime, colTime] = rowVersusColumnBenchmark(n, m)
massRatio = 0.012;
rng(10)
states = rand(n, 6);
tic()
for k = 1:m
pp = pseudopotentialRowStates(massRatio, states);
end
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.

Software Development Resources

Here is a list of stuff I routinely find useful.

Tools

  • Miller - command-line tool for querying, shaping, and reformatting data files in various formats including CSV, TSV, JSON, and JSON Lines.
  • Obsidian - Excellent tool for managing a plain flat file Markdown wiki knowledge base
  • ripgrep - Fast Rust replacement for grep