HNHacker News
TopNewBestAskShowJobs

kelseydh

1,200 karma · joined April 9, 2015

submissionscomments
kelseydh··on A decentralized peer-to-peer messaging application that operates over Bluetooth
I've heard about technology like this for over a decade. Have never encountered a use case (even no coverage at music festivals) where it once became viable.
kelseydh··on Dead Internet Theory
What is now certain is Dead StackOverflow Theory.
kelseydh··on Dead Internet Theory
One way to use em-dash and look human is to write it incorrectly with two hyphens: --
kelseydh··on Dead Internet Theory
This would have been very helpful three years ago, before I permanently stopped using em-dashes to not have my writing confused with LLM's.
kelseydh··on Eat Real Food
Copyright © 2008

When was this web page last updated?

kelseydh··on Eat Real Food
Not to mention how high heat cooking of meat, which is common for a steak via frying, brings health risks from Advanced Glycation End products (AGEs).

AGEs are also present in vegetables and legumes, but certain meats like bacon contain unbelievable amounts relative to other foods. (Interestingly: Rice contains almost no AGE's.)

Full guide: https://pmc.ncbi.nlm.nih.gov/articles/PMC3704564/

kelseydh··on Eat Real Food
Kinda of wild that Dairy got its own section in that document as a proscribed thing to eat.

There are plenty of lactose intolerant people. These people can meet their nutritional needs without dairy. (For Calcium: via Sardines, leafy greens, Tofu, etc.)

kelseydh··on Eat Real Food
"Frozen peas" and "Green beans" make an appearance on the pyramid, but yes the omission of any others is glaring.
kelseydh··on Eat Real Food
Almonds and peanuts make an appearance lower than red meat on the pyramid, which is wild to me.
kelseydh··on Open Infrastructure Map
The map for Australia is interesting. Is this missing data? See no infrastructure for Alice Springs in the interior of Australia.
kelseydh··on If AI replaces workers, should it also pay taxes?
Corporations should be taxed on their profits, including profits boosted by the invention of new technology.
kelseydh··on Building a high-performance ticketing system with TigerBeetle
Yeah it was back in February in your community Slack, I did receive a fairly thorough response from you and others about it. However then there were no technical critiques of the Go benchmarking code, just how our PostgreSQL comparison would fall short in real OLTP workloads (which is fair).
kelseydh··on Building a high-performance ticketing system with TigerBeetle
Thanks for reaching out. I shared this benchmarking script with your team when we tested Tigerbeetle, but this is it again: https://gist.github.com/KelseyDH/c5cec31519f4420e195114dc9c8...

Was there something wrong with our test of the individual transactions in our Go script that caused the drop in transaction performance we observed?

kelseydh··on Building a high-performance ticketing system with TigerBeetle
Ok your comment made me double check our benchmarking script in Go. Can confirm we didn't instantiate a new client with each request.

For transparency here's the full Golang benchmarking code and our results if you want to replicate it: https://gist.github.com/KelseyDH/c5cec31519f4420e195114dc9c8...

We shared the code with the Tigerbeetle team (who were very nice and responsive btw), and they didn't raise any issues with the script we wrote of their Tigerbeetle client. They did have many comments about the real-world performance of PostgreSQL in comparison, which is fair.

kelseydh··on Building a high-performance ticketing system with TigerBeetle
We certainly are losing that efficiency, but this is typically how real-time transactions work. You write real-time endpoints to send off transactions as they come in. Needing to roll more than that is a major introduction of complexity.

We concluded where Tigerbeetle really shines is if you're a large entity like a central bank or corporation sending massive transaction files between entities. Tigerbeetle is amazing for moving large numbers of batch transactions at once.

We found other quirks with Tigerbeetle that made it difficult as a drop-in replacement for handling transactions in PostgreSQL. E.g. Tigerbeetle's primary ID key isn't UUIDv7 or ULID, it's a custom id they engineered for performance. The max metadata you can save on a transaction is a 128-bit unsigned integer on the user_data_128 field. While this lets them achieve lightning fast batch transaction processing benchmarks, the database allows for the saving of so little metadata you risk getting bottlenecked by all the attributes you'll need to wrap around the transaction in PostgreSQL to make it work in a real application.

kelseydh··on Building a high-performance ticketing system with TigerBeetle
We didn't observe any automatic batching when testing Tigerbeetle with their Go client. I think we initiated a new Go client for every new transaction when benchmarking, which is typically how one uses such a client in app code. This follows with our other complaint: it handles so little you will have to roll a lot of custom logic around it to batch realtime transactions quickly.
kelseydh··on Building a high-performance ticketing system with TigerBeetle
We didn't rule out using Tigerbeetle, but the drop in non-batch performance was disappointing and a reason we haven't prioritised switching our transaction ledger from PostgreSQL to Tigerbeetle.

There was also poor Ruby support for Tigerbeetle at the time, but that has improved recently and there is now a (3rd party) Ruby client: https://github.com/antstorm/tigerbeetle-ruby/

kelseydh··on Building a high-performance ticketing system with TigerBeetle
I recently did performance testing of Tigerbeetle for a financial transactions company. The key thing to understand about Tigerbeetle's speed is that it achieves very high speeds through batching transactions.

----

In our testing:

For batch transactions, Tigerbeetle delivered truly impressive speeds: ~250,000 writes/sec.

For processing transactions one-by-one individually, we found a large slowdown: ~105 writes/sec.

This is much slower than PostgreSQL, which row updates at ~5495 sec. (However, in practice PostgreSQL row updates will be way lower in real world OLTP workloads due to hot fee accounts and aggregate accounts for sub-accounts.)

One way to keep those faster speeds in Tigerbeetle for real-time workloads is microbatching incoming real-time transactions to Tigerbeetle at an interval of every second or lower, to take advantage of Tigerbeetle's blazing fast batch processing speeds. Nonetheless, this remains an important caveat to understand about its speed.

kelseydh··on Denmark reportedly withdraws Chat Control proposal following controversy
It's a reverse of what you're describing, but a similar mechanism like this in Canada is their notwithstanding clause.

If the Supreme Court of Canada rules a law unconstitutional, the government in power can overrule their ruling by using the notwithstanding clause. However, the notwithstanding clause override to keep the law in effect only lasts for five years. Subsequent legislatures have to keep renewing the override or the Supreme Court's ruling of unconstitutionality takes effect again.

kelseydh··on Facts about throwing good parties
I miss the days when Facebook events worked well for getting people to attend a party.

Now, nobody is on Facebook so those event invitations get missed and you need to hustle much harder with individual chat messages to get people to attend.

kelseydh··on Denmark reportedly withdraws Chat Control proposal following controversy
This doesn't fit at all with how governance and politics works in reality. Rapid changes to society or a crisis can suddenly make deeply unpopular ideas very popular.
kelseydh··on AWS multiple services outage in us-east-1
Is us-east-1 equally unstable to the other regions? My impression was that Amazon deployed changes to us-east-1 first so it's the most unstable region.
kelseydh··on Novo Nordisk's Canadian Mistake
Back in 2018, it wasn't widely known that Ozempic would become a blockbuster weight loss drug. So it was possible they made the business decision based on its more limited use as a diabetes drug.
kelseydh··on AWS multiple services outage in us-east-1
This whole incident has been pretty uneventful down in Australia where everything AWS is on ap-southeast-2.
kelseydh··on AWS multiple services outage in us-east-1
It seems like this can be mostly avoided by not using us-east-1.
kelseydh··on Microsoft is plugging more holes that let you use Windows 11 without MS account
Is Linux gaming on Steam actually competitive in performance and availability to what you'll get on Windows? I'm looking into building a gaming computer I'm surprised to hear I could roll with Linux for it.
kelseydh··on Read to forget
When I come across a profound excerpt or cool quote I stash it in my Random Excerpts section of my note taking app.

It's a pleasure to go back and read the cool things I've totally forgotten about.

kelseydh··on YouTube is a mysterious monopoly
My gripe with Youtube Music is that the bitrate quality of their music is lower than Tidal or even Spotify. YTM audio files that are actually on Youtube will only stream in 128kbps.
kelseydh··on YouTube is a mysterious monopoly
The other useful Youtube Premium feature is the ability to offline download videos to your device. Useful for long plane rides and elsewhere where internet is limited or nonexistent.
kelseydh··on Take something you don’t like and try to like it
When I was young I had a weird cognitive bias where I would think that if something tasted curious or different, that it must be good for you in some way.

E.g. the odd taste of licorice. Must mean that it was healthy or good right? Turns out licorice really isn't good for you. https://www.heart.org/en/news/2022/10/28/black-licorice-is-a...

← PreviousPage 3 of 15Next →