pushcx

select category, tag, privileged, is_media, active, permit_by_new_users, hotness_mod, (select count(*) from taggings where tag_id = tags.id) as stories, (select count(*) from tag_filters where tag_id = tags.id) as filters, (select date(created_at) from stories join taggings on stories.id = taggings.story_id and tag_id = tags.id order by created_at asc limit 1) as first from tags join categories on category_id = categories.id order by first asc;
+-------------+----------------+------------+----------+--------+---------------------+-------------+---------+---------+------------+
| category    | tag            | privileged | is_media | active | permit_by_new_users | hotness_mod | stories | filters | first      |
+-------------+----------------+------------+----------+--------+---------------------+-------------+---------+---------+------------+
| platforms   | mobile         |          0 |        0 |      1 |                   1 |           0 |     919 |     148 | 2012-06-30 |
| platforms   | browsers       |   

pushcx

From: Bushra Imteyaz 
To: [email protected]
Date: Tue, 11 Mar 2025 12:09:52 -0400
Subject: 🍽️ Your Recipe is Delicious… But It’s Missing a 2025 Twist!

[-- html --]
   Hi peter,
   I stumbled upon [1]A Recipe for Training Neural Networks (2019), and while
   it’s chef’s kiss 👌 it might be time for a little 2025 flavor upgrade!
   At GreekRecipeEats.com, we’re all about keeping recipes fresh, authentic,

pushcx

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, b

pushcx

Jun 21 12:56:56 lobste.rs puma[2445540]: [2445540] + Gemfile in context: /srv/lobste.rs/http/Gemfile
Jun 21 12:57:17 lobste.rs puma[2445540]: W, [2024-06-21T12:57:17.797831 #2445540]  WARN -- : heinous_inline_partial initialized, found: {"app/views/comments/_threads.html.erb"=>"app/views/comments/_comment.html.e>
Jun 21 12:57:21 lobste.rs puma[2364866]: [2364866] - Worker 14 (PID: 2445540) booted in 24.79s, phase: 0
Jun 21 14:53:14 lobste.rs systemd[1]: lobsters-puma.service: A process of this unit has been killed by the OOM killer.
░░ Subject: A process of lobsters-puma.service unit has been killed by the OOM killer.
░░ Defined-By: systemd
░░ Support: http://www.ubuntu.com/support
░░
░░ A process of unit @UNIT has been killed by the Linux kernel out-of-memory (OOM)
░░ killer logic. This usually indicates that the system is low on memory and that

pushcx

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 Billi

pushcx

[colors.selection]
background = "#859900"
text = "CellBackground"

[colors.vi_mode_cursor]
cursor = "#859900"
text = "CellBackground"

[cursor]

pushcx

short_id	score	(select count(*) from comments where story_id = stories.id)	title
hmyyz2	6	23	Limited Success Generating a Binary Search
glqqyp	13	6	Python's Missing Batteries: More Libraries
kkfept	30	54	One decade later, I’m still mad at GNOME
i1rbqo	11	6	Qualcomm Phone Chips Send Telemtry
6f72pf	17	2	Hyena may scale better than GPT
lo3ise	18	3	Jailbreaking a Dreametech Z10 Pro vacuum
l2fn3c	29	3	Discovering one bug after another in the UTF-8 decoding logic in OpenBSD
6gmzkr	43	46	Against Github
gc5ndw	75	31	Digital Ocean has shut down two technical sites

pushcx

domain
undeadly.org
paulrouget.com
techblog.netflix.com
queue.acm.org
blog.golang.org
commandcenter.blogspot.com
lkml.org
idealab.talkingpointsmemo.com
aws.amazon.com

pushcx

#!/usr/bin/env bash

#  aura -C pkg     -- to downgrade a package
#  aura -Li pkg    -- to print install/update log
#  aura -Pa        -- to audit PKGBUILDs (slow, s)
#  aura -Qo file   -- what package owns file
#  aura -Ql pkg    -- what files are in package

set -e # exit on error
set -o xtrace # print commands

pushcx

$ git log --all --grep='merged'
24fa1e6a  fix authored tag on merged story  1 year, 8 months ago, Peter Bhat Harkins
7a59fd95  1 + n on story domain for merged stories  1 year, 9 months ago, Peter Bhat Harkins
1a34c6ee  Fix bug allowing users to vote on, hide or save merged stories. (#739) (#748)  2 years, 5 months ago, 4io
db3d6453  fix 1 + n on merged stories, even if ugly to do from a view  2 years, 7 months ago, Peter Bhat Harkins
bd1a3033  (pmueller/master) Redirect json requests for a merged story's show page (#710)  2 years, 7 months ago, Preston Mueller
13797ad1  Fix #706, properly redirect json requests for a merged story's show page  2 years, 7 months ago, Preston Mueller
6bf4a9fb  fix BelongsTo rubocop warnings  2 years, 9 months ago, Thomas Dziedzic
0d7806b6  update comment count when merged into a story  2 years, 9 months ago, Preston Mueller
8a885abe  (pmueller-count) Fix #683, run callbacks when updating a story's comments count, so any merged_into_story will also update.  2 years, 9 months ago