Tianyi LiA quick note on solving client connection error of psqlI got the Client Connection Problems with my local PostgreSQL server, and couldn’t figure why how that happens — I wake up to find out my…Mar 25, 2019Mar 25, 2019
Tianyi LiinACM CSCWCrowdIA: Solving Mysteries with Crowdsourced SensemakingEvents such as the September 11th, 2001 terrorist attacks and the miscall on weapons of mass destruction in Iraq — “the two major U.S…Nov 16, 2018Nov 16, 2018
Tianyi LiHow to detect if a crowd worker has returned an assignment of your HIT on MTurkWhen using your own web app to deploy HITs via MTurk API (ExternalQuestion), it’s important sometimes to detect the status of HIT…Mar 16, 2018Mar 16, 2018
Tianyi LiChange Primary Key in PostgreSQL Tables via Django API (used as Foreign Key by other tables)MTurk assignment ID is not always unique. When a worker return a HIT, the next worker taking it will have the same assignment ID.Oct 29, 2016Oct 29, 2016