Skip to content

Instantly share code, notes, and snippets.

@pushcx

pushcx/outrages.sql

Created February 28, 2024 18:36
Show Gist options
  • Save pushcx/4256f12afcec3ba271102693e2225671 to your computer and use it in GitHub Desktop.
Save pushcx/4256f12afcec3ba271102693e2225671 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
outrages.sql
MariaDB [lobsters]> select short_id, title, reason from stories s join moderations m on s.id = m.story_id where m.comment_id is null and s.is_moderated = true and (m.reason like '% torch %' or m.reason like '% customer %');
+----------+---------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+
| short_id | title | reason |
+----------+---------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+
| xoi5nv | Netlify Billing Request: Extra Bandwidth Allowances · | Lobsters is not customer support for Netlify. |
| xh1qp4 | PSA: Download Your Twitter Archive | Removing rant on business practices. Take it up with their customer support. |
| rfyx59 | After 3 Years of Work, Chrome Killed My Extension and Won’t Tell Me Why | Lobsters is not backup customer support for tech companies. |
| hwh1nb | Sign The Petition For Windows To Ship With Colemak | Lobsters is not the last resort for customer support. |
| 59cbni | Who do I have to kill to get access to GPT-3? | Lobsters is not a place for last-ditch customer support via public shaming, take this elsewhere. |
| 4xxruq | Google DNS doesn't resolve privacytools.io | Lobsters is not a Google customer support forum. |
| 4tlzuh | Problems with using mbasic.facebook.com? | Lobsters is not last-ditch customer support. |
| xsy3cu | Reddit removed my permissions from my own legal, non-abusive community | Lobsters is not a venue for customer service for Reddit. |
| 4gh6op | My Latest Brush with the Corporate Internet: GitHub has My Stolen Code | Lobsters is not the customer support ticketing system for GitHub. Or the torch and pitchfork depo. |
| xvzla6 | 1621570 - browser.urlbar.clickSelectsAll=false has no effect since 75b1 | Lobsters is not customer support for Firefox. Or the torch and pitchfork store. |
| wyrghe | What happens when your domain registrar closes down business and goes bankrupt | Lobsters is not customer support for your registrar. |
| aipygj | Cause of odd ligature behavior in Android username entry? | Lobsters is not Android customer support. |
| ap3psh | RFC Sustainability of Mitogen project · Issue #773 · dw/mitogen | Lobsters is not the torch and pitchfork outlet store. |
| 2apk2z | Facebook is chipping away at privacy – and my profile has been exposed (2016) | Lobsters is not customer support for Facebook. |
| m2eeok | Google Maps Gets Worse with Every Release | Lobsters is not customer support for Google Maps. |
| xojjb2 | On The Toxicity of Zed A. Shaw (with Bonus 0days) | Lobsters is not the torch and pitchfork outlet store. |
| vso7r2 | RMS Open Letter | Lobsters is not the torch and pitchfork store. |
| 47pt88 | Firefox bug: #1693815 - Remove illustrations on error pages | Lobsters is not the torch and pitchfork outlet. |
| oskwu4 | PSA: today Cloudflare Bot Fight mode broke my blackbox Prometheus monitoring | Lobsters is not customer support for Cloudflare or any other service. |
| aivt9e | Mathematics Beyond Secrecy and Surveillance | Lobsters is not the torch and pitchfork outlet store. |
| vj3yai | Basic telemetry for the Audacity by crsib · Pull Request #835 · audacity/audacity | Lobsters is not the torch and pitchfork store. |
| h36laj | Audacity: New privacy policy is completely unacceptable! · Issue #1213 · audacity/audacity | Lobsters is not the torch and pitchfork store. |
| wm1yoc | An Open Letter Calling for the Resignation of Eugen Rochko (Gargron) from Mastodon Development | Lobsters is not the torch and pitchfork outlet store. |
| mlacdx | Apple is trying to redefine what it means to violate your privacy. We must not let it | We beat this story to death last week, and Lobsters is not the torch and pitchfork store. |
| o5ksp5 | An ideal DX for Rust on AWS Lambda? | Lobsters is not customer support for AWS. |
| ppdqf7 | Is Mozilla Firefox Getting Sketchy? | Lobsters is not the torch and pitchfork store. |
| zfxh1s | Strong HEY opinions, weakly held | Lobsters is not customer support for Basecamp, who are the best people to discuss your issues with. |
| r5t1z2 | Can we trust Microsoft with Open Source? | Lobsters is not the torch and pitchfork store. |
| djfsb9 | ProctorU is dystopian spyware | Lobsters is not customer support for ProctorU. |
| mv8pko | Tailwind CSS watch mode makes the M1 CPU panic | Lobsters is not Apple customer support. |
| y8r1gv | LastPass master passwords may have been compromised | Lobsters is not customer support for LastPass. |
| 4qnns1 | Merchant Service Horror: Amazon Pay and the Disappearing $2300 | Lobsters is not customer support for Amazon. |
| ey3fgy | Microsoft – incompetent or malicious? | Lobsters is not customer support for Microsoft. |
| 0rvbp2 | Non-consensual personalization | Lobsters is not customer support for Netflix. |
| 3hduqf | SPAM blacklisting is out of control | Lobsters is not customer support for some random spam blacklist. And indicting the entire idea over one random list is not even a useful rant. |
| ihjvmb | I have no capslock and I must scream | Lobsters is not for last-ditch customer support via public shaming, even cleverly written. |
| zycxsq | The ever-increasing walled-gardeness of Twitter | Lobsters is not customer support for Twitter. |
| fnorwo | GitHub can't be trusted | Lobsters is not customer support for GitHub. |
| keoxso | Dutch digital identity system crisis | Lobsters is not customer support for the Dutch government. |
| cytoxw | Stack Overflow Developer Story experience | Lobsters is not customer support for Stack Overflow. |
| 0vpw6m | Hacker News is down again | Lobsters is not customer support for Hacker News. |
| abfvbb | Initial commit · azure-rtos/guix@824be64 | I don't even know what drama you're trying to drag us into, but Lobsters is not the torch and pitchfork outlet. |
| rztkb1 | Can you rely on Google Cloud Platform? | Lobsters is not customer support for Google Cloud. |
| qgsqtn | VSCode ticket: Require user consent before sending any telemetry | Lobsters is not the torch and pitchfork outlet store, and we already beat this one to death when it happened. |
| 1woe5y | Disturbing facts about ProtonMail (2021) | Lobsters is not customer support for ProtonMail or the CIA. |
| g8xkud | When “free forever” means “free for the next 4 months” | Lobsters is not customer support for Mattermost. |
| esb6gw | Discord Should Remove Usernames Entirely | Lobsters is not customer support for Discord. |
| o6birb | Way to radically improve security of sudo: make a daemon instead of setuid binary | Lobsters is not the torch and pitchfork store. |
| kb70jw | Dear Stack Overflow, Inc | Lobsters is not the torch and pitchfork store. |
| pojjt7 | Stack Exchange moderators are going on strike | Lobsters is not the torch and pitchfork store. |
| di6yo6 | The Need for User-Controlled Content Filtering on YouTube | Lobsters is not customer support for Youtube. |
| cdg2gy | Facebook's Fake Followers | Lobsters is not customer support for Facebook. |
| 3ixf2x | iOS Copy Paste phone from contacts to UITextField adds text direction-forcing unicode characters | Lobsters is not customer support for iOS. |
| jxunz8 | Several InfluxDB Cloud customers lost data in hasty region shutdown | Lobste.rs is not a customer support venue for Influxdata. |
| qpi41u | User banned from GitHub by mistake; consequences & correction | Lobsters is not customer support for GitHub. |
| mocuvp | Mozilla wants its documentation to gaslight you | Lobsters is not the torch and pitchfork store. |
| iwmlgx | Not Using Zoom | Lobsters is not customer support for Zoom. |
| hipwd8 | Bethesda's Starfield is a disgrace to game development and a slap in the face to gamers | Lobsters is not customer support for Bethesda. |
| xjx6nf | Silicon Valley lied to me | Lobsters is not customer support for Silicon Valley. |
| kcmszq | I'm banned for life from advertising on Meta. Because I teach Python | Lobsters is not customer support for Facebook. |
| holkgj | Not Everything Is Google’s Fault (Just Many Things) | Lobsters is not customer support for Google Cloud. |
| midrrh | njal.la suspended nitter.net domain over false claims of nitter.net hosting non-consensual nudity | Lobsters is not customer support for Njalla. |
| efhrg7 | If you don't own the product, the product owns you | Lobsters is not customer support for Skiff. |
| qahwtg | ChatGPT has gone berserk | Lobsters is not customer support for ChatGPT. |
| hvddrv | Netlify just sent me a $104K bill for a simple static site | Lobsters is not customer support for Netlify. (HN is, apparently, the CEO responded there.) |
| qcx6fi | The Tech Industry Doesn’t Understand Consent - Opt-Out Is Not Consent | Lobsters is not customer support for Automattic. |
+----------+---------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------+
Raw
undeleted.sql
MariaDB [lobsters]> select short_id, title, reason from stories s join moderations m on s.id = m.story_id where m.comment_id is null and s.is_moderated = true and action like '%undelete%';
+----------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------+
| short_id | title | reason |
+----------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------+
| dhmbsl | 300 Days Away From Programming | NULL |
| a7kjwk | Linux Random Number Generator – A New Approach | |
| dhdh6b | Chrome 56 Will Aggressively Throttle Background Tabs | Duplicate, as pointed out by several people |
| pbbsjm | 'Snoopers' charter' changes put forward | Merging into resubmission. |
| iokvng | Victims, Victims Everywhere: Trigger Warnings, Safe Spaces, and Academic Freedoms | NULL |
| op4nas | Google accused of sabotaging Firefox, again | Merging dupe. |
| 4t8ycc | Overestimating and Magical Thinking | NULL |
| qgea33 | Explaining iOS' SecureROM boot chain | NULL |
| 57nh4a | The 40% keyboard | NULL |
| 4onokj | BashoJS: JavaScript Evaluator for Shell Scripts | Clicked the wrong button when removing the smaty, sorry. |
| b4nqte | Deno 1.4 Release Notes | NULL |
| jdshxc | Cameras and Lenses | NULL |
| nsgefd | A hole in Clang’s -Wsuggest-override | NULL |
| st6w2t | Explanation of IP networking with BGP fundamentals | NULL |
| l64zhd | Just managed to log into Lobsters from SerenityOS | Some dude scolded me https://twitter.com/jcs/status/1499760976538869767 |
| udzsaa | Formal Methods at Microsoft | …wrong button on that last edit, sorry. |
| 7m8dnu | How a German Soda Became Hackers' Fuel of Choice | Conversation in #lobsters leads me to believe I do not need to be the no fun police this time. |
| n1khrf | Data transmission over mud | Undeleting for meta discussion in comments. |
| smnu99 | Windows at 1,000 Frames Per Second | Wrong button, sorry, just meant to edit rather than remove. |
+----------+-----------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------+
19 rows in set (0.028 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment