timbowhite

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.

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.

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.

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

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

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.

Pretty neat.

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

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/

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

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.

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.

Source?

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

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.

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:

Just a heads up - I tried this random query:

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

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

Cheers!

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.

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.

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

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?

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?

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

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.

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

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.

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.

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

Same list with filtering and retail pricing from ~50 registrars: https://tld-list.com

Disclosure: I made tld-list.com, so this comment is a shameless plug.