Posts by collappsar@fediverse-lite.com
(DIR) Post #B2gTXR9zlrVWldZb1s by collappsar@fediverse-lite.com
2026-01-26T17:46:05.214728Z
0 likes, 0 repeats
@0461fcbecc4c3374439932d6b8f11269ccdb7cc973ad7a50ae362db135a474dd @c839bc85846f24fc6b777548fe654672377f4cc2a04cab19cddec75b2f8b4dbd Soapbox š«Pigpen :niggacheck:
(DIR) Post #B2gXI419vpKkStMhAe by collappsar@fediverse-lite.com
2026-01-26T18:28:07.225016Z
0 likes, 0 repeats
@lain @waifu Neither have had the cultural impact WinAmp had yet.
(DIR) Post #B2gXTC9A33iirWPpRI by collappsar@fediverse-lite.com
2026-01-26T18:30:09.138011Z
0 likes, 0 repeats
@lain @waifu Really whips the Llama's ass, unlike GPT.
(DIR) Post #B2ghh9J6Oz11eQMGKu by collappsar@fediverse-lite.com
2026-01-26T20:24:42.276146Z
0 likes, 0 repeats
The database pruning continues. I ended up doing this.CREATE TABLE tmp_orphan_activity_ids (id uuid);INSERT INTO tmp_orphan_activity_ids (id)SELECT a.idFROM public.activities aLEFT JOIN public.objects o ON a.data ->> 'object' = o.data ->> 'id'LEFT JOIN public.activities a2 ON a.data ->> 'object' = a2.data ->> 'id'LEFT JOIN public.users u ON a.data ->> 'object' = u.ap_idWHERE NOT a.local AND jsonb_typeof(a.data -> 'object') = 'string' AND o.id IS NULL AND a2.id IS NULL AND u.id IS NULL;-- INSERT 0 19676859CREATE OR REPLACE PROCEDURE prune_orphaned_activities_from_table(batch_size integer DEFAULT 5000)LANGUAGE plpgsqlAS $$DECLARE rows_deleted integer;BEGIN LOOP WITH picked AS ( SELECT id FROM public.tmp_orphan_activity_ids LIMIT batch_size ), deleted AS ( DELETE FROM public.activities a USING picked p WHERE a.id = p.id RETURNING a.id ) DELETE FROM public.tmp_orphan_activity_ids t USING deleted d WHERE t.id = d.id; GET DIAGNOSTICS rows_deleted = ROW_COUNT; COMMIT; RAISE NOTICE 'deleted % rows this batch', rows_deleted; EXIT WHEN rows_deleted = 0; END LOOP;END;$$;CALL prune_orphaned_activities_from_table(5000);This cleared out the rest of the orphaned activities you'd get from that query. At last the query that prune_objects is able to run for that is able to actually finish executing within a few minutes. I just waited for the rest of the command and now it's actually able to run.
(DIR) Post #B2ghlA83Hx7zMG6SBM by collappsar@fediverse-lite.com
2026-01-26T20:25:27.661028Z
0 likes, 0 repeats
I added this to make future queries for pruning run faster.CREATE INDEX CONCURRENTLY IF NOT EXISTS fediverse_lite_activities_nonlocal_idxON public.activities ((data ->> 'object'))WHERE local = false AND jsonb_typeof(data -> 'object') = 'string';
(DIR) Post #B2ghxMkUC54byNtp32 by collappsar@fediverse-lite.com
2026-01-26T20:27:40.005170Z
0 likes, 0 repeats
I'm gonna bring my instance down to vacuum the entier database now. BRB.
(DIR) Post #B2gjHaQDARzw7nccE4 by collappsar@fediverse-lite.com
2026-01-26T20:42:30.280795Z
0 likes, 0 repeats
Before:```Filesystem Size Used Avail Use% Mounted on/dev/sda 158G 74G 77G 50% /```After:```Filesystem Size Used Avail Use% Mounted on/dev/sda 158G 17G 133G 12% /```FEELS GOOD MAN.Now I can downsize once more.
(DIR) Post #B2gllzjLpoPvDLCZcm by collappsar@fediverse-lite.com
2026-01-26T21:10:24.703352Z
0 likes, 1 repeats
@JoeBravo77
(DIR) Post #B2gm3IVdGk08NW2Gi8 by collappsar@fediverse-lite.com
2026-01-26T21:13:32.891848Z
0 likes, 0 repeats
I brought the instance connection settings and Postgres settings down to what they should be for a machine half the size and it seems to be working. Sweet. I'm gonna downsize the machine now.
(DIR) Post #B2goQiCA8RFsbvDmJU by collappsar@fediverse-lite.com
2026-01-26T21:40:09.769814Z
0 likes, 0 repeats
Okay! I updated the hell out of the system, purged dead and junk data, brought the instance size down. It's all working nicely and it's cheaper too.
(DIR) Post #B2gsR2j8CLf26b3VCa by collappsar@fediverse-lite.com
2026-01-26T22:25:03.830159Z
1 likes, 0 repeats
@deprecated_ii @BroDrillard CashApp Paypal strikes again.
(DIR) Post #B2h4MRy67fk0ONdGdM by collappsar@fediverse-lite.com
2026-01-27T00:38:41.580231Z
0 likes, 0 repeats
I had some shit where I wanted to read financial transactions that were being sent to an email inbox as CSV exports and they wouldn't export them with regularity any other way and I couldn't get IMAP shit to work with Go. I wrote the IMAP part in Python and got that working, told OpenCode with GPT how to write it like I wanted to the database. That worked. Then I had it convert it back into Go again. Boom. Now I've got an executable I can jam on a server and it'll just run for potentially years without interruption.I much prefer deploying Go executables because they just work, never fuck up with shared libraries, never need a new runtime to function. They just keep on chugging. Very low maintenance.
(DIR) Post #B2h5cdoTx2e7iSQ2iW by collappsar@fediverse-lite.com
2026-01-27T00:52:49.834051Z
0 likes, 0 repeats
I sometimes have a little cheese or a banana before bed and see if I have crazy dreams. They say there's no evidence for it, but I wanna find out.
(DIR) Post #B2h5iR7M4A3Q4x0gTY by collappsar@fediverse-lite.com
2026-01-27T00:53:52.492833Z
0 likes, 0 repeats
@Blouie Poor doggy.
(DIR) Post #B2h5xaDWW5vSe07MxM by collappsar@fediverse-lite.com
2026-01-27T00:56:36.760856Z
1 likes, 0 repeats
@caekislove There's no amount of money that will fix niggers, you just gotta get rid of them.
(DIR) Post #B2h6GyO2sWY96iHkEi by collappsar@fediverse-lite.com
2026-01-27T01:00:05.363556Z
0 likes, 0 repeats
@c839bc85846f24fc6b777548fe654672377f4cc2a04cab19cddec75b2f8b4dbd That's great Quilly! You should follow up with a blog post on why Soapbox is the best platform to post Boku no Pico reviews on.
(DIR) Post #B2h6Sj5TaTr58ECi0G by collappsar@fediverse-lite.com
2026-01-27T01:02:14.505726Z
0 likes, 0 repeats
@professionalbigot69 Ain't no good looking ones though.
(DIR) Post #B2h6mi3B9XD3hterwG by collappsar@fediverse-lite.com
2026-01-27T01:05:51.041745Z
1 likes, 0 repeats
@creamqueen @Junes We can have AI create a printable PS1 graphics paper constructible Big Pig that you can print at home if we give it the right geometric concepts and existing tools.
(DIR) Post #B2hkbAlUYwirSJRGqG by collappsar@fediverse-lite.com
2026-01-27T08:31:57.630374Z
1 likes, 0 repeats
(DIR) Post #B2iCm0seS0n6hXkGMi by collappsar@fediverse-lite.com
2026-01-27T13:47:39.884402Z
0 likes, 0 repeats
https://x.com/Rothmus/status/2016027829259981274Rand Paul sucks. If people "get to stay but don't get things" then the census will record them and the state gets more electoral votes and members of Congress, and their children become citizens and they get the free shit.