remove sticky job cache because DB is now fast enough to do it on load (thanks @daniellockyer) #remoteok

fix bug job not sticky because company bumped a sticky job from >12 months ago but the SQL that gets sticky for performance only checked <12 months ago jobs #remoteok

Change the algo so the Sticky job board get shuffled when caching gets flushed every hour #jobboardsearch

fix stuck queue jobs and prevent reoccurring #ctr

speed up #nomads load to 158ms WAIT

Increase job timeout #api

manage to figure out how to add sticky jobs into SQL query by doing ORDER BY max(coalesce(epoch,0),coalesce(epoch_bumped,0),(coalesce(is_sticky_day,0)+86400),(coalesce(is_sticky_week,0)+604800),(coalesce(is_sticky_month,0)+2592000))) so that we don’t need to “manually” add the sticky jobs on top with code but it just sorts it straight into db (86400 is 24h, 604800 is 7 days, 2592000 is 30 days etc.) #remoteok

Manage stuck active jobs in queue and add concurrency.

add cache bust to job previews to avoid confusing employers #japandev

#untalent Avoid duplicate jobs

drop old jobs tables #betalist

make #remoteok 70ms WAIT page load time (by @daniellockyer)

add cache to Remote OK jobs box on #nomads because it adds 18ms to the load time

Investigate delayed job hang issue #auto

fix bug sticky jobs bumped didn’t show up as sticky due to SQL typo #remoteok

fix sticky job post if bumped didn’t become sticky #remoteok

auto flush queue of failed jobs older than 15min #interiorai

auto flush queue of failed jobs older than 15min #photoai

improve algo on #jasp to sort jobs

#rockkick refactor commands to be executed via jobs and configure timeout periods