Skip to content

Instantly share code, notes, and snippets.

View pushcx's full-sized avatar

Peter Bhat Harkins pushcx

341 followers · 9 following
View GitHub Profile
@pushcx
pushcx / gist:4a25100ce70ba1aa51a1d3e3f083060e
Last active March 9, 2026 16:38
MariaDB [lobsters]> SELECT user_is_author, MIN(score), AVG(score), MAX(score), STDDEV(score) FROM
-> stories GROUP BY user_is_author;
+----------------+------------+------------+------------+---------------+
| user_is_author | MIN(score) | AVG(score) | MAX(score) | STDDEV(score) |
+----------------+------------+------------+------------+---------------+
| 0 | -22 | 12.3296 | 341 | 16.1358 |
| 1 | -9 | 15.9859 | 472 | 21.5062 |
+----------------+------------+------------+------------+---------------+
MariaDB [lobsters]> SELECT user_is_author, MIN(score), AVG(score), MAX(score), STDDEV(score), count(*) FROM stories GR
@pushcx
pushcx / checklist.md
Last active July 11, 2026 21:18

2026-07-11 Trying the migration to sqlite again; we previously tried on 2026-02-21 but had to revert. Today's PR is #1927. I'm not streaming this because lots of steps make it too easy to flash PII or secrets on the screen.

For all the gory details, we planned this in issue #539.

sqlite migration checklist:

@pushcx
pushcx / mariadb.structure.sql
Last active February 12, 2026 17:47
structure.sql for dzwdz
/*M!999999\- enable the sandbox mode */
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
@pushcx
pushcx / schema.sql
Created July 31, 2025 21:04
/*M!999999\- enable the sandbox mode */
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
@pushcx
pushcx / most_comments.sql
Last active May 29, 2025 16:42
lobsters stories by most comments
MariaDB [lobsters]> select comments_count, stories_count, short_id, substring(title, 1, 80) as title, group_concat(tag order by tag asc separator " ") as tags from stories join taggings on sto
ries.id = taggi
+----------------+---------------+----------+----------------------------------------------------------------------------------+----------------------+
| comments_count | stories_count | short_id | title | tags |
+----------------+---------------+----------+----------------------------------------------------------------------------------+----------------------+
| 496 | 0 | h9xgpv | Rate my Homepage | ask web |
| 331 | 0 | btjtkr | What software do you dream about, but do not have time to code yourself? | ask programming |
| 306 | 14 | uihyvs | backdoor
@pushcx
pushcx / stories.tsv
Last active April 30, 2025 19:00
Lobsters stories tagged 'ai' or 'vibecoding' for https://lobste.rs/s/lkngrz/new_tag_vibecoding
posted submitter url title tags
2022-12-01 azhenley https://lobste.rs/s/rxulwm An Inverse Turing Test ai
2022-12-01 adrian https://lobste.rs/s/ek6f6b Adventures in generating music via ChatGPT text prompts vibecoding
2022-12-01 pja https://lobste.rs/s/pzscr9 AI solves Advent of Code 2022 programming, vibecoding
2022-12-02 barathr https://lobste.rs/s/adbzyf How should we evaluate progress in AI? philosophy, ai
2022-12-02 ebababi https://lobste.rs/s/fhccfk I tried ChatGPT from OpenAI and my mind was blown vibecoding
2022-12-03 djhworld https://lobste.rs/s/metddz ChatGPT corrects itself when you tell it off vibecoding
2022-12-03 adsouza https://lobste.rs/s/ipm2ls Peer-Programming a Buggy World with ChatGPT AI vibecoding
2022-12-04 winter https://lobste.rs/s/ldhk0l Building A Virtual Machine inside ChatGPT vibecoding
2022-12-04 Gaelan https://lobste.rs/s/so5l7i ChatGPT passes the 2022 AP Computer Science A free response section education, vibecoding
@pushcx
pushcx / tags.sql
Last active March 27, 2025 22:12
2025-03-27 lobsters tags query
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
pushcx / seo.eml
Created March 11, 2025 16:11
we get signal
From: Bushra Imteyaz
To: peter@lobste.rs
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
pushcx / mostcomments.sql
Created September 5, 2024 19:30
most comments
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
pushcx / log.txt
Created June 21, 2024 15:15
lobsters oom kill
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