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

add new border and box-shadow to #hoodmaps

fix #hoodmaps 503 errors w/ @daniellockyer it turned out to be the rate limiter not the SQLite db

try debug #hoodmaps I/O SQLite errors with @daniellockyer and VACUUM hoodmaps.db to see if it solves it

dump #hoodmaps db to .SQL file from SQLite to import into PostgreSQL

install PostgreSQL to migrate #hoodmaps from SQLite because we’ve reached its limits I think

add Cloudflare Edge Cache with 7 day TTL to #hoodmaps get_data API endpoint because it was 503’ing due to the SQLite db being too big sometimes so this is a quick band aid fix