SQLite3 Cheat Sheet
Download from: http://www.sqlite.org/download.html Getting Started: http://www.sqlite.org/sqlite.html Documentation: http://www.sqlite.org/docs.html
Joseph Friedrich ch7ck
ch7ck
/ sqlite3-cheat-sheet.md
Last active
August 29, 2015 14:21
— forked from vincent178/sqlite3-cheat-sheet.md
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| US_states = { | |
| 'AK': 'Alaska', | |
| 'AL': 'Alabama', | |
| 'AR': 'Arkansas', | |
| 'AS': 'American Samoa', | |
| 'AZ': 'Arizona', | |
| 'CA': 'California', | |
| 'CO': 'Colorado', | |
| 'CT': 'Connecticut', | |
| 'DC': 'District of Columbia', |
ch7ck
/ keybase.md
Created
September 5, 2016 01:28
I hereby claim:
- I am ch7ck on github.
- I am j0elog (https://keybase.io/j0elog) on keybase.
- I have a public key whose fingerprint is 25D5 843D C798 EBC4 07FB 3402 E5D6 ECAC B9D4 D11E
To claim this, I am signing this object:
ch7ck
/ US Zip Codes from 2013 Government Data
Created
November 9, 2016 18:02
— forked from erichurst/US Zip Codes from 2013 Government Data
All US zip codes with their corresponding latitude and longitude coordinates. Comma delimited for your database goodness. Source: http://www.census.gov/geo/maps-data/data/gazetteer.html
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ZIP,LAT,LNG | |
| 00601,18.180555, -66.749961 | |
| 00602,18.361945, -67.175597 | |
| 00603,18.455183, -67.119887 | |
| 00606,18.158345, -66.932911 | |
| 00610,18.295366, -67.125135 | |
| 00612,18.402253, -66.711397 | |
| 00616,18.420412, -66.671979 | |
| 00617,18.445147, -66.559696 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/python | |
| #TODO | |
| import requests | |
| from bs4 import BeautifulSoup | |
| r = requests.get('http://news.ycombinator.com') | |
| soup = BeautifulSoup(r.text, 'lxml') |
ch7ck
/ whiteboardCleaner.md
Created
June 3, 2019 19:44
— forked from lelandbatey/whiteboardCleaner.md
Whiteboard Picture Cleaner - Shell one-liner/script to clean up and beautify photos of whiteboards!
This simple script will take a picture of a whiteboard and use parts of the ImageMagick library with sane defaults to clean it up tremendously.
The script is here:
#!/bin/bash
convert "$1" -morphology Convolve DoG:15,100,0 -negate -normalize -blur 0x1 -channel RBG -level 60%,91%,0.1 "$2"
ch7ck
/ keybase.md
Created
December 30, 2019 18:37
I hereby claim:
- I am ch7ck on github.
- I am j0elog (https://keybase.io/j0elog) on keybase.
- I have a public key whose fingerprint is 25D5 843D C798 EBC4 07FB 3402 E5D6 ECAC B9D4 D11E
To claim this, I am signing this object: