tburkhol

Is the topic of financial/trading tools just completely off-limits here, even if it’s AGPL and self-hosted?

Not necessarily. The platform (lemmy, not just c/selfhosted) is full of anti-corporate leftists and anarchists. You’re more likely to find people who want to burn the stock market to the ground than to participate in it, esp highly speculative algo trading.

I’ve seen plenty of people ask about self-hosted personal finance or portfolio tracking, so there are people for whom your project might be relevant. Just seems more like a r/wallstreetbets kind of thing than a lemmy kind of thing.

If you’re in the Western hemisphere, NOAA has every-5-minute satellite images, using the form

cdn.star.nesdis.noaa.gov/GOES16/…/600x600.jpg

www.star.nesdis.noaa.gov/GOES/index.php will help you pick which SECTOR is most relevant.

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?

A records return the numerical address of a name.

CNAME returns a different name for a name. Basically ‘synonym’ so the maintainer only has to change the one master, A record when the IP address changes. Convenient to use CNAME to point www.example.com to example.com, but you can use it just as well to point example.com at my.private.host.xyz You can even chain multiple CNAMEs to make it easier to manage a complex backend structure while presenting a simple address to users.

Uncheck “Send notifications to Email” in your settings. Or get a 3rd party app with a notifications setting.

Could they be astroturfing, looking for a specific solution to fill search engines with their own product placement, then deleting because most of the comments are other FOSS solutions?

I added homeassistant and some power monitors to my stack, and the IT rack comes in around 1.5 kWh/day - one of the biggest power budgets in the house, even with a low-power CPU, after adding in a few HDDs, a couple switches, and the cable modem. I’m also in a cheap power state, so it’s not a financial pressure, just surprising how quickly 10W here, 10W there….add up. At $0.50/kWh, I’d think solar would be a no-brainer.

Keep power in mind. For most home-use services, you don’t really need much computing power, and you might be able to do all you want with a single box. Even 30W, 24/7 is $25 (@10¢/kWh)-125(@50¢)/year of electricity. That said, it’s a small price to learn how to do clustering or swarms.

I’d guess that your biggest load would be transcoding in Jellyfin, for which Intel Gen 6 added h265 to quicksync. The Gen 3/4 CPUs in M73 would be extra slow with most modern codecs.