Back
Hoodmaps

Hoodmaps

#hoodmaps

If Google Maps and Urban Dictionary had a love child
Load previous page…
make cron worker that processes queue hourly and inserts into db #hoodmaps
See similar todos

No replies yet

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
See similar todos

No replies yet

draw Ko Samui GeoJSON vectors of rough neighborhoods #hoodmaps
See similar todos

No replies yet

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

No replies yet

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

No replies yet

add monitor for #hoodmaps root page
See similar todos

No replies yet

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

No replies yet

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
See similar todos

No replies yet

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

No replies yet

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
See similar todos

No replies yet

add box-shadow to tag textbox #hoodmaps
See similar todos

No replies yet

make daily database vacuum cleaner for #hoodmaps
See similar todos

No replies yet

add new border and box-shadow to #hoodmaps
See similar todos

No replies yet

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

No replies yet

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

No replies yet

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

No replies yet

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

No replies yet

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
See similar todos

No replies yet

fix 100vh issue on #hoodmaps mobile cutting of site in bottom
See similar todos

No replies yet

fix places didn’t show because it tried to send event to Google Analytics but we don’t use that anymore #hoodmaps
See similar todos

No replies yet