fix #hoodmaps problem of server being strained from people moving the map to random spots that can’t be cached because they’re random {Lat,Lng} coords /done fix #hoodmaps problem of server being strained from people moving the map to random spots that can’t be cached because they’re random {Lat,Lng} coords, instead use maxBounds to limit user staying one place (lat-0.25,lng-0.25,lat+0.25,lng+0.25), and let user use search box instead as it offloads strain from the server so that instead city centers are loaded (which can be cached statically instead of random coords) so that Hoodmaps becomes 100% static (cc @daniellockyer)

add index latitude_longitude_decimals on hoodmaps_processed.db to speed it up #hoodmaps

set hoodmaps.db to WAL #hoodmaps

set hoodmaps_processed.db to WAL #hoodmaps to fix load issues

make prototype of lat,lng static JSON cache for #hoodmaps which will have every coordinate from -90 to 90, -180 to 180 as .json file so that it doesn’t hit the server when you move the map

add racist words list for #hoodmaps in French

get #hoodmaps working on local dev M1X

fade out snow after 5 seconds to not annoy users #hoodmaps

download #hoodmaps db to get local hoodmaps working on M1X

verify that high zoom drawings work again #hoodmaps

add details to #hoodmaps log.php and LIMIT 1 so it loads faster when Uptimerobot and @ronaldl93 open it

when processing #hoodmaps db queue backup the queue before flushing it so we can reverse it in case worker fails due to DB locks for ex #hoodmaps (thx @ronaldl93)

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