Hoodmaps

verify that high zoom drawings work again

2021-12-14 11:02:13 UTC

levelsio

add details to

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

2021-11-09 09:33:27 UTC

levelsio

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)

2021-11-09 09:00:35 UTC

levelsio

improve progress visualization

#hoodmaps worker so I see what’s going on

2021-11-09 08:48:34 UTC

levelsio

add latitude_longitude index to speed up

2021-11-09 08:38:36 UTC

levelsio

set PHP memory limit for

#hoodmaps averageCoordinatesDaily.php worker to 10GB to avoid fatalling

2021-11-09 08:18:25 UTC

levelsio

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

2021-10-26 09:28:42 UTC

levelsio

fix

#hoodmaps PHP notices due to changed error log code

2021-10-02 09:04:06 UTC

levelsio

#hoodmaps www.youtube.com/watch?v=M8hEp…

get on some Turkish YouTube channel with

2021-10-01 12:39:28 UTC

levelsio

disable

#hoodmaps drawings because viral in Copenhagen

2021-09-25 16:34:59 UTC

levelsio

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

2021-09-04 18:58:00 UTC

levelsio

make cron worker that processes queue hourly and inserts into db

2021-08-11 16:36:32 UTC

levelsio

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

2021-08-11 16:06:23 UTC

levelsio

draw Ko Samui GeoJSON vectors of rough neighborhoods

2021-08-08 09:17:50 UTC

levelsio

change

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

2021-06-26 15:15:58 UTC

levelsio

add try {} catch(PDOException $e) around

#hoodmaps insert tag and insert draw data to catch UNIQUE CONSTRAINT race condition instead of fatally erroring

2021-06-19 15:04:10 UTC

levelsio

add monitor for

#hoodmaps root page

2021-06-19 09:29:46 UTC

levelsio

add rate limiter to

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

2021-06-17 13:25:59 UTC

levelsio

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