jonny,
@jonny@neuromatch.social avatar

Ok I think I have figured out filtering duplicate boosts from public timelines on . Sort of hard because I have no intuition for order of operations in postgres in subqueries, but I think it should work and only adds 1ms to one of the queries bc of the magic of window functions and snowflake ids

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • slotface
  • kavyap
  • thenastyranch
  • everett
  • tacticalgear
  • rosin
  • Durango
  • DreamBathrooms
  • mdbf
  • magazineikmin
  • InstantRegret
  • Youngstown
  • khanakhh
  • ethstaker
  • JUstTest
  • ngwrru68w68
  • cisconetworking
  • modclub
  • tester
  • osvaldo12
  • cubers
  • GTA5RPClips
  • normalnudes
  • Leos
  • provamag3
  • anitta
  • megavids
  • lostlight
  • All magazines