improve progress visualization #hoodmaps worker so I see what’s going on

add latitude_longitude index to speed up #hoodmaps

set PHP memory limit for #hoodmaps averageCoordinatesDaily.php worker to 10GB to avoid fatalling

remove all font-weights loaded of Nunito except 400 and 800 because who needs the rest #hoodmaps

fix #hoodmaps PHP notices due to changed error log code

get on some Turkish YouTube channel with #hoodmaps www.youtube.com/watch?v=M8hEp…

disable #hoodmaps drawings because viral in Copenhagen

move API keys and environment variables PHP config file to private folder outside of web path #hoodmaps

make cron worker that processes queue hourly and inserts into db #hoodmaps

replace direct SQLite INSERTs of drawings via AJAX on #hoodmaps with saving to a text file buffer in /data/hoodmaps.db.queue.txt which we then pull with a cron job @hourly to avoid DB locked problems when too many people write at same time

draw Ko Samui GeoJSON vectors of rough neighborhoods #hoodmaps

change #hoodmaps front page generation to every at 15 minutes instead of every minute

add try {} catch(PDOException $e) around #hoodmaps insert tag and insert draw data to catch UNIQUE CONSTRAINT race condition instead of fatally erroring

add monitor for #hoodmaps root page

add rate limiter to #hoodmaps to avoid too many tags or drawings by single user

replace hoodmaps REPLACE INTO with INSERT and a check before if the data with {uid} already exists because REPLACE INTO is slow and times out on SQLite in giant dbs #hoodmaps

try reproduce Android bug #hoodmaps but cannot reproduce on emulator (via @heyrobinkunz)

try fix SQLite problems #hoodmaps by replacing REPLACE INTO on giant db with INSERT INTO and a check before to see if the tag with {uid} exists already

add box-shadow to tag textbox #hoodmaps

make daily database vacuum cleaner for #hoodmaps