@algernon This is an amazing thread!
I will be interested to hear where you end up.
I went for a very minimalist theme, as I really just wanted words on a page.
@neil It'll be a while I get there. I came to the conclusion that I'll deal with This™ during the holidays when I'm less stressed out.
You can add a constraint in two parts with PostgreSQL: one for new data being added (not valid) and then later you can do `alter table ... validate constraint` to ensure that historical data is validated.
I would have loved this in MySQL for making fields UNIQUE, something that was extremely toil-filled when I worked at Shopify.
Anyway, I've added those 9 as NOT VALID so that we don't add _new_ invalid data, to give me a chance to clean up.
I wrote a simple query to find the `media_attachments` which are referencing accounts that no longer exist on our server. This took a long time, so I went to Home Depot to buy stuff I need for an IRL project.
I got a text message to my phone about the chassis being too warm 😅 -- when I came back an hour later it hadn't finished.
Then I rewrote the `IN` to be a `LEFT JOIN` and it ran in 9 seconds. Still got it.
Some tables are bigger so I'll be carrying on this evening; just thought I'd share.
You know what? Here goes nothing: we need $200 for groceries, $500 for loan payments, and $500 for a past due hospital bill. That's $1200 that I'm going to try and raise, but probably won't get 😞💕💸
CA: cash.app/$BlueEyedAshh
PP: paypal.me/ashleyspend
#mutualaid #MutualAidRequest #MutualAidBoost @MutualAidBot @mutualaid @mutualaidspace
@libreleah I switched to vim-classic about a month ago when it entered #ChimeraLinux 's cports repo https://github.com/chimera-linux/cports/tree/master/user/vim-classic
@TheOneDoc the best thing about vim-classic is that it's extremely boring; all it does it give me the exact same Vim that i've always used. it looks and feels exactly the same as the Vim version that i had until ten minutes ago. that is literally the best thing about vim-classic. it's the main feature, in fact.
Watching “The Altruists.” It’s fine, but the message of this show is clearly: “It’s gross and weird when nerds get horny.”
I didn’t think it was possible, but as obnoxious as Sam Bankman-Fried and Caroline Ellison are portrayed as being in this show, Will MacAskill comes off even worse.
Posted in
Technology
Signal slams door on prying AI agents to protect privacy
Apple, Google, and Microsoft called out for failing to provide developers with adequate AI agent controls
Posted in
Technology
GrapheneOS claims Google is now waging war against it, could lock Pixel bootloader
GrapheneOS leadership claims Google is trying to wipe it out and is even threatening OEMs.
@jamey I'm interested to see how it plays out! I'm a bit of a VLIW apologist because of the Mill, but when's the last time you've heard from Ivan Goddard? Sigh 🙁
@MaddieM4 I hadn't heard of the Mill, and reading up on it, there's a lot I'm curious about! What's your connection to that work?
So, some follow up -- during the restore from backup 9 foreign key constraints failed to apply.
This is due to work that I undertook in March 2023 after I lost some data and had to sketchily restore it into a running instance: https://tiny.tilde.website/@insom/110030644607199692
To do that, I relaxed FK constraints and, to the surprise of no-one, some invalid data is there.
Three years later I am fixing this up! I've learned about NOT VALID CONSTRAINTS since then, from my work at Slice.
You can add a constraint in two parts with PostgreSQL: one for new data being added (not valid) and then later you can do `alter table ... validate constraint` to ensure that historical data is validated.
I would have loved this in MySQL for making fields UNIQUE, something that was extremely toil-filled when I worked at Shopify.
Anyway, I've added those 9 as NOT VALID so that we don't add _new_ invalid data, to give me a chance to clean up.
In einem kurzen Monent der Unaufmerksamkeit überschritt diese mobile Infiltrationseinheit die Grenze und besetzte mehrere Quadratmeter Bettdecke. Sie hat jetzt ihre Position konsolidiert und erhebt weitere territoriale Ansprüche (Pfote).
@Fischblog Oh. Ein Vollprofi in der Gebietserschwindelung!
RE: https://mastodon.social/@hsivonen/117653407279770008
Also, don’t put anything into LLMs.
aaanyway, now that I'm done with Libreboot for the year (I'm not doing any new Libreboot development until probably February 2027 - the Libreboot 26.11 shall suffice for now)
Yes, anyway and now that I dealt with that troublemaker earlier too... yes, everything is perfect now. Just got business stuff for the rest of the year.
Oh my god, yes, finally I will talk about someone elses project for a change:
Drew Devault launched this recently. It's a de-slopped fork of Vim. I mean I use Vim on Debian 13 so probably no AI in my Vim yet, but I plan to switch my main over to OpenBSD at some point. I'll definitely be giving Vim Classic a go. I love Vim. Vim is the best editor ever.
RIP Bram
anyway Drew is keeping Bram's legacy alive by maintaining a good version of Vim. Without all the extra bloat that's being added to it these days. One of the things I like about Vim when Bram was alive was Bram's overly conservative vision for the project.
i now use vim-classic:
@libreleah I switched to vim-classic about a month ago when it entered #ChimeraLinux 's cports repo https://github.com/chimera-linux/cports/tree/master/user/vim-classic
Just saw this
https://www.kickstarter.com/projects/inmachines/piccola-cnc
looks like a solid open addition to the maker workbench
#cnc #dyi #opensource
Had I worlds enough and time, I’d trace the history of “person ends up at obviously haunted castle and horror happens” through Dracula and Crimson Peak and Mexican Gothic and Sour Cherry
@amin @jak2k re: Jr, that "render the site in the browser" thing: there's a certain charm in having easy access to the site source.
That's why git clone https://chronicles.mad-scientist.club works too.
But as much as I like the idea of publishing the source and letting the browser render it - that's a fun idea, but horrible for visitors in practice, imo.