HelloRoot

Remote Tech Support services?

6h 29m ago in selfhosted

Rustdesk is what I use for tech support for my family. By default it uses the rustdesk official server for the handshake and holepunching or whatever, but you can also selfhost your own if you want to.

But I want to migrate to some kind of hardware web kvm like nanokvm, cause sometimes their pc doesn't boot and walking them through bios settings over a shaky videocall is a nightmare.

The Year of Linux

2d 6h ago in linux@programming.dev from europe.pub

A lot of chinacrap on amazon had that for decades.

Saw it for all kinds of normal USB gadgets. Absolutely meaningless label.

Software Is Not A Single-Player Game

2d 16h ago in programming@programming.dev from www.davidpoll.com

That aesthetic made me vomit.

what is the intuition behind the window functions in sql?

2d 20h ago in programming@programming.dev

Think of window functions as a two-layer operation:

Layer 1: Produce all the rows (FROM, WHERE, GROUP BY, HAVING)

Layer 2: For each row, peek at its "neighborhood" (partition) and compute something

The result of Layer 2 is just another column added to each row. Nothing collapses, nothing gets removed. You just get extra computed values based on context and that context is what PARTITION BY, ORDER BY, and the frame clause define.

portmaster can turn off internet for a specific app, but even better it can block specific domains

actually just putting the website domain (with local ip or something) into hosts file will be enough

Quality gate as a solution?

5d 13h ago in programming@programming.dev from jeferson.me

Thats pretty much how the company I currently work at does it.

Multi-material joints

5d 21h ago in 3dprinting

I think the interface will be difficult to print. If the underside is smooth, the non sticking material might not stay in place. If the underside is rough ... well then you have a joint with at least one rough spot in it's rotation. Thats just from thinking about my experience with using pla with petg supports (and vice versa) so it may be better than I expect. Depending on the usecase, I think it might work.

But I think it's easier to print a joint in place from a single material and then "snap" it so it moves. Or design something where you print the parts seperately and then assemble.

OSM mapping with a small revenue?

6d 16h ago in opensource@lemmy.ml

I don't think so.

Probably best you can do is make a blog, a youtube channel or something like that and set up donations.

Doorbell Camera / NVR (post Unifi)

7d 2h ago in selfhosted

I have an alcatel lucent switch from the 90s

It's been running 24/7 for 25 years in some companys rack and now it runs for 10 in mine.

Got it for 30$ on ebay (and a second one for 20 as a backup)

What's the current reliable password manager?

8d 8h ago in linuxquestions@lemmy.zip

i use syncthing for syncing my keepass files

I Put a Datacenter GPU in My Gaming PC for £200

10d 18h ago in localllama@sh.itjust.works from blog.tymscar.com

Ringtonez for the mobilek

3mon 26d ago in funhole@lemmy.sdf.org from lemy.lol

ChatGPT 4.5 alternative

10mon 13d ago in llm