Skip to content

Instantly share code, notes, and snippets.

View pamelafox's full-sized avatar

Pamela Fox pamelafox

View GitHub Profile
@pamelafox
pamelafox / pokemon.sql
Created March 20, 2020 16:51
Pokemon statistics
CREATE TABLE pokemon(
Number INTEGER,
Name TEXT PRIMARY KEY,
Type_1 TEXT,
Type_2 TEXT,
Total INTEGER,
HP INTEGER,
Attack INTEGER,
Defense INTEGER,
Sp_Atk INTEGER,
@pamelafox
pamelafox / superbowls.sql
Created March 20, 2020 16:40
Superbowls 1967-2020 (Winners and losers of all Superbowl finals)
CREATE TABLE superbowls(
Date TEXT PRIMARY KEY,
SB TEXT,
Winner TEXT,
Winner_Pts INTEGER,
Loser TEXT,
Loser_Pts INTEGER,
MVP TEXT,
Stadium TEXT,
City TEXT,
@pamelafox
pamelafox / additional_symbols.go
Created October 14, 2019 17:40
Additional symbols
{50, "L"},
{40, "XL"},
@pamelafox
pamelafox / hosts
Created July 23, 2018 15:04
etc/hosts for news blocking
### News Aggregators
127.0.0.1 redditate.com
127.0.0.1 news.google.com
127.0.0.1 news.yahoo.com
127.0.0.1 news.ycombinator.com
### News
127.0.0.1 cnn.com
127.0.0.1 recode.net
127.0.0.1 techcrunch.com
127.0.0.1 mashable.com
@pamelafox
pamelafox / scraper_pickup.py
Last active August 31, 2020 11:23
Scrapers
from bs4 import BeautifulSoup
import requests
import string
def save_to_file(filename, sayings):
file = open(filename, "w")
file.write("\n".join(sayings).encode("utf-8"))
file.close()
@pamelafox
pamelafox / GlowingSun.java
Created May 18, 2018 17:09
GlowingSun Processing Program
void setup() {
size(640, 360);
}
void draw() {
background(135, 206, 235);
noStroke();
@pamelafox
pamelafox / GrassyField.java
Created May 18, 2018 17:08
GrassyField Processing Program
void setup() {
size(640, 360);
}
void draw() {
colorMode(HSB);
// Draw blue sky
background(134, 74, 255);
// See documentation @ https://processing.org/reference/noise_.html
float noiseScale = 0.02;
void setup() {
size(640, 360);
}
void draw() {
background(0);
@pamelafox
pamelafox / RainDrop.java
Created May 18, 2018 17:07
RainStormSystem Processing Program
// A simple Particle class
class RainDrop {
int x;
int y;
RainDrop(int startX, int startY) {
this.x = startX;
this.y = startY;
}
@pamelafox
pamelafox / playerscores.sql
Created May 16, 2018 20:41
playerscores.sql
CREATE TABLE IF NOT EXISTS playerscores (player TEXT, score INTEGER);
INSERT INTO playerscores VALUES ("Miss P", 34);
INSERT INTO playerscores VALUES ("Mr H", 99);
INSERT INTO playerscores VALUES ("Miss Piggy", 10);
SELECT * FROM playerscores ORDER BY score DESC LIMIT 10;