Karen Cranston kcranston

I hereby claim:

To claim this, I am signing this object:

Document stores in PostgreSQL

Notes for software engineering meeting presentation

mid to late 2000s: appearance of Document stores / NoSQL databases such as Mongo, Couch
Relational DBs now have support for document data: JSON in MySQL, JSON and JSONB in PostgreSQL
Focus on JSONB in Postgres (most full featured)

	import requests

	client_id = "Iv1.8df72ad9560c774c"
	header = {"Content-Type": "application/json", "Accept": "application/json"}

	# Step 1
	payload1 = {"client_id": client_id,}
	r = requests.post(
	'https://github.com/login/device/code',headers=header,json=payload1
	)

	import codecs
	import csv
	import peyotl.ott as ott

	ott_loc = "path-to-ott"
	taxonomy = ott.OTT(ott_loc)
	ott_names = taxonomy.ott_id_to_names
	ott_parents = taxonomy.ott_id2par_ott_id

	ott_filename = "ott.csv"