My old laptop for self hosting just croaked, and I’m thinking of buying a 2nd hand mini pc, but this time I want to do it proper. I want to optimize the electricity consumption and specs needed/ future upgreadability, considering how expensive everything is now.
My use case is just for self hosting files (infrequent access and reducing reliance to google drive), and occasional dev workload via ssh. I’m thinking of buying a used optiplex with at least i6 gen cpu (SFF or micro form factor), but I want to see if there are better options.
There was a link posted in this subreddit about power consumption comparison of different mini pcs (raspberry pi, n100, etc), and I regret not saving it.
If anyone could suggest me better options it would be greatly appreciated. Thanks!


Sure, but the point of getting a mini-pc is usually not that you have an open case with a second ATX PSU sitting on top to power some extra hardrives.
Because you can buy something like this Sata drive enclosure: https://a.co/d/004sj6TS, and power it with a small ATX power supply.