HNHacker News
TopNewBestAskShowJobs

runeks

6,620 karma · joined March 5, 2012

https://cryptomarketdepth.com/

Twitter: @runeksvendsen

GitHub: https://github.com/runeksvendsen

submissionscomments
runeks··on Active Active in Postgres 16
> The expectation after committing is that last_name will be equal to Jones and email will be bugs.bunny@acme.com. Commit the transaction in pg1 and then in pg2. What happens?

> Now both rows are out of sync. In pg1, the update of the email was lost and in pg2 the update of last_name was lost. This happens because the entire row is sent over during logical replication and not just the fields that were updated. In such cases, even eventual consistency is not possible.

Hmm, this makes it seem rather useless. Or at least not useful for what I would expect: keeping two Postgres instances in sync.

runeks··on Choose Postgres queue technology
Isn’t this just https://news.ycombinator.com/item?id=29599132 with the addition of a custom worker ID (pod name)?
runeks··on Choose Postgres queue technology
> Multiple times, I've pushed an SQL-based queue a couple orders of magnitude past the scale where others say SQL craps out and a distributed solution is an absolute requirement.

What about availability, though? The distributed solution is also useful to avoid downtime in case of single node failure.

Is there an off-the-shelf solution that lets me do that with Postgres? I know the newest version (16) just added active-active replication, but I wouldn’t know how to use that to achieve resilience.

runeks··on Choose Postgres queue technology
Also: an ordered index that matches the ordering clause in your job-grabbing query. This is useful if you have lots of pending jobs.
runeks··on Choose Postgres queue technology
If your first point holds, then all app components should be “scalable” from the beginning, because you may not have time to make it so later.

And that’s terrible advice, of course. You very likely will have time to scale things up (customer count almost never increase dramatically from one day to the next), and even if you don’t you’ll most likely never deliver a useable product if all components need to be “scalable” from the beginning.

runeks··on Choose Postgres queue technology
At my previous company, they switched from using NOTIFY/LISTEN for Postgres notifications to a custom solution built on top of logical replication. As I understand it, part of the reason was reliability. I never touched that part of the code, but I believe the idea was to subscribe to logical replication updates and send out notifications based on these.
runeks··on EU fines Intel $400M for blocking AMD's market access
I'm not taking about the article. I'm asking the person I'm replying to who says "The situation is still the same, happening as we speak".
runeks··on IPFS support got merged into curl
Thanks!

Why a DAG rather than a tree, though? I can't seem to find an explanation for why a DAG is needed — I would think a tree should suffice.

runeks··on IPFS support got merged into curl
Question: is the in-URL hash some form of Merkle tree root hash? Or is another method used to avoid having to download all the data before the hash can be verified?

Searching for “Merkle” on https://ipld.io/specs/transport/car/carv2/ gives no results.

runeks··on IPFS support got merged into curl
My guess would be to reduce transit fees.

I know my local ISP caches the Google homepage (I assume this is the reason).

runeks··on EU fines Intel $400M for blocking AMD's market access
That’s the essential problem with parents: nobody really know how it affects competition. And therefore the status quo doesn’t change.

I think we should swap the burden of proof: patents should be abolished if it cannot be shown that they’re a net positive for consumers. We shouldn’t be supporting a practice whose effect is unknown and possibly detrimental to consumers.

runeks··on EU fines Intel $400M for blocking AMD's market access
> Especially since, if there hadn't been patents, they would have just had everything as trade secrets.

Reverse engineering the x86 instruction set would be rather trivial for even a small company. Releasing a x86 product, however, is not possible because of patents and Intel lawyers.

runeks··on EU fines Intel $400M for blocking AMD's market access
Devil’s advocate: where’s the evidence that this is caused by anti-competitive practices by Intel?

Most people have no idea what AMD or Intel — let alone a CPU — is. It seems plausible that AMD isn’t popular because the average consumer isn’t demanding it.

runeks··on XML is better than YAML – Hear me out
The primary problem with YAML is that it allows writing strings without quotes. This causes confusion because it’s impossible to see, from just reading the YAML file, which strings become strings and which are interpreted as numbers or booleans.

For example, the identifier blah is interpreted as a string; but 01 is interpreted as a number, which makes it equivalent to 1. Similarly the identifier nope is a string while no is the Boolean literal false, and there’s no clear indicator that the former is a string while the latter is a Boolean.

runeks··on Linux gives up on 6-year LTS kernels, says they’re too much work
They achieve it by paying developers to do it (instead of relying on unpaid volunteers).
runeks··on Linux gives up on 6-year LTS kernels, says they’re too much work
> The other big problem is the burnout from maintainers, which are often unpaid and could use a lot more support from the billion-dollar companies that benefit from using Linux.

This is the crux of the issue: putting the maintenance burden on unpaid volunteers instead of having the burden be carried by the companies that profit from the 6-year LTS.

runeks··on 64-bit bank balances ‘ought to be enough for anybody’?
This only puts currency codes in the type system; and uses rational numbers for amounts.

This is definitely useful because you can have the type system tell you if you've implemented e.g. exchange rate conversion incorrectly. But it's also a hassle because you need to reify currency values discovered at runtime as types, which isn't pretty [1].

[1] https://github.com/runeksvendsen/order-graph/blob/eef0006cba...

runeks··on 64-bit bank balances ‘ought to be enough for anybody’?
I think it's the worst example. I very much doubt we will ever see the price of, say, a car approach a billion billion dollars (or cents). It's too many zeros for people to work with on a daily basis. I think what will happen is that, at regular intervals, the old hyper-inflated currency will be replaced with a new currency that's, say, 2^32 times less than the original one.

Besides, if you think a billion billions might be reached (64 bits) then why wouldn't a billion billion billion billions also be reached (128 bits)? 128 bits seems just as arbitrary as 64 bits in this context.

runeks··on Googlers told to avoid words like ‘share’ and ‘bundle,’ US says
> Doesnt the title imply using words monopolists use is evidence of something? Surely thats not what defines a monopoly. You’d have to look at actual actions.

Who says they're not both looking at what Google says and what it does?

Proving that Google both has questionable practices and tries to hide them is an argument that Google not only does questionable things but also that Google is aware it's doing questionable things.

runeks··on Chromebooks will get 10 years of automatic updates
> The treadmill is powered by "intellectual property". Abolish "owning" ideas, and you abolish the treadmill.

How so?

runeks··on The great American eye-exam scam (2019)
How much did the three different prescriptions differ?
runeks··on Amazon training video on handling unionizing activity (2018) [video]
Unions are there to take care of the interests of their members. This is undeniably good for their members, but I'd like to remind you that it's not always good for outsiders.

For example, the union of California's prison guards (California Correctional Peace Officers Association) have helped lobby for the "three strikes" rule to get more people in prison: https://academic.oup.com/book/11009/chapter-abstract/1593367...

runeks··on Apple iPhone 15 Pro and iPhone 15 Pro Max
That should be possible already with the LIDAR, I think.
runeks··on NSO group iPhone zero-click, zero-day exploit captured in the wild
Why would an iPhone be running x86-specific code?

I don't dispute that these optimizations may have been necessary on older hardware, but I think the current generation of Apple CPUs should have plenty of power to not need these micro optimizations (and the hardware video decoder would take care of this anyway).

runeks··on NSO group iPhone zero-click, zero-day exploit captured in the wild
I call bullshit on this one.

I don't buy that being able to manually copy data into a memory buffer is critical for performance when implementing image codecs. Nor do I accept that, even if we do want to manually copy data into memory, a bounds check at runtime would degrade performance to a noticeable extent.

runeks··on NSO group iPhone zero-click, zero-day exploit captured in the wild
I don't want to disable iMessage, just attachments from unknown contacts.
runeks··on Results of technical investigations for Storm-0558 key acquisition
How so?
runeks··on I built a plane spotter for my son in minutes
> Coding LLMs really shine for greenfield projects in popular programming languages.

Greenfield? Unless we disagree on the definition of greenfield (no prior work), then a plane spotter app is anything but greenfield. GitHub returns 11 repos for JavaScript alone.

runeks··on How to get transactions between almost any data stores
I will keep using this example. It's a good example for illustrating why transactions are necessary and what they are. And it's not relevant whether or not banks actually work this way.
runeks··on Meta AI releases CoTracker, a model for tracking any points (pixels) on a video
I wonder how this compares to the motion estimation algorithms in the x264 and x265 video codecs. If it's better, then it can be used to increase video compression, by using it at the motion estimation stage for these codecs.
← PreviousPage 9 of 34Next →