Skip to content

Instantly share code, notes, and snippets.

@uhjish
uhjish / install-Python-AmazonLinux-20171023.log
Created June 2, 2020 16:27 — forked from mrthomaskim/install-Python-AmazonLinux-20171023.log
Amazon Linux AMI, pyenv, virtualenv, Python, ... Hello, World!
### prerequisites
sudo yum groupinstall "Development Tools"
git --version
gcc --version
bash --version
python --version # (system)
sudo yum install -y openssl-devel readline-devel zlib-devel
sudo yum update
### install `pyenv`
--
-- GEOIP IN POSTGRESQL
--
-- We use two approaches. First using PostgreSQL inet and cidr types and indexing (PostgreSQL 9.4 and later),
-- and then using ip4r (https://github.com/RhodiumToad/ip4r).
-- The performance of ip4r indexes is significantly better than PostgreSQL's own index.
-- An operation that took 42s using ip4r took 47 minutes using PostgreSQL's cidr index.
--
@uhjish
uhjish / parse_mortality_data.py
Created August 29, 2017 08:13 — forked from SohierDane/parse_mortality_data.py
CDC Mortality Dataset Preparation 2005-2015
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
For each year, parse the pdf manual, then use that information to
unpack the fixed-width data file.
Source data files can be found here:
https://www.cdc.gov/nchs/data_access/vitalstatsonline.htm#Mortality_Multiple
Passes basic tests for 2005-2015. Untested on earlier years.
@uhjish
uhjish / README.md
Created January 25, 2017 17:30
performance monthly

README is empty

Keybase proof

I hereby claim:

  • I am uhjish on github.
  • I am ajish (https://keybase.io/ajish) on keybase.
  • I have a public key whose fingerprint is B9C6 4B2A 4CBD D39C 4869 7A5B 75A5 83AA 8FC4 63DE

To claim this, I am signing this object:

Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
<HPXML xmlns="http://hpxmlonline.com/2014/6" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" schemaVersion="2.1">
<XMLTransactionHeaderInformation>
<XMLType/>
<XMLGeneratedBy/>
<CreatedDateAndTime>2014-10-20T16:02:04</CreatedDateAndTime>
<Transaction>create</Transaction>
</XMLTransactionHeaderInformation>
<SoftwareInfo/>
<Building>
<BuildingID id="blg1"></BuildingID>