Skip to content

Instantly share code, notes, and snippets.

View erickguan's full-sized avatar

Erick Guan erickguan

View GitHub Profile
./2018basic/bin/x86_64-darwin/tlmgr list --only-installed | cut -d ' ' -f2 | cut -d ':' -f1 | sudo tee installed_texlive_packages.txt
_ tlmgr install $(cat installed_texlive_packages.txt)
TsvHttpData-1.0
https://dumps.wikimedia.org/wikidatawiki/entities/20190429/wikidata-20190429-all.json.bz2 37397047855 253e8dfca9928c6af8bbd654bfa21745
@erickguan
erickguan / example_buffer.c
Created March 25, 2019 19:37
An example C buffer implementation
int convert_blank_to_quote(const char* source, char* dest, int64_t buffer_size)
{
--buffer_size; // the last character would be '\0'
if (buffer_size <= 0) {
return -1; // illegal argument: buffer size too small
}
int64_t i = 0;
for (const char* p = source; *p != '\0' && i < buffer_size; ++p, ++i) {
*(dest + i) = p == ' ' ? '@' : *p;
@erickguan
erickguan / # postgresql - 2019-01-17_22-22-22.txt
Created January 17, 2019 21:51
postgresql on macOS 10.14.2 - Homebrew build logs
Homebrew build logs for postgresql on macOS 10.14.2
Build date: 2019-01-17 22:22:22
@erickguan
erickguan / cbdb-poets-import.py
Last active January 24, 2018 11:16
Import parts of CBDB into wikidata.
#%%
from datetime import date
from sqlalchemy import create_engine
import pywikibot
from pprint import pprint
from operator import is_not
from functools import partial
from concurrent.futures import ThreadPoolExecutor
from SPARQLWrapper import SPARQLWrapper, JSON
import sys
@erickguan
erickguan / Pipfile
Created December 11, 2017 10:39
Simple SPARQL query on DBpedia and Wikidata
[[source]]
url = "https://pypi.python.org/simple"
verify_ssl = true
name = "pypi"
[dev-packages]
ipykernel = "*"
@erickguan
erickguan / info.sql
Created November 28, 2017 20:07
WAM2017 stat. Loaded to PostgreSQL by pgloader
-- 20 global top users (40 fetched)
SELECT
a.User AS username,
COUNT(a.NAME) AS articleCount,
e.Code AS editathonCode,
e.Description AS ediathonDescription
FROM
fountain.article a
LEFT JOIN fountain.editathon e ON a.EditathonId = e.Id
WHERE (LOWER(e.Code)
#ifndef RANG_DOT_HPP
#define RANG_DOT_HPP
#if defined(__unix__) || defined(__unix) || defined(__linux__)
#define OS_LINUX
#elif defined(WIN32) || defined(_WIN32) || defined(_WIN64)
#define OS_WIN
#elif defined(__APPLE__) || defined(__MACH__)
#define OS_MAC
#else
@erickguan
erickguan / keybase.md
Created September 4, 2017 19:36
Keybase Signature

Keybase proof

I hereby claim:

  • I am fantasticfears on github.
  • I am fantasticfears (https://keybase.io/fantasticfears) on keybase.
  • I have a public key whose fingerprint is 93FA 3555 6212 7E0E 483A 2714 1007 5E9E 7640 7351

To claim this, I am signing this object:

@erickguan
erickguan / 2015_PRC_natural_reserves.csv
Created May 21, 2017 17:09
2015 CSV exports from P.R.C. national natural reserves via Tabula. PDF from: http://sts.mep.gov.cn/zrbhq/zrbhq/201611/P020161125559865886359.pdf
序号 保护区名称 行政区域 面积 主要保护对象 类型 级别 始建时间 主管部
京01 百花山 北京市门头沟区 21743.1 温带次生林 森林生态 国家级 19850401 林业
京02 拒马河 北京市房山区 1125 大鲵等水生野生动物 野生动物 省级 19961121 农业
京03 蒲洼 北京市房山区 5396.5 森林生态系统 森林生态 省级 20050404 林业
京04 石花洞 北京市房山区 3650 岩溶洞穴 地质遗迹 省级 20001226 国土
京05 汉石桥湿地 北京市顺义区 1615 湿地生态系统及野生动植物 内陆湿地 省级 20050404 林业
京06 怀沙河、怀九河 北京市怀柔区 111 大鲵、中华九刺鱼、鸳鸯等野生动物 野生动物 省级 19961121 农业
京07 喇叭沟门 北京市怀柔区 18482.5 森林生态系统 森林生态 省级 19991213 林业
京08 四座楼 北京市平谷区 19997 森林生态系统 森林生态 省级 20021229 林业
京09 密云雾灵山 密云县 4152.4 森林生态系统及金钱豹等珍稀动植物 森林生态 省级 20001226 林业