That took me too long :)

Whenever something big happened in the news and I wanted to see the video or images directly, uncensored, real as they are, LiveLeak was The Place To Go.

Outside the Big Tech bubble.

Not sure what alternatives there are, if any.

It certainly was at one point, but near the end it definitely wasn't. Whether it was soft censorship, hard censorship, or a declining user base, I struggled to find videos I could sometimes even find on Twitter or Youtube. Videos whose place was obviously LiveLeak, based on their standards from 5 years ago.

As much as I lament the death of LiveLeak, it died well before today.

Well for police shootings at least, PoliceActivity on youtube is the place to go for uncensored, no-commentary bodycam video.

These two websites are not related.

Any plans for gevent compatibility?

Great! We're looking for a replacement for bravado. Thanks for this awesome project.

Thank you for the kind words!

Please keep in mind that it is still quite a new project (less than two years old); any issue reports and comments are more than welcome! :)

Have you heard of Uber Cadence, or Temporal.io?

And at the top of the article about Lee, is a suggestion to download Audm. Makes sense, still - kind of sent a chill down my back.

How does json_agg solve the n+1 problem?

It can eagerload more complex queries.

If you are eagerloading multiple joins relationships, normally that would create a result set of n x m x k x ... rows. With json_agg each relation could be single column in a row etc.

In this case the row size can become huge. Also, how to make sure it's consistent? (I mean foreign keys/unique indexes/etc)

i was mostly talking about reading side, not mutation side.

After a positive result is returned for a URL, a verification is done with Google's servers to see the positive is not a false positive.

Very cool, uncovering game development history via the source code.

Thanks for this!