updating pseudocode
changing boilerplate database from sqlite3 to postgresql