HNHacker News
TopNewBestAskShowJobs

tpetry

3,646 karma · joined August 6, 2013

submissionscomments
tpetry··on How to keep enjoying programming in a world of LLMs
Oh I dont disagree that it does replace some jobs. Why use junior developers when AI generates the same quality?

Just that comparing LLM to a compiler is nonsense. Because one is deterministic and the more using it, the better the quality will get.

tpetry··on How to keep enjoying programming in a world of LLMs
Its a false premise so often repeated. I am really tired. Compilers are ruleset: If you pass it one statement it'll produce the same output all the time. Its easy to verify it works. And if enough people have used it before and found no problems, there probably aren't many. Spoiler: People always find niche bugs.

But an LLM will generate you two completely different things today and tomorrow. Heck, even if you stash its changes and redo the same prompt.

They are NOT comparable at all.

tpetry··on Postgres SELECT DISTINCT Does Not Scale
Did you even read the article? They show that a perfect index for their query didnt help because Skip Scan is currently not used for DISTINCT queries.
tpetry··on Google's first Suncatcher orbital data center test launches October 1
Its running for 15 minutes and then must shut down for a long time to cool down. Thats exactly why those "science-fluencers" said its a dumb idea. This is far away from proving that its a viable idea.
tpetry··on Neki – Sharded Postgres
Sam is always shitting on others. For years he has been screaming how bad PostgreSQL is compared to MySQL. Until getting silent about this topic for a few months and then launching PostgreSQL support. Seems he had to realize than the market for PostgreSQL is too big to ignore.
tpetry··on AWS Acquires DuckLabs
And there is no single company developing. Its a healthy mix of engineers from many companies. A perfect model to prevent this issue here of being aquihired.
tpetry··on PostgreSQL for Everything
The article suggested using TimescaleDB which has its own concept of IVM: continuos aggregates. And compared to the approach by ClickHouse it can also update the materialized views when you update/delete old raw data

https://sqlfordevs.com/books+courses/timescale/05-continuous...

tpetry··on A Preview of DuckDB v2.0
You‘re not the only one interested in this. But seems its a big change that would have to change many parts within DuckdB:

https://github.com/duckdb/duckdb/discussions/8444

tpetry··on Claude Is Not a Compiler
The question is more what this really solves. They said they built all this because DNS propagation was too slow. But secondary dns servers by e.g. your isp will still have old records when you change something. So what did they earn? Every is correct within their network pretty fast. But for a normal user there isnt any difference because 8.8.8.8 or 1.1.1.1 still cache old records?
tpetry··on GhostLock, a stack-UAF that has existed in all Linux distributions for 15 years
Sometimes similar articles are merged into one. Including the comments.
tpetry··on Postgres rewritten in Rust, now passing 100% of the Postgres regression tests
You immply that a testcase exists for every weird edge case. Especially filesystem and concurrency is things you can barely build test cases for.

Even a 100% test coversge is far away from verifying all behaviour.

tpetry··on TypeScript 7
These are for type-checking. Transpiling takes barely any time.
tpetry··on Why we built yet another Postgres connection pooler
And Planetscale (who is the current primary maintainer of vitess) is developing a Vitess for PostgreSQL.

There will be a couple of production-grade PG vitess solutions the next months.

tpetry··on Why we built yet another Postgres connection pooler
This exists, its called a user. You just use different database users for this.
tpetry··on We’re making Bunny DNS free
Yes. You‘re getting charged. But a dollar for your entire bunny account (not for every service or domain) is not that much to ask for.
tpetry··on We’re making Bunny DNS free
I wish for the sme. Right now I‘ve created specialized edge functions to e.g. make a deployment which has the global access key.

So, my scripts on my servers dont have the bunny api key. Its only saved within those edge functions and I authenticate against the edge functions.

A little bit more effort than scoped keys but it works

tpetry··on Upcoming breaking changes for npm v12
Can you clarify why the node permission system is broken but the deno one works? For an outsider like me both look like the same.
tpetry··on Upcoming breaking changes for npm v12
That has also been implemented recently. With staged publishing the author must verify a new release with 2FA so automated attacks dont work anymore. Some human in the loop must verify a release.
tpetry··on xAI is looking more like a datacentre REIT than a frontier lab
SolarCity pretty much failed. Wasnt there an article recently that their projects per year is super low?
tpetry··on Lambda isn't leaking memory, your metrics are lying to you
I am wondering about the last part of glibc malloc. Isnt that exactly the problem reported for the last 10+ years with glibc? And the common solution is to use tcmalloc or jemalloc which hasnt these problems?
tpetry··on Bot vs human traffic
I do understand why all of those bot scores are so high. But netherlands? Are there big datacenter providers I dont know of that are used by bots?
tpetry··on Mini Shai-Hulud Strikes Again: 314 npm Packages Compromised
You can still update to new versions even if the new release is still in cooldown phase. You just have to be explicit that you want the new release.

pnpm audit —fix for example will whitelist releases in cooldown phase when theres a known security issue for a version you currently use.

tpetry··on I am worried about Bun
And a bug in a dependency you can fix easily. One in the runtime is much harder to fix and you then must compile new versions.
tpetry··on Show HN: PanicLock – Close your MacBook lid disable TouchID –> password unlock
When you disable that, its also disabled for sudo operations when unlocked. it basically disables TouchID completely.
tpetry··on Show HN: PanicLock – Close your MacBook lid disable TouchID –> password unlock
I would love to have a mode that I must use my long password to unlock my mac for security purposes. But when unlocked, use touchid as an alternative to my password for convenience.

So just the normal TouchID mode but not for unlocking the mac.

tpetry··on Ask HN: Founders of estonian e-businesses – is it worth it?
Oh there will be a lot of issues in the future because Germany says thst your company is in Germany because you work from there. So you have to do taxes in Estonia and in Germany. And prepare for a lot of tax issues if you dont have a good tax advisor.
tpetry··on How to Keep ICE Agents Out of Your Devices at Airports
I do understand why all these steps are required. And they are good. But how should zero-trust architecture solve that? You‘re still authenticated what the core problem is.
tpetry··on Migrating to the EU
When you have a custom domain you can list @mydomain.com as sending domain allowing you every string before the at character. So that means you could use 50 different domains with infinite adresses on these domains.
tpetry··on The bespoke software revolution? I'm not buying it
The doomsday saying the past months that everyone will now vibecode a solution instead of paying for SaaS as a big logic error… These people could have switched to self-hosting an open source clone of any popular SaaS but they didn‘t! Why? Because they dont want to be the person maintaining this, so we should those people not self-hosting a free software now go one step further and also build those products?
tpetry··on Bunny Database
The reverse. Argo gives better peering than any paid plan. Its the reason for the product‘s existence. They can use more costly peering that they couldn‘t use with their free egress model.
Page 1 of 28Next →