Skip to content

Instantly share code, notes, and snippets.

@pushcx

pushcx/mostcomments.sql

Created September 5, 2024 19:30
Show Gist options
  • Save pushcx/3a6679608fd3fc3c5e525b6922771cc8 to your computer and use it in GitHub Desktop.
Save pushcx/3a6679608fd3fc3c5e525b6922771cc8 to your computer and use it in GitHub Desktop.
Download ZIP
most comments
Raw
mostcomments.sql
MariaDB [lobsters]> SELECT short_id, title, comments_count FROM stories ORDER BY comments_count DESC LIMIT 100;
+----------+-----------------------------------------------------------------------------------------------------------------+----------------+
| short_id | title | comments_count |
+----------+-----------------------------------------------------------------------------------------------------------------+----------------+
| h9xgpv | Rate my Homepage | 496 |
| uihyvs | backdoor in upstream xz/liblzma leading to ssh server compromise | 306 |
| zp4ofg | Lobster burntsushi has left the site, algorithm detecting standing might be off | 280 |
| 8aiw6g | What software do you dream about, but do not have time to do yourself? | 263 |
| zwrts3 | Microsoft is building a Chromium-powered web browser for Windows 10 | 229 |
| b7lt29 | Show your personal websites | 226 |
| 46pt2l | Retiring from the Rust for Linux project | 225 |
| v4crap | Crustaceans, 2021 will be the year of ${TECHNOLOGY} | 207 |
| yxj6cd | Remove Richard Stallman | 207 |
| 2cw6ov | Say something you dislike about a language you love | 203 |
| nf3xgg | I am leaving LLVM | 201 |
| wvi9xw | why not matrix? | 201 |
| ii7fpk | We need more of Richard Stallman, not less | 197 |
| v9rktg | New users, ethics, civility, threads, and you | 197 |
| bu3ynt | What's your distro, and how did you pick it? | 184 |
| 5qcvuz | Upcoming Git changes the default of init.defaultBranch to main | 183 |
| 3a4zga | Do you have any programming "white whales"? | 180 |
| ggsv7x | What keyboard do you use? | 177 |
| sdum3p | If you could rewrite anything from scratch, what would it be? | 176 |
| k5zn3j | Where are you from, fellow lobsters? | 169 |
| addjas | While we Blink, we lose the Web | 167 |
| a3zlgq | What software do you dream about, but do not have time to code yourself? | 167 |
| 1iiifg | Rust, Zig, and the Futility of "Replacing" C | 163 |
| ufxu8n | Fair Source | 162 |
| ya4ajj | What language do you prefer for new project starts? | 159 |
| yi97jn | Is it time to look past Git? | 158 |
| utbyws | Mitigating Content Marketing | 158 |
| 7aglnr | PSA: iTerm2 now has ChatGPT integration | 158 |
| ktvzwl | Use plaintext email | 156 |
| z9rb82 | I don't care about memory safety | 156 |
| 5ysabq | Share your blog | 155 |
| endspx | Software you are thankful for | 155 |
| fx3enz | What are your hobbies? | 155 |
| qj3cts | Happy International Workers' Day Lobsters | 152 |
| wei3a9 | Downvote category for inappropriate/hostile/abusive comments | 152 |
| 5ovrc2 | What's Your Most Controversial Technical Opinion? | 151 |
| ax4j9b | Go evolves in the wrong direction | 151 |
| gjza8a | What software do you dream about, but do not have time to code yourself? | 150 |
| sqlmcl | Planes grounded as mass worldwide IT outage hits airlines, media and banks | 150 |
| umicte | Give Up GitHub | 149 |
| j7tc67 | What software do you use daily? | 149 |
| uqmba9 | What are you reading this week? | 149 |
| lpvcsm | Proposal for moderation policies: no tone policing, no pretending systemic bias doesn't exist | 148 |
| hrxdoq | What's the URL to your technical blog? | 148 |
| j7zv69 | If you could re-design Rust from scratch today, what would you change? | 144 |
| htsbex | Back to Microsoft · Using Windows again so I can use Linux effectively | 144 |
| cv4oni | Richard Stallman announcing his return to the FSF's Board of Directors | 142 |
| jr4crd | What should a new OS have? | 142 |
| oicggq | Go’s Error Handling Is Perfect, Actually | 141 |
| zqiafw | Generics arent ready for Go | 140 |
| ci3nxw | What do you do in your spare time? | 140 |
| ngrid5 | RCE 0-day exploit found in log4j, a popular Java logging package | 139 |
| 0qvtim | Open letter to the NixOS foundation | 138 |
| 8mroaa | Where Did Software Go Wrong? | 137 |
| hbkh21 | What do you plan to learn in 2020? | 137 |
| goq4d8 | Announcing the Hare programming language | 137 |
| 2ztpzk | The RuboCop Name Drama Redux | 136 |
| 0c0tvx | What email client do you use? | 136 |
| nl96zm | What keyboards do you use? Do you program them? | 136 |
| ypzg4z | We can do better than Signal | 135 |
| h491m8 | What static site generator and theme do you use for your blog | 135 |
| no5usw | The Internet Has a Huge C/C++ Problem and Developers Don't Want to Deal With It | 135 |
| zycaco | In 2024, please switch to Firefox | 135 |
| wiavtb | Rust: A Critical Retrospective | 134 |
| e5lx5p | What {note taking|team wiki|personal wiki|external brain} tool do you use? | 134 |
| mox75k | 2021 Mod Applications | 133 |
| j8li8k | Which Self Hosted applications do you run? | 133 |
| qmkbvh | The Anti-Capitalist Software License | 133 |
| h9haqa | Counting the Countless: Why data science is a profound threat for queer people | 133 |
| plmk9r | New Names for the Oil project and "Oil Shell"? | 133 |
| nbr9bl | What's your editor setup? | 132 |
| khylf0 | Fucking laptops | 132 |
| mfttff | Tailwind vs. Semantic CSS | 132 |
| mf7guc | In Leak, Facebook Partner Brags About Listening to Your Phone’s Microphone to Serve Ads for Stuff You Mention | 131 |
| 80lw9s | Serde has started shipping precompiled binaries with no way to opt out | 131 |
| xdhle7 | C isn’t a Hangover; Rust isn’t a Hangover Cure | 130 |
| oftv75 | Poll: what are your thoughts on programmer/technologist professionalization? | 129 |
| uyw4pq | Lobsters battlestations and screenshots (2017) | 128 |
| gnuywz | Rust is not a good C replacement | 128 |
| qcenv8 | RMS addresses the free software community | 127 |
| bkw5u0 | No Stale Bots | 127 |
| pechdy | Turn off DoH, Firefox. Now | 127 |
| 8deiib | Keyboard recommendations | 126 |
| brcn0w | actix-web author: "I am done with open source" | 126 |
| hyoser | You Should Not Ignore the Mastodon Social Network Any More | 125 |
| 7qazoc | Crustaceans of Mastodon, where are you? | 125 |
| lg2cmt | Tools that made you productive or saved you time | 124 |
| mfkhq9 | What laptop are you using? | 124 |
| n6eix9 | Rich Hickey delivers rationale for choosing dynamic typing in Clojure | 123 |
| javp7g | What static site generator do you use? | 123 |
| gfm298 | My personal journey from MIT to GPL | 123 |
| xuppr2 | Sunsetting Mercurial support in Bitbucket | 123 |
| deni6q | Lies we tell ourselves to keep using Golang | 122 |
| nfqbyh | Who do you use for hosting your personal domain/mail? | 121 |
| q3vzin | Fun Format Friday: LOBSTERS-LANG is a language that features | 120 |
| ivryqt | What is this Gemini thing anyway, and why am I excited about it? | 120 |
| h4j3lg | Killer libraries? | 120 |
| xnjo8g | Add downvote reason, "unkind"? | 119 |
| dnfxpk | Hello world | 118 |
| sfzmwr | Proposal: set everyone's invite count to zero for a while | 118 |
+----------+-----------------------------------------------------------------------------------------------------------------+----------------+
100 rows in set (0.116 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment