• 1 Post
  • 73 Comments
Joined 1 month ago
cake
Cake day: May 1st, 2026

help-circle
  • I started doing the One True Database method because I got worried that the high write count on all the little db’s was abusing a raspberry pi’s SD card. Moved them all to a bigger server with NVME and mirroring to a RAID.

    Not all the compose files make obvious how to reconfigure the db host. Homeassistant uses s a sqlite db built into the container, rather than a separate unit, but you can force it to use a remote db through its config file. May or may not be worth hiding db user/pass in a .env And sometimes there’s trouble restarting after power failure, depending on what order the database, pi, and various containers come back up.

    I also feel it’s worthwhile. I feel better being able to check on all the databases. Feel better not writing to the SD card so much. Feel better offloading those megabytes and cpu cycles from the little pi. It’s been fun snooping through database structures. There have been a couple times where I decided to query one of the ccontain databases directly, or cross from one project to another, and it’s easier (for me) to give a different user privileges to the database and query some deep bit of data than to figure out how to extract it from an API or frontend.

    I’m not even running that many services, but why would I want the overhead of 6 separate mysql instances when I could just have one?


  • It seems like it should be possible to build keyboard (and other) peripherals that exist in both virtual and physical worlds. Give them sensors similar to the hand controllers, so the headset can know where they are in space, project into VR so it’s easy to find and use.

    VR handsets are incredibly flexible as spatial controls, but we’ve got all this evolution and a lifetime of learning just amazing finger dexterity. That control is based more on tactile and proprioceptive feedback than visual, so I think it’s been overlooked in the vision-focused VR space.








  • Here in Georgia (US), as recently as last summer, there was tons of wildlife noise when I’d open my windows at night. I couldn’t Identify most of it…just your usual call-and-response mating behavior, an owl once in a while. This year, it’s just dead silent. Daytime is almost as striking, but that’s because last year was locusts.


  • The US spent a lot of money on soft power, essentially bribing countries to go along with their agenda. Much of that money did actually improve people’s lives, whether it was food aid, vaccinations, or AIDS care. Sure, it was to further their own objectives. Sure, it’s mostly because it’s cheaper to buy compliance than to bomb people into compliance. Humanitarian aid with strings attached is still humanitarian aid, though, or the collapse of USAID wouldn’t be such a problem.


  • In Alabama, when they were considering bans on youth transgender therapy, one of the GOP senators made them do a study. It turned out that over the past decade there were, on average, something like 5 minors undergoing any kind of gender-affirming treatment. 5. In the whole state of Alabama. They decided it wasn’t worth implementing a whole government oversight system to oppress that few people.

    Now think about how many of the people, under 18, are both self-aware enough to realize they’re trans-fem (because no one raises a fuss about trans-masc athletes) and super excited about competing in women’s sports. We are talking about a handful of people across the whole country.

    And that’s what makes them such a great wedge issue for the right. Essentially no one has personally encountered a transgender youth athlete, so they can make up whatever stories they like, based on “sounds reasonable.”

    Meanwhile, competitive sport is essentially all about rewarding genetic freaks. People with some gene mutation that lets their muscles work faster, lets their blood carry more oxygen, lets the build mass faster. If you worry about the biological advantage that a chemically suppressed hormone might have, you’re starting down a path where you have to police what other biological traits might give someone advantage. It’ll be “too tall to compete in basketball.”




  • The very broad funds definitely will - VTI/VTSAX - but at lower weights and under less time pressure than the rigid index funds (VOO/VFIAX). That takes off a lot of the liquidity squeeze and (presumably) reduces their loss.

    But you have to remember that people who use these funds intentionally invest in obvious losers and willingly overpay for hyped stocks because they believe, in the long run, that buying obvious losers is more than balanced by also buying the unexpected winners.

    SpaceX is just the first time an oligarch tried so obviously to rig the passive investor structure to his favor, and I’m glad the S&P people didn’t cave.


  • When it comes to general elections, even the corporate Dems tend to be better than the Republicans. I mean, if the corpos are out there avoiding any solutions, the GOP is actively trying to harm people, and “nothing” is better than “more boots to the ass.” If the last three Presidential elections show anything, it is that the Democratic party will not be fixed by withholding general election votes in protest, and third parties are still irrelevant.

    The time to fix the Democrats is in the primaries. The people to fix those primaries are people who would really rather vote for a radical 3rd party candidate. Many states have open primaries, so third party voters can just go vote in the Dem primary. Treat it like sabotage. The right-wing nutjobs took over the republican party. Left wing nutjobs can take over the democrats, if they show up. Mamdani doesn’t have to be a black swan.


  • My question for the Democratic leadership is: Why can’t they find any decent candidates? Seriously: the Senate race against Susan Collins ought to be a Dem gimmie, and the best they can do is Graham Platner? I don’t even care if the dude is fully reformed and now a shining beacon of progressivism, there’s literally millions of alternatives without questionable histories. Where are all these angry pro-social, anti-war, climate enthusiasts when it’s time to put in the work to run against some Republican shitbird?

    Where are all the Zihran Mamdanis and Kat Abughazalehs? Why wouldn’t Dan Osborn run as a Democrat?