blockchain – All Bitcoin Public Keys with non-zero balance

You can’t get a database of all such public keys, but you can get some of them.

An address, as you know, is a hash of a public key. When somebody sends coins to an address, you can think of the associated public key as having a positive balance, but nobody else necessarily knows what the public key actually is. (You can’t compute the public key directly from the address, because hash functions are effectively one way.)

However, in order to spend the coins from that address, the spending transaction has to reveal the public key (so that the spending transaction’s signature can be verified). So what you need to look for are addresses with a positive balance that have also had some coins spent. I am not aware of any simple way to do this short of making an index of all transactions. It is possible you could rig up a way to produce such a list by querying a fully-synced bitcoind using -txindex (so that all transactions are indexed), but it seems likely to be inefficient.

But as a randomly chosen example, consider the address 1Q6NNpHM1pyh6kEqzinBhEgsRc3nmpTGLm. It is associated with some public key which has a balance of BTC 259.7299, but since (as of this writing) no coins have been spent from that address, nobody except the owner of the address knows what the public key is. So your database will necessarily be incomplete; probably very incomplete.

In particular, most people use a new address for each of their transactions (including change addresses), in which case the transaction that reveals the public key for an address also spends all its coins (so that the balance is now zero), and that public key will likely never be used again. This strategy is used partly because certain theoretical cryptographic attacks are easier if the public key is known, and this strategy mitigates the risk from such attacks; it also increases privacy by making it harder to look at patterns of transactions to try to deduce who the address belongs to.

Another case in which you can learn the public key is so-called P2PK transactions, where the output script includes the actual destination public key, instead of merely its associated address. These were common in the past, but these days all standard clients use the P2PKH transaction type, in which only the address is used.

dnd 5e – Do any serious balance issues result from this houserule: Floating Ability Score at Character Creation?

It seems reasonable from a hard mechanical standpoint.

The way the rule is written prevents people from getting to 18 and from moving the original point-bought which would be problematic since the cost is non-linear and there is another upper limit here (15).

It devalues the half-elf and human

The half-elf and and the variant human can choose any ability score for their bonus which can be a relevant reason to choose them. Giving a similar option to all races makes this a lot less appealing. I know that variant human is very powerful and the feat is usually a very important reason for the choice. The effect is more relevant for the half-elf.

Incidentally, the normal human gets stepped on their feet as well. They can produce, for example a Cleric with 16 on STR, CON and WIS at level 1, and similar setups. You can do the same now with the Triton or Goliath for example.

It affects creativity.

The house rule caters to optimizers. When someone wants to play a specific class with a specific racial feat they can now get more optimized scores as well (how optimized depends on the exact combination). Otherwise they would have to choose and get creative to make it work with 15.

You could say that it is a bonus for people who choose interesting combinations from a perspective of role-play rather than optimization. But these people are exactly the ones that will get creative and make it work. As an example, I have a tiefling ranger in my current campaign.

gm techniques – How can I balance slightly erotic roleplay and story based roleplay?

I know this question makes me sound like a pervert but especially with the epidemic me and my girlfriend ended up unable to have much contact.(Not even calls since her roommates are always in the house and it would be really awkward with them.) As a result we have been exploring new avenues and in the end as we are both TTRPG fans we decided to run text based solo games for eachother where we could at least feel a bit close and flirty.

Now the problem is I am not particularly familiar with the concept of running games with erotic features and as a result I am not sure how to balance the NPC’s flirting as a substitute for our actual contact and actual story. Neither of us want the game to essentially be a glorified erotic roleplay. Now my question is how can I keep myself from including too much relationship stuff without fully avoiding them altogether.

mysql – How to calculate running balance for many accounts?

Reset the balance if transaction_date is in a new financial period AND account_type > 5

SELECT, account_no, account_type, transaction_id, DATE_FORMAT(acc_transactions.transaction_date, "%d/%m/%Y") transaction_date, debit_balance, credit_balance 
, IFNULL(,-1)
,(@current_period_id := IF(IFNULL(,-1) <> @current_period_id, IFNULL(,-1) ,@current_period_id) ) current_period_id
,(@running_balance   := IF(@curr_account_no < account_no OR (@current_period_id <> IFNULL(,-1) AND account_type > 5) , 0,@running_balance)) prev_runnng_bal
,(@curr_account_no   := IF(@curr_account_no < account_no ,account_no,@curr_account_no)) curr_account_no
,(@running_balance   := @running_balance + (acc_account_transactions.debit_balance - acc_account_transactions.credit_balance)) as running_balance
FROM (SELECT @running_balance := 0,@curr_account_no := 0,@current_period_id := -1) r, acc_account_transactions
INNER JOIN acc_transactions ON = acc_account_transactions.transaction_id
INNER JOIN acc_accounts ON = acc_account_transactions.account_no
LEFT JOIN acc_finacial_periods
ON  DATE_FORMAT(transaction_date, "%Y/%m/%d")>= DATE_FORMAT(startdate, "%Y/%m/%d")
AND DATE_FORMAT(transaction_date, "%Y/%m/%d")<= DATE_FORMAT(enddate, "%Y/%m/%d")
ORDER BY account_no, 

balance – How to check about 10 million bitcoin addresses?

You don’t need to check the whole 62*62*62*62 addresses online through API. That would be an insanely long journey, and you’ll get blacklisted at any free service before finding what you seek, no doubt.

In your place I would:

1) download the daily balance snapshot from

2) either in Windows through Cygwin or in Linux shell, or in MacOS terminal type:

zcat blockchair_bitcoin_addresses_latest.tsv.gz|grep "the part of the address you remember"

Example, I took a random address from the list and removed last 4 digits:

root@ubuntu:~# time zcat blockchair_bitcoin_addresses_latest.tsv.gz |grep 1EpfyhhNnwF2Sv53PUzoJGRawiTVy
1EpfyhhNnwF2Sv53PUzoJGRawiTVybuMTz      1

real    0m9.479s
user    0m9.209s
sys     0m0.746s

I’ve run the command with time in front just for testing purposes, in order to demonstrate that it took less than 10 seconds to parse the list and find the matching address, and this is not a powerful PC. I don’t even have SSD here, I bet if you have one it will be even faster.

Please note the number 1 after the address: this BTC address has indeed 1 satoshi.

If you are in doubt about capital letters in your address just add the -i option after grep so it will not run a case-sensitive search and will return the result even with wrong capitals in the search pattern; here I searched all Bitcoin addresses with non-zero balance containing my name despite any capitals, and it still took 10s:

root@ubuntu:~# time zcat blockchair_bitcoin_addresses_latest.tsv.gz |grep -i marco
3NPjX9BFc3hZdXeqjFqMNMARco2gfna9cR      1512000000
1HTsd6dR5qdKUTghRh8VdfDq3marcoVBdZ      4267964
1LCidVxbHzL4maRcoeaYZrevVVz3KTHnqb      3900000
1AF9enGasTBY1zxsMARCotYP9izc2v3Fzs      2028360
17kaMiiyDa11VGYMArCoZM8wD9enpWXc5K      1009417
1EoDrgLovufWp4BjC4iEqyhSHR2MaRcob1      1003055
14UEd1qtHwvWk3tWjkDsZfRXKUDx7mArCo      483996
1At868R9nWceRRpymarCopNhrywPUooDvE      431629
1Marco12CWtLWwAK9eKxqTZmeQgitBwAhg      200000
1marcoUFS2NyCtW7hH2AGxGVbJ9fpZkrR       184000
17Nw3Ed1vnUQpmzKty2MarcoCskKDZQmAp      167192
18odA7ipASdRFkf1gGAspQ8DQmArCoLrsU      99300
1MArcoSBgoNhnypXD7YhE4T9B7eUFSTLA3      26280
1marco52Uta2SKaLPeNiEczbrwCHnV7Jb       17100
1MaRCoEoSZXpupVVtCcs5chdEVwF78FQ9U      10000
1Kf9aZ21UQmrRBpXfMarcoQoj7VgV2e9H2      3660
1FT4mpGZS4Df8WzjWHhDDCezJJKksmARCo      3607
1MarcoStvKXXkeQJhwfcUdUP1NLnHB2bfr      1
1MArCovVsyQ54sRufEvjCrNCmUfgr3ZsvY      1
1MARcoseSo15DysRD9t2GoRm2aaHPKxgeh      1
1DemArcoSrb2D8RCSvsU7gPBvFbT3sdDL1      1
1MarConm2xEoBveieCcGGZvAvKZi6EHvzn      1
1DemArCozufYcpvVqxsXy3ttLh2iN5keHr      1
1MARCoNioFuSbuX7mgAifgBx8hsF8FVFu8      1

real    0m9.921s
user    0m10.829s
sys     0m0.656s

Relevant note: if you have not a premium API account on the list download (today over 700MB) is rate limited to 128KB/s. The DL takes around two hours but it is updated daily, and I find it’s still a tremendous booster for all bulk balance lookups issues, unless you need balances to be real time. In this last case, look to a paid API as only solution.

Is there a domain reseller that allows reselling without keeping balance?


Is there a domain reseller that integrates with WHMCS that will allow you to sell domains but they handle all payments and dont require you to keep a balance? Im not sure if my question is clear but I dont care about profit on domain names, I just care about customer convenience. Most of my clients are non techy people. I would like to offer domain names but dont want to keep a balance on the various reseller platforms. Im looking for something that is white label and integrates into their payment platform but customers can edit their settings on my site. Hope Im clear.

Thanks in advance for any replies.

My BCH balance disappeared in my blockchain wallet!! Please help me recover the funds?

I started cryptocurrency investing years ago. I set up a wallet on, and subsequently used coinbase to buy and sell bitcoin. Today, I’m engaging in more cryptocurrency investing after years of not doing anything. I notice I had a balance of Bitcoin Cash (BCH) on my account, which I no longer want to use. I was trying to figure out how to send that balance of BCH to my coinbase wallet, but couldn’t figure it out. I got frustrated, but then I stumbled on this in Coinbase FAQ:

“Can I switch from my existing wallet app like Metamask, MyEtherWallet, etc.?
Yes, you can. Every wallet uses a private key to secure its assets which you can import into Coinbase Wallet. Just look for the 12 word recovery phrase or mnemonic in the settings menu of your current wallet and then use that same 12 word phrase to sign into Coinbase Wallet.”

So, I put my recovery phrase in when creating a Coinbase wallet and it seemed to work. HOWEVER, I see now on my account that the BCH balance has disappeared. Where did that money go?? It’s not in the Coinbase wallet. How can I retrieve it??

white balance – Which of these ND filtered images do you think is more accurate? (sample images included)

As a followup to my previous question; there has been interest expressed in the results of my ND filter tests.

First, I should clarify that the heavy color cast shown in that post was from a single coated B+W filter (6-stop) purchased 5 years ago (77mm, not that it matters). I doubt that it was counterfeit, but it was obtained from Amazon (not a reseller).

Here are the raw images from a new test I did, shooting 4 different angles in the mid-afternoon using 3 test cases at each angle:

1) No filter
2) B+W MRC Nano (82mm) 6-stop (obtained from B&H)
3) Breakthrough X4 (82mm) 6-stop (obtained from Breakthrough direct, thru Amazon)

I spent a few hours analyzing this data. My conclusions:

1) X-Rite Camera Checker is significantly better than Adobe’s alternative, in terms of consistency and correctness. Using X-Rite, I was able to make filter and no-filter shots look pretty much identical, and also realistic. The Adobe profiles tended to be far more saturated. Possibly more visually pleasing, but probably not accurate, and also not quite consistent; they didn’t always make filter version look the same as no-filter.
2) The B+W and Breakthrough filters both seem pretty good in terms of color cast. They both have maybe a very small cast (nothing as bad as my other single-coated B+W) that is easily corrected but also barely noticeable if uncorrected. I think the B+W leans warm and the Breakthrough leans cold, but I’m not sure. If forced to choose, I think the B+W is slightly better (smaller cast, and I prefer warm). I like the ergonomics of the Breakthrough (the knurling around the outside of the ring), and I like that it’s made in San Fran near my home. But I dislike that it’s a new unproven company, and I also dislike that it seems slightly more optically dense than the B+W (no idea which one is actually closer to a true 6-stop, but I’d rather err on the side of too fast at this level). I’ll probably return the Breakthrough and keep the B+W (and also replace my old 77mm B+W with a new MRC Nano).

I’m curious what others’ conclusions are on my points above, i.e.
1) X-Rite vs Adobe
2) B+W vs Breakthrough