Back
Startup Jobs
Startup Jobs
#startupjobs
All startup jobs in one place
Launched September 12, 2018
Load previous page…
Learn about offset versus seek in pagination and "SQL Row Values" 
#startupjobs use-the-index-luke.com/sql/pa…
Replace Twitter gem with custom code because the gem was not being updated and it prevented me from upgrading certain dependencies like http.rb #startupjobs
Serve company logos through static URL like startup.jobs/logos/700 (where 700 is the company ID) so it's more easily cacheable and I don't need to re-index Algolia whenever a logo changes #startupjobs
Simplify and speed up almost every single database query by moving the visibility filtering logic (hide expired posts, hide all posts from hidden companies, etc) into a cached boolean column (`active`) that's updated hourly #startupjobs
Switch from $200/mo Google Places API Autocomplete to $0/mo custom places autocomplete widget #startupjobs
Disable Skylight because I pay about $250/mo for it just for #startupjobs and I only occasionally check it
Stop setting cookies when people GET an image upload, because it's unnecessary and prevents Cloudflare from caching the images #startupjobs
