I can skip the search engine and go right to the bad suggestions, finally!

I use vim keybinds (via doom emacs) for this sort of stuff if I’m doing it for personal projects, my professional work is all done in an online platform (no way around it) so it’s just faster and easier to throw the pattern and columns at the integrated chatgpt terminal rather than hop to a local editor and back

I use chatgpt semi-often… For generating stuff in a repeating pattern. Any time I have used it to make code, I don’t save any time because I have to debug most of the generated code anyway. My main use case lately is making python dicts with empty keys (e.g. key1, key2… becomes “key1”: “”, “key2”: “”,…) or making a gold/prod level SQL view by passing in the backend names and frontend names (e.g. value_1, value_2… Value 1, Value 2,… Becomes value_1 as Value 1,…).

The religious marriage to rule them all: doom Emacs (or other packages that do similar things). All the excellent text editing of vi/vi/vi/vim, the ecosystem and all the features of emacs.

For anyone who hasn’t heard of doom Emacs, it’s emacs with a lot of customizations baked into it, one of the biggest selling points is that everything uses vim keybinds now (where it makes sense). You get the amazing ecosystem of emacs with the ease of movement and editing of vim, plus a lot of other QOL features. It’s also just vanilla emacs with pre-made (and easy to edit) config files and helper functions so you can move over existing stuff if you want, and you don’t have to worry since all the emacs packages will still work, since it’s still emacs

There are some really awful captchas out there. I miss the days of just typing out some stretched and tilted numbers and letters.

I always use i because I’m too lazy to type out iterator when I’m making my garbage spaghetti code that will support infrastructure for years

Same here, idc about some of my containers going through VPN (tandoor, gitea, Plex, etc) but my whole arr suite, qbittorrent, and sabnzbd are routed through a gluetun container that uses my protonvpn credentials. Never have to worry about turning my VPN off for gaming or something since the… totally legal research papager aquirerer apps… are all routes through the VPN which changes it’s connection every 4 hours (changes my public IP but also just to make sure none of the containers run into any issues that they can’t figure out without a restart)

Yep, their free servers are great for trying out the service and web browsing if you don’t it being slow, but none of the free servers are p2p enabled. Only paid servers have p2p

I only verify information I get on the Internet if I don’t agree with it or need to use it in an argument, and I’m not about to change

I don’t use readonly with dbeaver, but I do have the prod servers set to automatically make transactions and have to hit a button to commit. Almost certain it asks confirmation that I want to make the changes to prod which is nice too (I rarely have to touch our sql server prod)

I’m a data engineer that occasionally has to work in sql server, I use dbeaver and have our prod servers default to auto-wrap in transactions and I have to push a button and confirm I know it’s prod before it commits changes there, it’s great and has saved me when I accidentally had a script switch servers. For the sandbox server I don’t have that on because the changes there don’t matter except for testing, and we can always remake the thing from scratch in a few hours. I haven’t had an oppsie yet and I hope to keep that streak

In terms of electricity consumption, it’s still not going to be huge, just was noted in case you wanted to go smaller. You can almost certainly go smaller, but at the same time if you already have the hardware it’s not going to be useful to sell it second hand and buy new hardware that has less performance.

Hosting static websites at home is fine if you really want to, but for anything dynamic and/or that will have a lot of users, get a vps (basically a server that you pay for storage and compute resources on and can use remotely how you like, including hosting stuff like mastodon and lemmy instances)

I’m happy to help if anyone needs help with docker and/or Linux stuff. (I’ll probably try to convert you to Linux, the os to rule them all. You’ve been warned) Wont necessarily be everything or set it all up for you, but enough knowledge to get you started and able to learn more yourself is doable

For op, that setup is likely overkill, most stuff will use more ram than cpu and very few self hosted apps will use the GPU at all (Plex and jellyfin are the only ones that come to mind). Only hurt to it being overkill is a higher power usage than a smaller setup, but if you already have it running full time then it’s unlikely to make a different

Throw Linux on it or reinstall windows if you don’t want to learn Linux. I assume it’s a new PC, but you never know what may be on there regardless. A new install with a complete overwrite is the way to go imo.

For Linux, it personally use arch (btw) and love it but it’s not super beginner friendly. I’ve heard good things about Linux mint for beginners so that may be a good place to start

First ones that come to mind are:

https://www.bookstackapp.com/ - sets out your uploaded data like books. Can do books, chapters, pages, etc.

https://www.dokuwiki.org/DokuWiki - more standard wiki, also everything is stored in plain text so it’s easy to distribute and use source control on (no database backend)

https://tiddlywiki.com/ - full fledged wiki, bit different layout though since it’s all on one page. Clicking an internal link scrolls to that page so it’s pretty quick.

All are free and open source, almost certain they all have docker images too. I haven’t tried any of them but I’ve looked into them since I’ve been thinking about it

Pro tip: transactions are your friend

As much as I like fully self hosting, I ended up paying for Plex lifetime and have it running in docker. It was $120, but has already paid for itself twice over since I managed to convince my wife to drop hbo max, Netflix, and a couple others. She isn’t technical at all so she was hesitant, but she likes plex. If she can’t find what she wants to watch on our few streaming services (paid for by our cell provider, otherwise they’d be cancelled too), she can add it to the watchlist on Plex and radarr or sonarr will download it automatically and make it available on plex pretty quickly (or she’ll tell me to get it and let her know when it’s done).

I could open my Plex server to more family or friends, but most of them either pirate stuff themselves or are fine with paying for streaming services for the ease of use.

I use dashy since it’s super easy to update (can update and save config from the webpage). If you want automatic adding though, flame can autoadd services if you put a couple lines of config in each docker compose

That’s the idea I think

Honestly, has anyone been able to find ms paint bugs? It’s extremely stable too, reliability is king