@tobi This is like, at worst, only the fifth most cursed thing I have been doing to my database today

@tobi My new task queue query has 6 CTEs

@joepie91 I'm not sure what that could mean apart from cwick-time event, I wish you the best of luck in pressing the buttons at the right time!

@tobi Heh :p CTEs are like sub-expressions, so now my query looks something like this: https://gist.github.com/joepie91/6a2e2c585c3864f2bf660840cd6f9356

@joepie91 oof, jesus!

@tobi The old version of this query is actually worse (and, apparently, broken): https://git.cryto.net/joepie91/srap/src/branch/master/src/database-backends/postgresql/queries/get-task-stream.js#L22

@tobi Old one is also easily 5x as slow

@joepie91 @tobi good lord

@kim @tobi This is that query I was tooting about earlier about spending 4 full days on it

@kim @tobi It also like, implements 10% of the functionality of the entire application, lmao

@joepie91 @tobi that's... impressive!

@randolph Heh, not particularly likely in this case :) This is to make a query in a codebase/library work!