HNHacker News
TopNewBestAskShowJobs

sbstp

154 karma · joined October 11, 2023

submissionscomments
sbstp··on Rivian's gambit for full autonomy
Out of curiosity, do you live in a place that gets heavy snow? I've always felt that FSD would struggle to handle heavy snow fall, roads with snow banks on the sides and difficult driving/braking conditions in the snow and on ice patches.
sbstp··on AI Responsibility – OpenAI and Anthropic
See Colossus: The Forbin Project
sbstp··on Go 1.27 Interactive Tour
Go's standard library has always been it's strength, especially the crypto package! Lovely stuff.
sbstp··on Have you restarted your computer this week?
Don't you reboot servers to get kernel security updates? I usually have unattended upgrades with the option to reboot during the night if necessary
sbstp··on Migrating from Proxmox to NixOS and Incus
Incus is great. I've been trying to revive an unmaintained ansible collection to manage incus resources https://github.com/sbstp/ansible-collection-incus
sbstp··on Sam Bankman-Fried loses bid to appeal against fraud conviction in FTX case
I think Kraken has been selected to redistribute the funds, but not sure if it has happened yet. These things take time, I think Mt. Gox took like a decade to be distributed
sbstp··on UK Government’s ‘AI Skills Hub’ was delivered by PwC for £4.1M
CGI is a terrible company known for going over budget and under delivering on a ton of projects. Not that many companies bidding on large government contracts unfortunately
sbstp··on Scaling PostgreSQL to power 800M ChatGPT users
This article has very little useful information...

There's nothing novel about optimizing queries, sharding and using read replicas.

sbstp··on Poison Fountain
Assuming they ever manage to turn a profit...
sbstp··on Nearly 90% of Windows Games Now Run on Linux
Tried to play dota 2 on Linux, it has a bad memory leak that made the whole system hang after an hour or two. Plus it seems to get worse fps on Vulcan, but I read that it might just be a bad implementation in my card (6650 xt)
sbstp··on I tried Servo
Using WebKit (even JavaScriptCore) and working with Apple wouldn't be the worst thing to my eyes as a Firefox/FOSS user. Duopoly isn't great but it's better than a monopoly.
sbstp··on AccuWeather to discontinue free access to Core Weather API
Project 2025 strongly opposes everything good in this world.
sbstp··on Broadcom to discontinue free Bitnami Helm charts
RabbitMQ next?
sbstp··on Postgres LISTEN/NOTIFY does not scale
I've been disappointed by Nats. Core Nats is good and works well, but if you need stronger delivery guarantees you need to use Jetstream which has a lot of quirks, for instance it does not integrate well with the permission system in Core Nats. Their client SDKs are very buggy and unreliable. I've used the Python, Rust and Go ones, only the Go one worked as expected. I would recommend using rabbitmq, Kafka or redpanda instead of Nats.
sbstp··on Async Queue – One of my favorite programming interview questions
yuck.
sbstp··on My Database Is My Application: Rethinking Webhook Logic with DuckDB and SQL
There seems to be a few typos in the article, unless I don't understand what's going on.

In step 1, the register uses the source path 'github-events' but the payload is using 'github-pushes'.

In step 3 it says filter_query passes since payload->>'ref' is 'refs/heads/main' but we never see that filter being inserted in the service, the only filter we see is type IN (\'PushEvent\', \'PullRequestEvent\').

Was the article edited midway through and missed some pieces?

sbstp··on I Didn't Need Kubernetes, and You Probably Don't Either
Most control planes are not free anymore, they cost like 70$/mo on AWS & GCP. Used to be a while back.
sbstp··on Tcl 9.0
I'm not a TCL user, but from the description of wduquette is sounds similar to Python's zipapp

https://docs.python.org/3/library/zipapp.html

sbstp··on QUIC is not quick enough over fast internet
Even HTTP/2 seems to have been rushed[1]. Chrome has removed support for server push. Maybe more thought should be put into these protocols instead of just rebranding whatever Google is trying to impose on us.

[1] https://varnish-cache.org/docs/trunk/phk/h2againagainagain.h...

sbstp··on Building static binaries with Go on Linux
I feel like there's a lot of potential between Go and Cosmopolitan libc. Go itself does not use libc much, as shown in the blog, but some great libraries like SQLite3 need it (unless you use https://pkg.go.dev/modernc.org/sqlite).

The ability to build a single static binary that works on Linux, Mac and Windows using Go would be life changing for the internal tools I develop at work.

sbstp··on Intel vs. Samsung vs. TSMC
Chip design & manufacturing is probably the closest thing we have to witchcraft as a species.
sbstp··on Beating NumPy matrix multiplication in 150 lines of C
Maybe -march=native gives it an edge as it compiles for this exact CPU model whereas numpy is compiled for a more generic (older) x86-64. -march=native would probably get v4 on a Ryzen CPU where numpy is probably targeting v1 or v2.

https://en.wikipedia.org/wiki/X86-64#Microarchitecture_level...

sbstp··on Caddy 2.8
Envoy is definitely a powerful & useful tool, we use external auth to centralize our authentication, I just dislike editing large yaml documents with 10 levels of indentation.
sbstp··on Caddy 2.8
Caddy is amazingly simple to setup. Automatic HTTPS is a killer feature.

I have to use Envoy at work for gRPC services and I want to quit the industry every time I have to edit their YAML/protobuf monstrosity of a config system.

sbstp··on Eradicating N+1s: The Two-Phase Data Load and Render Pattern in Go
How does jet compare to sqlboiler? I've been using sqlboiler quite successfully on a work project.
sbstp··on Making a Postgres query 1k times faster
I generate queries like this in a paging library I wrote at work, I did not use the tuple comparison because sometimes the sorting order is different between fields, each field in the tuple comparison would need a different operator, such as

WHERE Posts.CreateAt > ?1 OR (Posts.CreateAt = ?1 AND Posts.Id < ?2) ORDER BY Posts.CreateAt ASC, Posts.Id DESC

I now wonder if it might be possible to use a negation operator to invert the sorting order, like:

(Posts.Id, -Posts.CreateAt) < (?1, ?2) ORDER BY Posts.CreateAt ASC, Posts.ID DESC

and keep the performance improvement.

sbstp··on Linux 6.9 Released
It's a bit weird that bcachefs is in the kernel, from what I understand there's still a lot of work to do on it. Would be nice to see more corporate sponsorship behind it, it's quite promising. Still not confident using it over ZFS.
sbstp··on The API database architecture – Stop writing HTTP-GET endpoints
The biggest issue with postgREST for me is that it doesn't support transactions well. You can't two 2 insert and keep a consistent state if one fails. That alone is a deal breaker.
sbstp··on Trainee just took down our business and has no idea how or why
Thanks, that clears it up!
sbstp··on Trainee just took down our business and has no idea how or why
Got that from the context but not really how it ties with the riot act.
Page 1 of 2Next →