Hawk
@Hawk@lemmynsfw.com
- Comment on Kid gave a reasonable answer without all the math bullshit 5 hours ago:
Yeah, most pizzerias sell many sizes. Both answers are valid.
In fact, i would argue making an assumption, in this case about size, without declaring it, is in fact less reasonable.
- Comment on Meta shareholders overwhelmingly rejected a proposal to explore adding Bitcoin to the company's treasury, with less than 1% voting in favor of the measure 1 day ago:
One can buy weed with crypto. I can’t do that with a bank card.
I guess, not everyone wants a centralised currency
- Comment on Discord unveils Discord Orbs, a new in-app currency that users can earn by completing Quests, which reward participants who interact with ads 5 days ago:
Unfortunately, the official desktop app is essentially unusable.
Fractal is pretty good but less features.
- Comment on Let's play this game again 1 week ago:
Social Obligation.
- Comment on ChatGPT does not fuck around 2 weeks ago:
IP could potentially be accessible through tool use?
Not sure, but not impossible.
- Comment on I’m very good at math and would like health insurance. What is the easiest option? 2 weeks ago:
Electrician or construction. No money at all in data, tech, software etc.
- Comment on A Judge Accepted AI Video Testimony From a Dead Man 3 weeks ago:
Yeah this wasn’t ratio or even obiter, perhaps convention. Without looking deeper this was along the lines of an impact statement. Whilst it raises points for discussion its a far cry from precedent for the admission of evidence.
- Comment on sus 4 weeks ago:
Must be nice in that small section of western Europe. For the rest of us things are not so blissful.
- Comment on That's all folks, Plex is starting to charge for sharing 4 weeks ago:
Tail scale already has a bunch of limitations for unpaid users but it’s only an extra step to set up wireguard in a container.
- Comment on What OS should I use for self-hosting that doesn't require extensive terminal knowledge? 5 weeks ago:
Honestly, I’ve had little trouble. The Gentoo Wiki and Void Handbook have a lot of overlap with OpenRC and musl, respectively.
While the documentation could be improved, the overall experience has been quite good and very stable.
- Comment on What OS should I use for self-hosting that doesn't require extensive terminal knowledge? 5 weeks ago:
I’m not trying to be unhelpful. My advice would be to steer into the terminal. Bite the bullet. I use arch and alpine for my servers but Fedora would be fine (but SELinux can be a pain with bund mounts)
Probably just go with Fedora with btrfs for snaps. It has lots of support and is a common choice for servers
- Comment on How to secure Jellyfin hosted over the internet? 2 months ago:
Wireguard (or tailscale) would be best here.
- Comment on Microsoft's many Outlooks are confusing users and employees 2 months ago:
I think the parents suggestion was to not use it.
However, it’s a bit like avoiding water on a boat given how pervasive the cancer is.
Most of the MS suite is pretty awful. OG OneNote was a good idea. VSCode is ok, just quite slow. Oh LSP is fantastic, I believe that was developed by MS.
The Office Suite and PowerBI are terrible, by 2025 standards it’s glossy trash.
- Comment on Europe is looking for alternatives to US cloud providers 2 months ago:
Yep. mid size business is the best place to be for engineers. You get your pick Of the lot all without HR 🙃
- Comment on Google Chrome disables uBlock Origin for some in Manifest v3 rollout 3 months ago:
See also Mull, No 120hz though.
- Comment on Google Chrome disables uBlock Origin for some in Manifest v3 rollout 3 months ago:
Also, I don’t think one can export bookmarks from Android Firefox either.
- Comment on Google Chrome disables uBlock Origin for some in Manifest v3 rollout 3 months ago:
Some js is a bit slower. I typically use chrome for self hosted apps, jupyter etc.
I think wasm performance is actually better in Firefox though.
- Comment on HP ditches 15-minute wait time policy due to 'feedback' 3 months ago:
I see we have the same managers. Were you also advised that public facing databases were better than an API in a VPC and that 1 password shared among colleagues is easier than managing credentials?
Don’t worry, I found a new gig starting in a few weeks (out of the pot into pan )
- Comment on Which reverse proxy do you use/recommend? 3 months ago:
Set up wireguard in a docker container and then forward the port to wireguard, the default container on docker hub is fairly straightforward and you can always ask me for help if you need :).
However, If you are using ipv4, you need to make sure that you’re not behind a CG-NAT (If you think you might be, call your ISP and tell them you have security cameras that need to get out or something like that).
You could also try tailscale which is built using wireguard with nat-busting features and a bit easier to configure (I dont personally use it as wireguard is sufficient for me).
After that Caddy + DNSMasq will simply allow you to map different URLs to IP addresses
dnsmasq
- will let you map, E.g.
my_computer
->192.168.1.64
- will let you map, E.g.
- Caddy (Or nginx, but caddy is simpler)
- will let you map to ports so e.g.:
- with DNS (DNSMasq as above)
http://dokuwiki.my_computer
->http://my_computer:8080
- Without DNS
http://dokuwiki.192.168.1.64
->http://192.168.1.64:8080
- with DNS (DNSMasq as above)
- will let you map to ports so e.g.:
Caddy and DNSmasq are superfluous, if you’ve got a good memory or bookmarks, you don’t really need them.
VPN back into home is a lot more important. You definitely do not want to be forwarding ports to services you are running, because if you don’t know what you’re doing this could pose a network security risk.
Use the VPN as the entry point, as it’s secure. I also recommend running the VPN in a docker / podman container on an old laptop dedicated just to that, simply to keep it as isolated as you can.
Down the line you could also look into VLan If your router supports that.
I personally would not bother with SSL If you’re just going to be providing access to trusted users who already have access to your home network.
If you are looking to host things, just pay for a digital droplet for $7 a month, It’s much simpler, You still get to configure everything but you don’t expose your network to a security risk.
- Comment on Which reverse proxy do you use/recommend? 3 months ago:
If you’re just going to VPN in to your home network, I’ve found caddy to be the simplest.
- Comment on Reddit plans to lock some content behind a paywall this year, CEO says | Reddit executives also discussed how they might introduce more ads into the social media platform 3 months ago:
There’s nothing on Reddit anymore. It’s really unfortunate but I don’t see how this is going to help them regain any consistent user base.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 months ago:
I’ve had a poor experience with btrfs dedupe tbh (and a terrible experience with qgroups), however, this was years ago. Btrfs snapshots I prefer though, much easier not to have that dependence.
What distro are you using for ZFS, void?
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 months ago:
Fair point, I’ve edited the answer to be clearer for future readers.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 months ago:
Well Ive ad a great time using LLMs to sandbox a dozen implementations and then investigate the shortcoming and advantages of different implementations.
Mistakes happen a lot but they can be managed on a small MWE with a couple of tests.
It’s how the tool is used more than any given tool being bad.
I understand your point and you’re not wrong. However, I’m not wrong either and you should take a second look at how you might use these tools in a way that makes your life easier and addresses the valid limitations you’ve described.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 months ago:
I disagree, it’s just a tool. It’s a fantastic way to template applications very quickly, particularly for those who are not already familiar with technologies and may not have the time or opportunity to play around with things otherwise.
Llm is not a search engine and it can produce awful code. This is not production code, it’s for tinkering. As a sandbox tool, LLMs are fantastic.
On the ethical side of things, yeah openAI sucks, Qwen2.5 would be up to this task, one can run that locally.
- Comment on How does this pic show that Elon Musk doesnt know SQL? 3 months ago:
Its because the contents he made are inconsistent with common conventions in data engineering.
- It is very common not to deduplicate data and instead just append rows, The current value is the most recent and all the old ones are simply historical. That way you don’t risk losing data and you have an entire history.
- whilst you could do some trickery to deduplicate the data it does create more complexity. There’s an old saying with ZFS: “Friends don’t let friends dedupe” And it’s much the same here.
- compression is usually good enough. It will catch duplicated data and deal with it in a fairly efficient way, not as efficient as deduplication but it’s probably fine and it’s definitely a lot simpler
- Claiming the government does not use SQL
- It’s possible they have rolled their own solution or they are using MongoDB Or something but this would be unlikely and wouldn’t really refute the initial claim
- I believe many other commenters noted that it probably is MySQL anyway.
Basically what he said is incoherent to anybody who has worked with larger data.
In terms of using SQL, it’s basically just a more reliable and better Excel that doesn’t come with a default GUI.
If you need to store data, It’s almost always best throw it into a SQLite database Because it keeps it structured. It’s standardised and it can be used from any programming language.
However, many people use excel because they don’t have experience with programming languages.
Get chatGpt to help you write a PyQT GUI for a SQLite database and I think you would develop a high level understanding for how the pieces fit together
- It is very common not to deduplicate data and instead just append rows, The current value is the most recent and all the old ones are simply historical. That way you don’t risk losing data and you have an entire history.
- Comment on Digital management post-life 3 months ago:
I think this combined with the solution provided in this comment Will be the most robust approach and solve all your problems.
That’s what I would do
- Comment on Price Per Square Inch for TVs by size 3 months ago:
I don’t, I’m not sure if I’m in the minority. I just plug in my laptop or cast my phone (jellyfin or any other misc streaming service).
- Comment on Price Per Square Inch for TVs by size 3 months ago:
Informative post, thanks. I think a boxplot would have worked better here.
- Comment on What do you use for notes? 3 months ago:
Mobile offline sync is a lost cause. The dev environment, even on Android, is so hostile you’ll never get a good experience.
Joplin comes close, but it’s still extremely unreliable and I’ve had many dropped notes. It also takes hours to sync a large corpus.
I wrote my own web app using Axum and flask that I use. Check out dokuwiki as well.