Hacker News Reader

I like this strategy a lot, but the performance of read queries suffer if they span partitions, correct?

The issue I'm facing is a very large table, that is both write and read heavy, and the reads do not fall into a specific range of values for any particular column, so I don't think partitioning is an option.

timbowhiteon Quantum computing bombshells that are not April Fools

In Bitcoin's case, public keys are only revealed during a transaction.

And every transaction completely spends the source keypairs' funds.

So the only attack vector a quantum computer could use is:

1. Observing newly broadcast/unconfirmed transactions

2. Deriving the private key(s) from the public key(s)

3. Creating and broadcasting its own transaction using the stolen keypairs before the original transaction confirms (presumably with a higher fee to win the confirmation race).

Please correct me if I'm wrong.

EDIT: correction: every transaction completely spends any selected UTXO of an associated keypair, not all of the "source keypairs' funds". Thus the attack vector also includes being able to steal from any keypair that has ever made a transaction and also has UTXOs.

timbowhiteon Get free Claude max 20x for open-source maintainers

> I maintain Express.js and Lodash

Thank you!

> In 2025 I made $10 from open source

Slightly off-topic, but I wish more OSS projects and maintainers would advertise cryptocurrency donation addresses. It's probably the easiest way for end users to donate.

timbowhiteon Earth was born dry until a cosmic collision made it a blue planet

Is this the same collision theorized to have created the moon?

timbowhiteon How I block all 26M of your curl requests

I run independent websites and I'm not broke yet.

timbowhiteon A SQL Heuristic: ORs Are Expensive

The pg_ivm plugin adds incremental updates to Postgresql materialized views:

https://github.com/sraoss/pg_ivm

Though I don't know how well it works on a write-heavy production db.

timbowhiteon Show HN: I built a Bitcoin DCA bot – here's why

Pretty neat.

How would the multiplier DCA act during a multi-month "crypto winter"?

timbowhiteon Payment processors' bar on Japanese adult content endangers democracy (2024)

> never understood why we don't have decentralized/globally neutral payments/transactions systems

BTCPay Server[0] seems to be the most popular way to accept crypto payments on self-hosted hardware with no third party processors.

[0] https://btcpayserver.org/

timbowhiteon Ask HN: What Are You Working On? (June 2025)

Is this essentially the same data CZDS [0] offers + ccTLDs zonefiles?

[0] https://czds.icann.org/home

EDIT: is your site a clone or resell of zonefiles.io? Even the favicon is the same

timbowhiteon Ask HN: What are you working on? (April 2025)

https://domdb.com - aftermarket domain name aggregator and search engine.

It has integrated BIN inventories from Afternic, Sedo, Namecheap, Porkbun, and Gname.

Currently working on custom price alerts and an API.

timbowhiteon Cybertruck's Many Recalls

I'm honestly ignorant - what political statement is it making?

It seems that liberals dislike Teslas because they dislike Elon Musk.

And conservatives dislike Teslas because they dislike new and different things.

timbowhiteon uBlock Origin CNAME uncloaking now supports filtering by IP address

Source?

timbowhiteon Styling Tables the Modern CSS Way

A solution I've used is to limit the number of table rows displayed to fit vertically within the browser viewport. This way the horizontal scrollbar at the bottom of the table is always visible without having to scroll vertically.

This does require:

0. Pagination.

1. Each table row must have the same height.

2. Use of javascript to calculate the max number of rows that will fit vertically in the viewport (and don't forget to include the height of the table header and pagination buttons in the calculation).

3. Send ajax request with row limit to server to retrieve and render the data.

You can see an example here: https://wee.domains

timbowhiteon Domain registrar Gandi gets bought out, removes free mailboxes

The catch is that you must use Cloudflare's nameservers [0]:

  6.1 Nameservers. Registrant agrees to use Cloudflare’s nameservers. REGISTRANT ACKNOWLEDGES AND AGREES THAT IT MAY NOT CHANGE THE NAMESERVERS ON THE REGISTRAR SERVICES, AND THAT IT MUST TRANSFER TO A THIRD PARTY REGISTRAR IF IT WISHES TO CHANGE NAMESERVERS.

[0] https://www.cloudflare.com/domain-registration-agreement/

timbowhiteon Porkbun Registrar DNS outage

I was able to solve DNS issues with my domains at Porkbun by:

  1. Log in to Porkbun account, go to "Domain Management".
  2. Click "DNS" link under affected domain.
  3. Click the "Yes, please update my domain" button in the red box at the top, screenshot:

https://i.imgur.com/Yfjlqit.png

timbowhiteon Show HN: Query 1.6B rows in milliseconds, live

Just a heads up - I tried this random query:

  select * from trips where pickup_latitude < -74 order by pickup_longitude desc limit 10;

Didn't get a result set. The little box in the upper right hand corner stated "Maximum number of pages (16) breached in MemoryPages"

timbowhiteon One-Word Domains

That filter hasn't been implemented yet, it's on the TODO list [0].

The best I can currently offer is the "Label is Word" column that identifies in which languages the label is considered a word or letter.

[0] https://github.com/timbowhite/wee.domains-tracker/issues/21

timbowhiteon One-Word Domains

Cheers!

timbowhiteon One-Word Domains

You might take a look at wee.domains [0] - it's a big table of short available domains from the most popular TLDs. It has pricing from a variety of registrars too.

[0] https://wee.domains

Disclaimer: i made it.

timbowhiteon Fewer Than Half of Google Searches Now Result in a Click

No I don't think so. Thanks for pointing that out.

IIRC, I eventually removed nosnippet because it caused google to not display microdata in SERP (see the "$25.99 to $99.80" in the above screenshot) that were desirable for my traffic. I instead replaced nosnippet with:

``` <meta name="robots" content="noarchive"> ```

And this seemed to have the same effect as nosnippet, but with the added benefit of my microdata still being displayed in SERP.

timbowhiteon Fewer Than Half of Google Searches Now Result in a Click

I deliberately opted out of snippets for TLD List [0], a price comparison site I made for domain names.

I don't know if it's made any difference. Organic search traffic from them has slowly but steadily increased over the years.

Google now sometimes displays a snippet from my competitor's website for searches like "cheapest .io domain" [1]. The snippet seems pretty useless as it doesn't include any registrars' names/links (and my competitor's price info is quite outdated).

In these cases, since the snippet is the 1st thing users see in SERP, and doesn't provide enough info to fully answer the question, I'd wager that my competitor is ultimately receiving the majority of clicks from these snippets.

[0] https://tld-list.com

[1] https://i.imgur.com/aFoZbFw.png

timbowhiteon Show HN: Commento: a fast, privacy-focused alternative to Disqus

Nice, looks polished. I remember it from 2017.

I still want to drop Disqus. But I'd need to get all of my exported comments from Disqus into Commento. Is this possible?

timbowhiteon Show HN: Cointabb

Sorry to hijack - I launched a similar site last week. It has a few more data points:

https://cryptoli.st/

I like your site's "favorites" functionality. Maybe make the favorited coins persistent via a unique URL or user login?

timbowhiteon Ask HN: Why is HN so against Bitcoin/cryptos?

I brought up the same question awhile ago, maybe the responses there will help [0]. My favorite one was:

"Money is a religion. Bitcoin offends some people's gods."

[0] https://news.ycombinator.com/item?id=9711738

timbowhiteon Ask HN: What do people use to prevent crawlers?

I wrote a plugin for node.js/express that performs basic bot detection and bans bots by IP address until they pay you some Bitcoin:

project: https://github.com/timbowhite/botbouncer

simple demo: http://botbouncer.xyz/

I ran it for awhile on some medium traffic websites that were being heavily scraped. It blocked thousands of IP addresses, but IIRC only received one Bitcoin payment.

timbowhiteon Ask HN: What's a side project you built to make money that hasn't?

Thanks! And good point about dropping the http/https in the URL validation.

timbowhiteon Ask HN: What's a side project you built to make money that hasn't?

Thanks for the suggestion! That makes a lot of sense. You're right, most publishers are very particular about format of their content in these generated videos. Focusing on a single client would help nail down at least one use case, and bring in some much needed cash flow :)

The text-to-speech software was ~$1500, and it's been running on a $100/month dedicated server since February.

timbowhiteon Ask HN: What's a side project you built to make money that hasn't?

https://vidgen.io

It's a web app that generates summary videos of online articles/content.

I launched it in February and it hasn't made a dime. I was charging ~$3 per generated video, but since it's had zero traction, the videos can now be downloaded for free.

The main feature it's lacking is a way to customize the generated videos. Once I get this implemented I will try promoting it again.

Spent about 3 months building it and over $2k in hosting + licensing.

timbowhiteon The Slow Criminalization of Peer-To-Peer Transfers

Do you think people like Rosa Parks should have started their own nation? [0]

What an incredibly frightening way of thinking.

[0] https://en.wikipedia.org/wiki/Rosa_Parks