R.L. Dane    πŸ΅ May 25, 2025

@tripplehelix @amin @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Not too surprised, my general impression is that tastes in the UK are somewhere between US and the rest of Europe.

...US tastes being heavily skewed towards sweetness.

P.S., mainly talking about desserts. Tastes regarding other things are extremely varied in the US, and I know for sure Brits can't handle spice like we do. Particularly in #Texas. XD

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 25, 2025

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

I need something chewy, ideally. Flavor-wise I like cinammon and licorice the most.

Show threadR.L. Dane    πŸ΅ May 25, 2025

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Now I want a cinnamon twizzler (or something similar, not just that one brand which is mediocre at best). That would be insane.

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 25, 2025

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

I've had cinnamon licorice and it was glorious. Much thicker and fatter than a twizzler, though.

Show threadR.L. Dane    πŸ΅ 

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Twizzlers are honestly pretty meh. They're just the most well-known here. They don't have much flavor.

May 25, 2025 at 2:01pmWeb
Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 25, 2025

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Agreed. If I have a choice between 'murican candies, though, I usually will request it as one of them.

Twizzlers, Reese's (pieces or cups), and Hot Tamales. Used to love red hots but haven't had them in a while.

Show threadR.L. Dane    πŸ΅ May 25, 2025

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

ooo, red hots are the little jelly bean-kinda-like things, right? No wait, more like Mike & Ike's, but cinnamon? Those are awesome.

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 25, 2025

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

You're thinking of Hot Tamales, and yes they're made by the same company as Mike and Ike's.

Red hots are made by the same company as Nerds. And their website is giving me a 403 but maybe it'll let you through: https://www.ferraracandyshopusa.com/brands/red-hots

Redhots

These candies hit you from your nose to your toes. In the early 1930's, the Ferrara Pan Candy Company created the famous Red Hot using the same cold panned candy method used today. Whether you eat them by the handful, put them on birthday cakes or use them as a decorative touch to your gingerbread house, there are a million fiery ways to spice up your life.

Show threadR.L. Dane    πŸ΅ May 25, 2025

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Ah, yes! Those are way better than hot tamales!

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 25, 2025

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

I think I prefer the hot tamales, they don't get stuck in my teeth as easily. And the spice helps self-regulate the speed I eat theme at. ;)

Show threadR.L. Dane    πŸ΅ May 25, 2025

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

How many total replies has this abomination of a #hellthread had so far? Is there an easy way to tell, other than counting them in tut?

Just counted... 124! XD

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 25, 2025

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

@mirabilos was just testing a query for that earlier today, no?

Show threadmirabilosMay 25, 2025

@amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo enjoy:

gotosocial=> WITH RECURSIVE findtop AS ( SELECT id, in_reply_to_id FROM statuses WHERE id='01JW3X0YS8B85R8TEJEWQJC0NS' UNION ALL SELECT s.id, s.in_reply_to_id FROM statuses s INNER JOIN findtop f ON s.id = f.in_reply_to_id ), threads AS ( SELECT id, in_reply_to_id, 1 AS depth, id AS op FROM findtop WHERE in_reply_to_id IS NULL UNION ALL SELECT s.id, s.in_reply_to_id, t.depth + 1, t.op FROM statuses s INNER JOIN threads t ON s.in_reply_to_id = t.id ), counts AS ( SELECT op, COUNT(*) AS count FROM threads GROUP BY op ), leaves AS ( SELECT id, depth, op FROM threads WHERE NOT EXISTS ( SELECT * FROM statuses s WHERE s.in_reply_to_id = threads.id ) ) SELECT id AS leaf, depth, counts.op AS threadtop, count FROM leaves INNER JOIN counts USING (op) ORDER BY counts.op ASC, depth DESC, id ASC; leaf | depth | threadtop | count ----------------------------+-------+----------------------------+------- 01JW3X0YS8B85R8TEJEWQJC0NS | 30 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3WY20GSGPJ01XMP5D0ZQ7P | 29 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3W933REMHBXECTMVH1NYDN | 27 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3Y4KD8ESBX7R89ZQWMJTQF | 26 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3VYM50EZX52AQN919NFTRW | 24 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3VTH9GR8STA1Q33PKBM9J3 | 23 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3WX1S85A0YZGA5RKPSRF42 | 23 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3X6MDRYTB6XVWYXS8F751T | 23 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3WWS00YDXQY7TQ4RV3TVQ4 | 22 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3WRH8882FKHSZ3H4WWDNZ8 | 20 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3VQ4WRMG4J2HEY209TEZ91 | 19 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3WT7Y8X1VKZPPM7XT4SP7E | 19 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3V4S08W578VF1MRDF23PXT | 18 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3WRM60PFT0ZQZJ36CGR0JP | 18 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3TS6WGP34VEEQNT02E61Y8 | 17 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3VCZPGPGTZ81GAX469QZY2 | 14 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3VNK30T0X70HKABFVW9XFA | 14 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3VKVDR392DYH91SM00HE1B | 13 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3VKDR80T358A01H5T8C68K | 12 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3X98D86PYSJM78HAEDXYHR | 12 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3V0FA0P038MCJ1CKGG8W4R | 10 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3V2XE0QPV6T2DJHHJAYY7Z | 10 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3VG1BGDFV5HJEBBSEPMKJJ | 10 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3T5C40EJ6XCAJAYW2X5CDN | 8 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3TERX04HP6P1YZW707YJWN | 8 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3TNDSG2R3JC4CMXFX4G9PF | 8 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3S4BFGEJXJY7JTXH31SYQT | 6 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3TG6SRNR6RW9RESKDYE37M | 6 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3MH8EG2M5NZHW57Z14HC18 | 5 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3T7PB0GN3NR7155K8QDN6W | 5 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 01JW3J0JDG7NPMM8J6AV51YDEK | 2 | 01JW3HZH70G8E94EXNS1A2GNDS | 126 (31 rows)

So, the thread (before posting my reply) has 126 toots in total, 31 leaves, the deepest of which was 29 replies in (30 levels including the OP).

Show threadmirabilosMay 25, 2025
@cloud_manul schon recht cool, dieses SQL… bißchen doof noch, daß die RΓΌckgabe immer genau eine rechteckige Tabelle sein muß, aber die Duplikation in den rechten Spalten ist ja auch kein Problem
Show threadCloud ManulMay 25, 2025
@mirabilos Es gibt in letzter Zeit durchaus vielversprechende AnsΓ€tze, dass man mit den Eingaben (nachdem man sie so gut wie mΓΆglich reduziert hat natΓΌrlich) eine Umwandlung in JSON(B) macht und es dann etwas leichter hat, Ergebnisse mit stark abweichenden Strukturen zusammenzufΓΌhren. Ich bin grundsΓ€tzlich dafΓΌr zu haben, aber man muss immer im Hintergrund behalten, dass das CPU-intensiv sein kann.
Show threadmirabilosMay 25, 2025
@cloud_manul ah, hmja, müßte man dann sehen, wie es es formatiert, aber nette Idee
Show threadmirabilosMay 25, 2025

@cloud_manul hm, not a fan of JSON in PostgreSQL, but it dothe work @amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

$ psql gotosocial psql (13.21 (Debian 13.21-0+deb11u1)) Type "help" for help. gotosocial=> \pset format unaligned Output format is unaligned. gotosocial=> \pset tuples_only Tuples only is on. gotosocial=> WITH RECURSIVE gotosocial-> findtop AS ( gotosocial(> SELECT id, in_reply_to_id FROM statuses gotosocial(> -- can use thread_id and/or multiple values here: gotosocial(> WHERE id IN ('01JW3X0YS8B85R8TEJEWQJC0NS') gotosocial(> UNION gotosocial(> SELECT s.id, s.in_reply_to_id gotosocial(> FROM statuses s INNER JOIN findtop f ON s.id = f.in_reply_to_id gotosocial(> ), gotosocial-> threads AS ( gotosocial(> SELECT id, in_reply_to_id, 1 AS depth, id AS op FROM findtop gotosocial(> WHERE in_reply_to_id IS NULL gotosocial(> UNION ALL gotosocial(> SELECT s.id, s.in_reply_to_id, t.depth + 1, t.op gotosocial(> FROM statuses s INNER JOIN threads t ON s.in_reply_to_id = t.id gotosocial(> ), gotosocial-> counts AS ( gotosocial(> SELECT op, COUNT(*) AS count FROM threads GROUP BY op ORDER BY op gotosocial(> ), gotosocial-> leaves AS ( gotosocial(> SELECT id, depth, op FROM threads WHERE NOT EXISTS ( gotosocial(> SELECT * FROM statuses s WHERE s.in_reply_to_id = threads.id) gotosocial(> ORDER BY depth DESC, id ASC gotosocial(> ), gotosocial-> jleaves AS ( gotosocial(> SELECT op, to_jsonb(array_agg(id || ': ' || depth)) AS leaves FROM leaves GROUP BY op gotosocial(> ), gotosocial-> jthreads AS ( gotosocial(> SELECT jsonb_build_object('OP', j.op, 'TOOTS', c.count, 'leaves', jsonb_array_length(j.leaves), 'depth', j.leaves) AS t gotosocial(> FROM jleaves j INNER JOIN counts c USING (op) ORDER BY j.op gotosocial(> ) gotosocial-> SELECT jsonb_pretty(to_jsonb(array_agg(t))) FROM jthreads; [ { "OP": "01JW3HZH70G8E94EXNS1A2GNDS", "TOOTS": 207, "depth": [ "01JW3Z997RARQM8Y7S6CJAH1VY: 37", "01JW43WX0X1PAKRZ9WCWKXFXR2: 34", "01JW45ECVG4BQT3E7V7YRFMEY4: 34", "01JW4004P0R0327M1T2N1Q7C9W: 31", "01JW3WY20GSGPJ01XMP5D0ZQ7P: 29", "01JW3ZWX5GE8RG3B4VABKV36KN: 29", "01JW45KSPRDJTDM7YR2SE7D2AH: 29", "01JW3W933REMHBXECTMVH1NYDN: 27", "01JW3VYM50EZX52AQN919NFTRW: 24", "01JW3Y01X0444RVT310X9RRMKG: 24", "01JW494YSR3TD6NKX7B2ESTCA4: 24", "01JW4BX24GGMXVAAQVSADPS54B: 24", "01JW3VTH9GR8STA1Q33PKBM9J3: 23", "01JW3WX1S85A0YZGA5RKPSRF42: 23", "01JW3X6MDRYTB6XVWYXS8F751T: 23", "01JW3X7VFRCZCKBZV2780BM6S2: 23", "01JW492ZAGNK8AN73XE9D8HEYF: 23", "01JW3WWS00YDXQY7TQ4RV3TVQ4: 22", "01JW3XMSHR0RG905GCNPK0QJX7: 22", "01JW48Y9X866PFTGJ7HXSNNXV3: 21", "01JW3WRH8882FKHSZ3H4WWDNZ8: 20", "01JW48VVS80JHPSNXQE5VX65HV: 20", "01JW4D8FS8P4JMRW485P777CZ0: 20", "01JW3VQ4WRMG4J2HEY209TEZ91: 19", "01JW3WT7Y8X1VKZPPM7XT4SP7E: 19", "01JW3V4S08W578VF1MRDF23PXT: 18", "01JW3WRM60PFT0ZQZJ36CGR0JP: 18", "01JW48RV3GS6R2AG1NCB7A9A2Q: 18", "01JW3TS6WGP34VEEQNT02E61Y8: 17", "01JW3WA96G8ZMV0375MZN4Y29D: 17", "01JW48GJERJE860HQE3TNYZ8FZ: 17", "01JW48QQYG6Y1NDT21K8143SE9: 17", "01JW3W2TXGVCKZ4GBZVX610S1W: 16", "01JW48F5H86GE5FQTJRYP22EX5: 16", "01JW4A7EA8VADPMWQ59NX4HN1Z: 16", "01JW4B8XKG58WEDRD5HJ27VYFS: 16", "01JW48MS78DR4NVZYJXCPAAE70: 15", "01JW498RW0E5HBKYJ0Q7305QXY: 15", "01JW3VNK30T0X70HKABFVW9XFA: 14", "01JW3VKVDR392DYH91SM00HE1B: 13", "01JW3W0NJRNT33ZWR10VXKBAQB: 13", "01JW3V2MMRXV9JPY4RDBPHF5QG: 12", "01JW3X98D86PYSJM78HAEDXYHR: 12", "01JW3V0FA0P038MCJ1CKGG8W4R: 10", "01JW3V2XE0QPV6T2DJHHJAYY7Z: 10", "01JW3VG1BGDFV5HJEBBSEPMKJJ: 10", "01JW49YR00EEG28B6GXBMZRPYH: 9", "01JW3T5C40EJ6XCAJAYW2X5CDN: 8", "01JW3TERX04HP6P1YZW707YJWN: 8", "01JW3TNDSG2R3JC4CMXFX4G9PF: 8", "01JW47Q21RM92MZKKRP659VY3E: 8", "01JW47P3S0GCWSABT2B69SJKKA: 7", "01JW3S4BFGEJXJY7JTXH31SYQT: 6", "01JW3TG6SRNR6RW9RESKDYE37M: 6", "01JW47GM00GBSD1WPB25NSHTKR: 6", "01JW3MH8EG2M5NZHW57Z14HC18: 5", "01JW47K240HE3XW151GJF0ZWSS: 5", "01JW3J0JDG7NPMM8J6AV51YDEK: 2" ], "leaves": 58 } ]
Show threadmirabilosMay 25, 2025

@cloud_manul @amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo note this also works for multiple starting points, for which you can use WHERE id IN (…) or WHERE thread_id IN (…) or even WHERE id IN (…) OR thread_id IN (…) (the duplication is necessary; while one can combine the search in PostgreSQL, the combined search cannot use the indicΔ“s and is dead slow) if you have either a post ID (like https://semaphore.social/statuses/xxx) or a GtS 0.19+ DB thread ID, thanks to use of UNION ipv UNION ALL in the β€œfindtop” query (which just goes from an arbitrary point (or more than one) in the thread to its starting point a.k.a. the OP), and it’ll show you the information for multiple threads separately, for example…

gotosocial=> WITH RECURSIVE gotosocial-> findtop AS ( gotosocial(> SELECT id, in_reply_to_id FROM statuses gotosocial(> -- can use thread_id and/or multiple values here: gotosocial(> WHERE id IN ('01JHC4Q1RXD9XBR3ESVQ2XT6QS', '01JW4BKHEGG216D56XXNC50MJW') OR thread_id IN ('01JHC4Q1RXD9XBR3ESVQ2XT6QS', '01JW4BKHEGG216D56XXNC50MJW') gotosocial(> UNION gotosocial(> SELECT s.id, s.in_reply_to_id gotosocial(> FROM statuses s INNER JOIN findtop f ON s.id = f.in_reply_to_id gotosocial(> ), gotosocial-> threads AS ( gotosocial(> SELECT id, in_reply_to_id, 1 AS depth, id AS op FROM findtop gotosocial(> WHERE in_reply_to_id IS NULL gotosocial(> UNION ALL gotosocial(> SELECT s.id, s.in_reply_to_id, t.depth + 1, t.op gotosocial(> FROM statuses s INNER JOIN threads t ON s.in_reply_to_id = t.id gotosocial(> ), gotosocial-> counts AS ( gotosocial(> SELECT op, COUNT(*) AS count FROM threads GROUP BY op ORDER BY op gotosocial(> ), gotosocial-> leaves AS ( gotosocial(> SELECT id, depth, op FROM threads WHERE NOT EXISTS ( gotosocial(> SELECT * FROM statuses s WHERE s.in_reply_to_id = threads.id) gotosocial(> ORDER BY depth DESC, id ASC gotosocial(> ), gotosocial-> jleaves AS ( gotosocial(> SELECT op, to_jsonb(array_agg(id || ': ' || depth)) AS leaves FROM leaves GROUP BY op gotosocial(> ), gotosocial-> jthreads AS ( gotosocial(> SELECT jsonb_build_object('OP', j.op, 'TOOTS', c.count, 'leaves', jsonb_array_length(j.leaves), 'depth', j.leaves) AS t gotosocial(> FROM jleaves j INNER JOIN counts c USING (op) ORDER BY j.op gotosocial(> ) gotosocial-> SELECT jsonb_pretty(to_jsonb(array_agg(t))) FROM jthreads; jsonb_pretty [ { "OP": "01JHBSJABRE18TSGTNPT0RYBWD", "TOOTS": 258, "depth": [ "01JHCC64RR1T09R50TS5REB4CV: 43", "01JHCCJWZ8VPCKKKBKMCQ8ESAB: 43", "01JHCCXBY0403MN91HH8NZGZJJ: 43", "01JHCCPVXRHB9CK422DNWV83J4: 42", "01JHCC9C98126988JZ8SC251EB: 41", "01JHCCM418V2Q9VBQ8EP0G4SK2: 41", "01JHCCND1R4NS0EKPNS8BRSMHV: 41", "01JHCBWSY8H3TYKAZVJ7B99XYB: 39", "01JHCBXP8G43JDAJYACWKYYMQ5: 39", "01JHCC40D849JW3EQDY1AMR8VZ: 39", "01JHCEK8NWPJZ1TMKF4F95WB3Y: 39", "01JHCCPP282JXHMAV7PQ643EF8: 38", "01JHCEEP8CDRWQXKYTCFANCWCY: 38", "01JHG4WBK038180C5Z606CRKB3: 38", "01JHCBHVBGD4GC3XND3YTFHDX4: 37", "01JHCBJHT8F8M8VKPGC9G8S7F3: 37", "01JHCB44W8NEEFC1GQDB2N0RQQ: 36", "01JHCANJ33DQKK9V0V9NE3283Q: 34", "01JHCB3N8809R3EJF47R3QBS6T: 34", "01JHCBDFPRR5RBCNMVJ0VC1YHA: 34", "01JHEA5PJ53DKFKMJ9KA44A6H0: 34", "01JHEFA34RF7JS21WKD440JZHH: 34", "01JHES5XW6DW8EKZC29F286F1W: 34", "01JHHEQB80BKJ43FGDJ2H4CPGW: 34", "01JHCA9PQN6ZH715MQZ5J36RN2: 33", "01JHCAF2TXTW7BQRE8C7YQYAGE: 33", "01JHCAMB0RJRQF3KRJTKQNDZ02: 33", "01JHCARZERY23P10GPFGTKH5AQ: 33", "01JHHRN64RFYQZC8HHVJ3NWVFS: 33", "01JHCAEEHGW8JKE1PECVVW3YC2: 32", "01JHCAGNTRKHZY0BBK7SRX17JG: 32", "01JHCAJ5P09CFVJGW66FNCDX6T: 31", "01JHCG5EA502J9P5T0VHPTFMCN: 31", "01JHE8EETGM75RCQDJ0RK6618J: 31", "01JHC9X4VHSQQA4YT1HMA6NY8T: 30", "01JHCA4C90T4PS7NP86XG5MGCJ: 29", "01JHCAEG40AQF4YD89ZYGY4G88: 29", "01JHCESMNRYD8HJEVAD5HYHM20: 29", "01JHE5SF5YEVN2QEA23611C96Y: 29", "01JHC9W7H8FBP3V0CASXE6Z12A: 28", "01JHC9YMP06CXH0W7XBRE3S51W: 28", "01JHCA5W485ZM7A9CG9NE9151M: 28", "01JHC9JQTG5Q9VPAC6TERTBAMQ: 27", "01JHC9W9FR50R0XRQ19PEDW0AW: 27", "01JHC9YJQGKZEHGNFT3FVG3176: 27", "01JHC9JTR8P6HJ15S56N5E1GD5: 26", "01JHC9D260DWZPQA8YVQGAZJP7: 25", "01JHC9KS103SNCN1ERF9T1TH0D: 25", "01JHC9NJMRHXA9G8A2FT3QTJWG: 25", "01JHC9P10Z7G2SB76KHMQ5Q93J: 24", "01JHC68M8CWY5YQRZDK1S77GD0: 18", "01JHC8Z1Y8PA3Q9WYZDAT5ZCND: 18", "01JHC5WZR9WEEPGYXAJGFDWEJH: 17", "01JHC5H2QXQ6Y5G35WF7VSBPQ2: 16", "01JHC524W061BVBS0VP3M7EB7Y: 15", "01JHC5BHER0VYKR1G2APZES1JA: 15", "01JHC82A0R1XFBC97FFCYF08BD: 15", "01JHC8KT963NED0WTCEWA03PB3: 15", "01JHG8SFG0RW6W9FXGEGETN9HN: 15", "01JHC7ZRZ0ZFQM4YJS56X1FPER: 13", "01JHC4PRKRRF7VGX1X62DDQQBV: 12", "01JHG8DBSRQPJN48PG6SCE9CK9: 12", "01JHC7W0V8JPE1ZXXN2RDJD1XV: 11", "01JHC7XPJ08YEMTD6JMTR4K10T: 11", "01JHC43EEG0YJ3KGYNR1RW6BZ2: 10", "01JHC2F6JGXZPNM1SQ5W0FX70S: 7", "01JHC2EYRGDHPXED5W2RHSAPQE: 6", "01JHG018PGTCD65Z16MBMTSA2G: 5" ], "leaves": 68 }, { "OP": "01JW4BKHEGG216D56XXNC50MJW", "TOOTS": 10, "depth": [ "01JW4D30080K16JM4XWMJ1BG4W: 3", "01JW4DD478G4HX9JA6NMPPETK8: 3", "01JW4BQ4P0GMD9KBX51XDF4YVC: 2", "01JW4BSTM0FTB630JF9F1SMMHW: 2", "01JW4C266GDV3DJDD6M79MZ2DQ: 2", "01JW4C682RZCJBFKDCXHZPT7ZD: 2", "01JW4C9JH0KW0GTTABWP6VD33B: 2" ], "leaves": 7 } ]

(this example uses a post ID and a thread ID it turns out)

Show threadmirabilosMay 25, 2025

@cloud_manul @amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo (ofc the IDs are per instance, so y’all cannot do anything with my IDs)

But one (as instance operator) can map one’s own instance’s IDs with:

gotosocial=> SELECT url FROM statuses WHERE id='01JHBSJABRE18TSGTNPT0RYBWD'; https://polymaths.social/@rl_dane/statuses/01JHBSJAG7MD2ECAVVKVY9Z8BJ

(There’s also uri in case the one from url doesn’t work… grr in the general direction of some weird instance softwares where one works but not the other.)

Show threadmirabilosMay 25, 2025

@sotolf @dm @adamsdesk @roguefoam @gorkmo @jlw_the_jobber @rl_dane @kudzu @clayton @dmoonfire @joel @tripplehelix @krafter @alatartheblue @btp @amin @fbievan @thedoctor @orbitalmartian @cloud_manul (I tried to make the leaves array(id, depth) first but the prettyprinter made that too hard to read, so string concatenation it is)

These queries give good as immediate results, as we’re only querying one thread, not millions of them, and it can use the indicΔ“s well enough.

Show threadsotolfMay 25, 2025
@rl_dane @amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo so american sweets, they all tastes like nothing with sugar on top, except the chocolate, that tastes like vomit :p
Show threadR.L. Dane    πŸ΅ May 25, 2025

@sotolf @amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

They don't taste like vomit to me (because I grew up on them), but they do taste like tasteless sweetness and a burning in the throat.

American chocolate has a different process than European. I don't remember the deets, but you can find it on YT.

But generally not great quality and too sweet, anyway.

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 26, 2025

@sotolf @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Twizzlers aren't actually very sweet, at least in comparison to the other American candies.

But yeah, in general American sweets aren't great, imo.

Show threadR.L. Dane    πŸ΅ May 26, 2025

@amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

I'm trying to think of american sweets I actually like...

Sour punch straws are pretty good, but also very intense in flavor. Same goes for Atomic Warheads. Or were they called Atomic Fireballs? That's it. I'm conflating them with Warheads, the super-sour candies, which are NOT enjoyable, except if you're able to make it through the sour part, and the inner candy is actually kinda nice.

I really like jolly ranchers, and the sugar-free kind are still pretty good.

Twinkies and Moon Pies I rank under "I like them because I liked them, not because they're actually good." Moon Pies are better than Twinkies, though.

I love Oreos and think they should be a controlled substance. Kinda seriously.

Turtles are amazing. They're chocolate-covered caramel nut clusters.

The chocolate-covered Reeses' pretzel bar thingies are pretty good, but too sweet.

Kit Kat are pretty good, but not great. Same goes for Keebler wafer bars. I just love the wafer texture. One of my favorite Persian treats is ice cream sandwiches made of Persian-style saffron and pistachio ice cream and plain wafers.

Baby Ruth is probably my favorite chocolate. Very complex texture, and the chocolate itself is not too bad. For those who haven't seen them, it's a peanut-encrusted caramel bar dipped in chocolate. Very sweet, but still quite nice.

I think that's about it. I have yet to try Mallomars, as they have to be shipped in while it's cold outside.

Oh, and Nerds. I love nerds. Again, that's one of those things I had as a kid that has nostalgic value more than out-right flavor value.

Show threadsotolfMay 26, 2025
@rl_dane @amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo I seriously don't know what 90% of that stuff is :p I know kit-kat which is basically just a bad knock-off of kvikk-lunsj, with lower quality chocolate, and Oreos, wich is basically just sugar :p
Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 26, 2025

@sotolf @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Does kvikk-lunsj have green tea flavored ones, though? ;)

Show threadsotolfMay 26, 2025
@amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo Green tea doesn't exist in Norway :p
Show threadR.L. Dane    πŸ΅ May 26, 2025

@sotolf @amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Show threadR.L. Dane    πŸ΅ May 26, 2025

@sotolf @amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Dude, oreos are amazing. The sweetness, chocolate-like-ness (not actually chocolate, nobody knows what it is), and the crisp texture (especially the thins) are just addictive as heck.

Show threadsotolfMay 26, 2025
@rl_dane @amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo Way too sweet for my liking, we have some "generica" of them and they are better because they are less sweet :)
Show threadR.L. Dane    πŸ΅ May 26, 2025

@sotolf @amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

I would love to try that.

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 26, 2025

@rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

They're kinda gross

Show threadR.L. Dane    πŸ΅ May 26, 2025

@amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Then why am I so addicted that I cannot buy them? :P

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 26, 2025

@rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

I dunno, you also watch youtube shorts.

Show threadsotolfMay 26, 2025

@amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Turn up the brainrot channel :p

Show threadR.L. Dane    πŸ΅ May 26, 2025

@amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

FECKING SHOTS FIRED JEEZ!!! XD XD XD

If words were bullets, I'd look like swiss cheese. XD

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 26, 2025

@rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

I'm just saying your thought process is alien to me. XD

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 26, 2025

@rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

But yes, oreos are to sweets what youtube shorts are to entertainment.

Show threadR.L. Dane    πŸ΅ May 26, 2025

@amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Now listen here, you... 🀣

Show threadOrbitalMartianMay 26, 2025

@amin

is alien

Is me! πŸ‘½

@rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Show threadfbievan (powered by REAL polymaths)May 26, 2025

@orbitalmartian @amin @rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Oreos are mid

Chili is where its at

Show threadKrafterMay 26, 2025

@fbievan @orbitalmartian @amin @rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

how are you comparing oreos to chili?????

Show threadfbievan (powered by REAL polymaths)May 26, 2025

@krafter @orbitalmartian @amin @rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Wdym

Show threadKrafterMay 27, 2025

@fbievan @orbitalmartian @amin @rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

thats like... not a comparison you can make...

Show threadfbievan (powered by REAL polymaths)May 27, 2025

@krafter @orbitalmartian @amin @rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

It is though

Show threadR.L. Dane    πŸ΅ May 27, 2025

@fbievan @krafter @orbitalmartian @amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

You lost me at "mid" and "wdym"

Flipping zoomer-talk, man. DX

Show threadfbievan (powered by REAL polymaths)May 27, 2025
@rl_dane @krafter @orbitalmartian @amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo 'wdym' isn't even zoomer speak tho
Show threadJust… Josh May 27, 2025
@fbievan @rl_dane @krafter @orbitalmartian @amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @gorkmo This convo went straight Ohio….

No rizzlers here. 🀣
Show threadR.L. Dane    πŸ΅ May 27, 2025

@jlw_the_jobber @fbievan @krafter @orbitalmartian @amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @gorkmo

zoomers got no rizz.
Except for the ones that listen to big band. Glenn Miller max rizz.

Show threadR.L. Dane    πŸ΅ May 27, 2025

@fbievan @krafter @orbitalmartian @amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Possibly late millennial. Annoying enough.

Show threadfbievan (powered by REAL polymaths)May 27, 2025

@rl_dane @krafter @orbitalmartian @amin @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

ahem says the person who watches YouTube shorts

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 27, 2025

@krafter @fbievan @orbitalmartian @rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @clayton @roguefoam @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

Sure it is.

Apples are sweeter and have a central core. Oranges require removing the peel and are in mayn segments instead of one contiguous whole.

Show threadAmin Hollon πŸ–‹πŸ³πŸŒMay 27, 2025

@orbitalmartian @rl_dane @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

You like Oreos and YouTube Shorts? Suit yourself. ;)

Show threadR.L. Dane    πŸ΅ May 27, 2025

@amin @orbitalmartian @sotolf @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @joel @dm @btp @adamsdesk @jlw_the_jobber @gorkmo

I'm not certain if I like Oreos, or if I'm merely addicted.

I hate YT Shorts, and I'm addicted to them for the dopamine, or rather, the dopamine substitute.
Which only makes me hate it more, as the dopamine substitute has the opposite effect of dopamine.

The amount of time I spend on YT shorts per day is an excellent (inverse) measure of my mental health for that day. :/