A few random topics about PostgreSQL. I cover indexing columns, adding constraints, and the JSON datatype. A document with the information is at https://goo.gl/GVN2Tx.
This is part of the playlist https://www.youtube.com/playlist?list... which contains a set of videos intended as a tutorial to help people learn how to write database driven web apps using Flask, PostgreSQL, and the psycopg2 adapter. It uses the free cloud9 web-based IDE.