I’m beautiful and tough like a diamond…or beef jerky in a ball gown.

– Titus Andromedon

  • 108 Posts
  • 477 Comments
Joined 1 year ago
cake
Cake day: July 15th, 2025

help-circle








  • Hank Hill, apparently.

    I don’t use Facebook and use all the ad blockers, but apparently I’m still tracked by IP.

    When my SO and I started dating, he hooked to my wifi one day and immediately started getting ads on Facebook for various lawn care products. He’d never had those come up before, lived in an apartment all his adult life, and has never searched for any kind of gardening supplies.

    I, on the other hand, do have a lawn that I take care of and frequently shop for various landscaping stuff. But he gets the ads for them.





  • Twice a year I fill in as DBA when our lady graybeard Oracle DBA takes vacation. This month is one of those times. Yay me.

    For my org, it’s just the massive in-house developed line-of-business application that’s tightly coupled to Oracle that keeps us chained to it. It’s technical debt from top to bottom, and has been accumulating steadily since the early 2010s, but no one seems willing to start replacing it.

    The new projects typically go with Postgres, MariaDB, or if all else fails, MSSQL. But the Oracle monster in the closet isn’t likely to leave any time soon.






  • The only tricky bit is forcing the Pi’s USB port into host mode by default. I thought the hub was defective but it worked when I put an OTG adapter into the micro USB port. The default auto detect behavior doesn’t work with this since it doesn’t connect to the OTG pin.

    I had to edit /boot/firmware/config.txt and add under the [all] section:

    [all]
    dtoverlay=dwc2,dr_mode=host
    




  • All of the labor has been DIY, and I’ve got about $9,000 invested in the system components.

    Back of the napkin math, at current electric rates, puts my ROI at just under 9 years. If electric rates keep going up, it’ll pay back even faster.

    Edit: Depending on how you look at it, ROI could be in as few as 1.5 to 2 years. This system is in lieu of a whole house generator that would have cost us about $7,000. Had we gone with that instead, it would never have paid for itself (other than peace of mind) and we would have been perfectly content. So if I’m only considering the price difference between this and the generator, it’d only have to pay back $2,000.


  • Be careful. Those things are addicting.

    That’s how I started: a little 5v, 6 watt panel I stuck in the window to charge my phone while I worked. Then I wanted to charge some other stuff, so I got a 15W panel. 15w panel was nice, but 100 watts was much better, so I bought two 100W fold-up panels like you’ve got.

    Then I bought a big 1 KWh power station that could supply up to 2000 watts. I take it camping and charge it from the two 100W fold up panels.

    But, sadly, the demon had its claws in me and refused to let go. “Why should I only use that solar power two or three times a year?” the voice said. So I bought 4x 200 watt panels so I could use the power station to power my homelab and refrigerator during the day.

    Still, that wasn’t enough to satiate my addition. Now I’ve got 4 KW on the roof, 32 KWh of house battery, and a 10 KW inverter that is currently powering our house.

    Am I satiated now? Only time will tell.