jonny,
@jonny@neuromatch.social avatar

Ok I think I have figured out filtering duplicate boosts from public timelines on #glitchsoc. 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

jonny,
@jonny@neuromatch.social avatar

Someone come and tell me I did this wrong: https://github.com/NeuromatchAcademy/mastodon/pull/36/files

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