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

– Titus Andromedon

  • 287 Posts
  • 1.28K Comments
Joined 1 year ago
cake
Cake day: July 15th, 2025

help-circle



  • 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
    











  • The usable south-facing roof area is full, unfortunately. I’ll have to do ground mount in the back yard and run a bunch of conduit if I want to add any more PV.

    The 32 kWh of batteries are made of two 16 kWh batteries in parallel. Since this system is in lieu of a backup generator, I have it configured to only draw the batteries down to 50%. That leaves the bottom 16 kWH available for emergency use. Basically, for day to day usage, I treat the battery as being half the capacity it really is.

    I’ve only been running this system for about 3 weeks now, but the batteries have been operating between 65% and 90% pretty consistently even running the A/C pretty heavily. They’ve been closer to low 60s this past week, but the wildfire smoke was choking out the sunlight Thursday and Friday.