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

– Titus Andromedon

  • 105 Posts
  • 380 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
    





  • We do lose power during the switchover. Same as if a backup generator were kicking in (a backup generator is pretty analogous to how I have this wired up currently)

    My WFH office, homelab servers, 3D printer, and the fridge are all on UPSs. Fridge is a long story, but a UPS has proven beneficial to deal with its Samsung-ness. Everything else doesn’t really care since it’s only a literal split second to make the switch.

    The only drawback to this manual switchover is the oven and microwave clocks are never right. But to be honest, even before we started switching over to solar every day, the power would flash almost as soon as we set them so we largely just ignore them. Side effect now is they’re both timers showing how long we’ve been on solar that day.

    Once I get it installed fully, there will be no cutover. It acts as an on-line UPS, essentially, and the only thing that changes is where the inverter is drawing it’s power (PV, battery, utility, or a combo of any of those). It also, supposedly, has a 10ms switchover time if it has to go into “bypass” mode to feed the load directly from utility input. 10ms is comparable if not the same as the switchover time on my other UPSs.


  • I’m in the US, lol, just not in a very solar-friendly area. The power company data I have access to is a side effect of both their green washing and constantly rising rates. It’s supposed to help you manage your bill more than anything else.

    The batteries and inverter I’m using are Eco-Worthy which is Chinese and available globally. The inverter itself is a re-badged SRNE and has proven to be reliable and well built. Not sure if they’ve passed EU certification, but they’re UL9540 and UL1973 certified in the US

    The HomeAssistant module was made for Solarman products but is compatible with others such as the inverter I have (which is itself a re-badged SRNE one).


  • The graph displayed is from the power company website. It’s showing the power I use from them (uploaded from the smart meter). The relevant bit there is the negative space where I’m not using any utility power.

    For local monitoring of the PV system, I don’t have anything yet except for the counters displayed on its LCD (see below).

    The inverter has a smartphone app and wifi-module but that requires creating an account and letting it upload stats to a 3rd party server which I will never allow. However, it also has a serial port and speaks the Modbus protocol, and it’s pretty well documented.

    There’s a HomeAssistant plugin (ha-solarman) that I’m going to setup when I have time. That’ll pipe the inverter stats to a HA dashboard and can also let me change some of the config options from there instead of having to go to the inverter’s panel and set individual parameters.

    Sorry it’s blurry, but had to snap it quick since the display runs in kind of a carousel between different values. It’s showing here that I’m getting 2.3 KW from PV right now, one phase of the output is 0.1 KW (the other is 0.9 KW; it displays them separately), the battery is at 53.6 volts and is being charged, and I’ve generated 267.3 KWh since I installed it. The utility input is disconnected so there’s no arrows coming from it.






  • Ugh, I wish I could add “reasons” for my user blocks as well as have the dates I blocked them available. Would make this easier. But yeah, Striker is in there.

    I’m inclined to believe it’s part of the “group”. Every post I can see of it’s is a question which is the same thing seen with the others in the list here; none of them have a single post that uses a declarative statement as the post title. That’s more than a little sus given the context here.

    Regardless, I tend to block accounts that I feel camp out and/or abuse the “ask” communities.