Another look into PostgreSQL CTE materialization and non-idempotent subqueries
Follow on to https://lobste.rs/s/ebsgja/postgresql_planner_gotcha_with_ctes and https://www.shayon.dev/post/2025/119/a-postgresql-planner-gotcha-with-ctes-delete-and-limit/
[Comments](https://lobste.rs/s/xev3l9 ⦠ā Read more
š§® USERS:1 FEEDS:2 TWTS:1334 ARCHIVED:86974 CACHE:2839 FOLLOWERS:22 FOLLOWING:14
š§® USERS:1 FEEDS:2 TWTS:1333 ARCHIVED:86968 CACHE:2847 FOLLOWERS:22 FOLLOWING:14
IBM unveils the LinuxONE Emperor 5
Following the recent release of the IBM z17 mainframe, IBM today unveiled the LinuxONE Emperor 5, which packs much of the same hardware as the z17, but focused on Linux use. Today weāre announcing IBM LinuxONE 5,Ā performant Linux computing platform for data, applications and your trusted AI, powered by the IBM Telum II processor with built-in AI acceleration. This launch comes at a pivotal time, as technology leaders focus on three critical imperatives: enabling ⦠ā Read more
š§® USERS:1 FEEDS:2 TWTS:1332 ARCHIVED:86951 CACHE:2881 FOLLOWERS:22 FOLLOWING:14
š§® USERS:1 FEEDS:2 TWTS:1331 ARCHIVED:86912 CACHE:2874 FOLLOWERS:22 FOLLOWING:14
yarnd.
Hopefully I havenāt missed or messed anything upu š
* 101f3eb0 - (HEAD -> main) Fix a bunch of UX to do with following/unfollowing, bookmarking and unbookmarking (3 seconds ago) <James Mills>
Testing UI/UX is hard⢠š
Today, I did my longest bike tour this year so far. I went north to a lake in a neighboring district, mostly following the Weser-Harz-Heide route, which I already partly followed on my journey from Kassel to Braunschweig last year. There I sat down on a bench for half an hour and then returned. I had plenty of headwinds on the way there and a bit of tailwind on the way back, although the wind was mostly from the side. This time, I luckily did not mess up the OsmAnd tracking. Despite the wind, it was a lot of fun! ā Read more
š§® USERS:1 FEEDS:2 TWTS:1330 ARCHIVED:86883 CACHE:2892 FOLLOWERS:22 FOLLOWING:14
Would you take in a kitten that followed you home? ā Read more
š§® USERS:1 FEEDS:2 TWTS:1329 ARCHIVED:86868 CACHE:2902 FOLLOWERS:22 FOLLOWING:14
How to Enable Automatic Dark / Light Mode on iPhone & iPad
If youāre an iPhone or iPad user, you might appreciate a feature that automatically switches your devices appearance from Light Mode to Dark Mode, and vice versa, automatically. Furthermore, you can set the automatic enabling of Dark and Light mode to follow sunset and sunrise, or a custom schedule, whichever you prefer. As you probably ⦠[Read More](https://osxdaily.com/2025/05/02/how-to-enable-automatic-dark-light ⦠ā Read more
Confession:
Iāve never found microblogging like twtxt or the Fediverse or any other āmodernā social media to be truly fulfilling/satisfying.
The reason is that it is focused so much on people. You follow this or that person, everybody spends time making a nice profile page, the posts are all very āego-centricā. Seriously, it feels like everybody is on an ego-trip all the time (this is much worse on the Fediverse, not so much here on twtxt).
I miss the days of topic-based forums/groups. A Linux forum here, a forum about programming there, another one about a certain game. Stuff like that. That was really great ā and it didnāt even suffer from the need to federate.
Sadly, most of these forums are dead now. Especially the nerds spend a lot of time on the Fediverse now and have abandoned forums almost completely.
On Mastodon, you can follow hashtags, which somewhat emulates a topic-based experience. But itās not that great and the protocol isnāt meant to be used that way (just read the snac2 docs on this issue). And the concept of ālikesā has eliminated lots of the actual user interaction. ā¹ļø
š§® USERS:1 FEEDS:2 TWTS:1328 ARCHIVED:86845 CACHE:2901 FOLLOWERS:22 FOLLOWING:14
The main reason I named my new pet machine Ephemera, is because I donāt trust SSD/NVMeās ⦠itās always just a matter of time before everything goes to shā¦rimps.
ā`
$ mail
[ā¦]
The following warning/error was logged by the smartd daemon:
Device: /dev/nvme0, number of Error Log entries increased from 1587 to 1590
[ā¦]
āā`
š§® USERS:1 FEEDS:2 TWTS:1327 ARCHIVED:86834 CACHE:2905 FOLLOWERS:22 FOLLOWING:14
@movq@www.uninformativ.de If weāre focusing on solving the āmissing rootsā problems. I would start to think about āclient recommendationsā. The first recommendation would be:
- Replying to a Twt that has no initial Subject must itself have a Subject of the form (hash; url).
This way itās a hint to fetching clients that follow B, but not A (in the case of no mentions) that the Subject/Root might (very likely) is in the feed url.
If we must stick to hashes for threading, can we maybe make it mandatory to always include a reference to the original twt URL when writing replies?
Instead of
(<a href="https://we.loveprivacy.club/search?q=%23123467">#123467</a>) hello foo bar
you would have
(<a href="https://we.loveprivacy.club/search?q=%23123467">#123467</a> http://foo.com/tw.txt) hello foo bar
or maybe even:
(<a href="https://we.loveprivacy.club/search?q=%23123467">#123467</a> 2025-04-30T12:30:31Z http://foo.com/tw.txt) hello foo bar
This would greatly help in reconstructing broken threads, since hashes are obviously unfortunately one-way tickets. The URL/timestamp would not be used for threading, just for discovery of feeds that you donāt already follow.
I donāt insist on including the timestamp, but having some idea which feed weāre talking about would help a lot.
š§® USERS:1 FEEDS:2 TWTS:1326 ARCHIVED:86801 CACHE:2903 FOLLOWERS:22 FOLLOWING:14
š§® USERS:1 FEEDS:2 TWTS:1325 ARCHIVED:86778 CACHE:2902 FOLLOWERS:22 FOLLOWING:14
š§® USERS:1 FEEDS:2 TWTS:1324 ARCHIVED:86731 CACHE:2910 FOLLOWERS:22 FOLLOWING:14
Knoxville Long Run: 12.00 miles, 00:09:47 average pace, 01:57:23 duration
no clue where i was going. found something called dogwood trail so just followed the arrows and tried not to stress the hills.
#running
š§® USERS:1 FEEDS:2 TWTS:1323 ARCHIVED:86698 CACHE:2903 FOLLOWERS:22 FOLLOWING:14
Interesting factoid⦠By inspecting my āfollowersā list every now and again, I can tell who uses a client like jenny, tt or any other client where fetches are driven by user interactions of invoking the app. What do we call this type of client? Hmmm š¤ Then I can tell who uses yarnd because they are āseenā more frequently š¤£
@kat@yarn.girlonthemoon.xyz saving you a bookmark:
The following flags no longer exist:
--max-cache-items
--max-cache-ttl
Instead use --max-age-days, which controls how much of the cache is pulled back for Timeline, Discover and Mentions views.
š§® USERS:1 FEEDS:2 TWTS:1321 ARCHIVED:86594 CACHE:2833 FOLLOWERS:21 FOLLOWING:14
Hereās an example of what you end up with (I donāt follow the feed, but itās in my podās cache) 
cacher branch? š¤ It is recommended you take a full backup of you pod beforehand, just in case. Keen to get this branch merged and to cut a new release finally after >2 years š¤£
@prologic@twtxt.net i can give it a try MAYBE, iāve been super busy and all over the place but i will put it on my task list to try to remember! do you have upgrade/migration instructions anywhere that i can follow?
Zalmotek RA6M1, RA8M1, and RZ/A3UL Feather SoMs Target High-Performance Embedded Applications
Zalmotek expands its Feather System on Module portfolio with high-performance options designed for advanced embedded systems. These modules are based on Renesas processors and follow the Feather form factor, enabling flexibility for robotics, industrial control, and edge computing applications. The RA6M1 Feather SoM features an Arm Cortex-M4 CPU operating at u ⦠ā Read more
@andros@twtxt.andros.dev Thanks! š Just re-followed @important_dev_news@n8n.andros.dev š
Zalmotek RA0E1, RA2E1, and RA4M1 Feather SoMs for Energy-Efficient Embedded Development
Zalmotek offers a range of Feather SoMs built around Renesas microcontrollers, targeting energy-efficient and compact embedded applications. These modules follow the Adafruit Feather form factor and include essential interfaces for rapid prototyping and deployment in IoT and low-power scenarios. The RA0E1 Feather SoM is designed for ultra-low-power use cases. It features ⦠ā Read more
š§® USERS:1 FEEDS:2 TWTS:1320 ARCHIVED:86540 CACHE:2803 FOLLOWERS:21 FOLLOWING:14
š§® USERS:1 FEEDS:2 TWTS:1319 ARCHIVED:86501 CACHE:2810 FOLLOWERS:21 FOLLOWING:14
twtxt.net feels very clear of late hmmm š§ This is good right? š
@prologic@twtxt.net The number of āfollowersā I had also dropped significantly. š Looks like there were lots of dead accounts.
Fine ā I could
Copenhagenās Fine follows up one of the best albums of last year with intoxicating new single ā I couldā, out today via escho⦠Continue reading⦠ā Read more
Bunnings strikes deal addressing concerns of āterrifiedā plant growers
Bunnings plant suppliers will now have written agreements under a new statement of principles designed to protect growers, following complaints about the hardware giant during last yearās supermarket inquiry. ā Read more
š§® USERS:1 FEEDS:2 TWTS:1317 ARCHIVED:86476 CACHE:2798 FOLLOWERS:20 FOLLOWING:14
KitchenOwl
Until recently, my fiancĆ©e and I used Bring! to manage a list of groceries, we need to buy. Recipes we saved in a Telegram channel, pinning those we want to do in the following days. ā Read more
Testing mentions, immediately followed by commas. Letās see: @prologic@twtxt.net, this one is local, it might not break. Now, this one @ isnāt local. Nor this @ one. Will they break. Letās find out!
@prologic@twtxt.net @andros@twtxt.andros.dev You can delete these feeds (created by me):
https://feeds.twtxt.net/project26/twtxt.txt
https://lor.sh/@Katze_942.rss <- iām added him but canāt find file
the only rss i follow is https://feeds.twtxt.net/posts-from-atdarkcat09atdc09-ru/twtxt.txt
š§® USERS:1 FEEDS:2 TWTS:1316 ARCHIVED:86446 CACHE:2799 FOLLOWERS:20 FOLLOWING:14
Letās give PRO/VENIX a barely adequate, pre-C89 TCP/IP stack (featuring Slirp-CK)
Only a few weeks ago, I linked to Cameron Kaiserās excellent deep dive into the DEC Professional 380 running PRO/VENIX, and now we have a follow-up. Fortunately, today we have AI we have many more excellent and comprehensive documents on the subject, and more importantly, weāve recently brought back up an oddball platform that doesnāt have networking either: our DEC Profess ⦠ā Read more
Synology confirms that higher-end NAS products will require its branded drives
āSynology-branded drives will be needed for use in the newly announced Plus series, with plans to update the Product Compatibility List as additional drives can be thoroughly vetted in Synology systems,ā a Synology representative told Ars by email. āExtensive internal testing has shown that drives that follow a rigorous validation process when paired with Synology systems are ⦠ā Read more
@andros@twtxt.andros.dev Ahh cool! Iāll try following it again 𤣠Mind @-mentioning/linking@twtxt.net the feed again? š
yarnd UI/UX experience (for those that use it) and as "client" features (not spec changes). The two ideas are quite simple:
Iād have to write i up in full, but essentially looks a bit like this (contribived examples follow)ā¦
(#6kkpdda) Iād have to write i up in full, but essentially looks a bit like this (contribived examples follow)ā¦
Iād have to write i up in full, but essentially looks a bit like this ( contribived examples follow)⦠ā Read more
š§® USERS:1 FEEDS:2 TWTS:1315 ARCHIVED:86386 CACHE:2781 FOLLOWERS:20 FOLLOWING:14
@prologic@twtxt.net Since you have to check and double check everything it spits out (without providing sources), I donāt find any of this helpful. Itās like someoneās in the room with you and that person is saying random stuff that might or might not be correct. At best, it might spark some new idea in your head and then you follow that idea the traditional way.
Information published on the internet (or anywhere, for that matter) was never guaranteed to be correct. But at least you had a āframe of referenceā: āAh, I read this information about Linux on a blog that usually posts about Windows, so this one single Linux post might not necessarily be correct.ā That is completely lost with LLMs. Itās literally all mushed together. š¤·
AI isnāt a shortcut for thinking. In her guide for skeptics, Hilary Gridley reframes AI as a collaboratorānot a replacement. Use it like spellcheck for your thoughts. Donāt fear itāiterate with it. Insight improves, speed follows. Full post: https://hils.substack.com/p/the-ai-skeptics-guide-to-ai-collaboration
AI isnāt a shortcut for thinking. In her guide for skeptics, Hilary Gridley reframes AI as a collaboratorānot a replacement. Use it like spe ā¦
AI isnāt a shortcut for thinking. In her guide for skeptics, Hilary Gridley reframes AI as a collaboratorānot a replacement. Use it like spellcheck for your thoughts. Donāt fear itāiterate with it. Insight improves, speed follows. Full post: https://hils.substack.com/p/the-ai-skeptics-guide-to-ai-collaboration ā Read more