Bitcoin Block Explorer

[bitcool]

It eliminates spent outputs. The total value of unspent outputs should equal the total BTC in circulation (as it does).

The LEFT JOIN matches each output with the input that spent it. If inputs IS NULL for a row, then the output is unspent.

I intend to release my getblock-to-SQL script at some point in the far future, since it allows easy access to stats like this. It's much too messy right now, though.

This is really cool, knowing this, I'll be able to sleep much better. thanks a bunch.

[1714130151]

1714130151

[theymos]

The format of http://blockexplorer.com/q/nethash has changed. It needed built-in explanatory text, I think. The averages for rows that occur on a retarget are hopefully improved now, also. (I noticed that it was severely off when the most recent retarget showed 900+ ghash/s...)

[theymos]

http://blockexplorer.com/testnet is now using the new testnet.

[theymos]

New Real-Time Stats page:
http://blockexplorer.com/q/mytransactions

It allows you to get all transactions for given addresses. This could be used to make a simple Bitcoin client.

Examples:
http://blockexplorer.com/q/mytransactions/1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28
Dumps all transactions for 1Cvv...

http://blockexplorer.com/q/mytransactions/1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28/0000000000034b1d01d6296f7f6f46d3ba4e6cb358b8eb74d5ff7ff492e4e23a
Dumps all transactions for 1Cvv... since block 34b1...

http://blockexplorer.com/q/mytransactions/1Cvvr8AsCfbbVQ2xoWiFD1Gb2VRbGsEf28.1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
Dumps all transactions for 1Cvv... and 1NXY...

The page has good support for If-None-Match, so it can be polled without using much bandwidth.

Right now only address transactions are shown, since that's all you'll usually want, but I could support all transaction types if there is a demand.

[hacim]

Would you consider setting up BBE for namecoin's block chain?

If you are not interested in doing so, would you release the source so someone else could host it?

thanks!

[theymos]

Would you consider setting up BBE for namecoin's block chain?

As I've said before in other threads, I believe Namecoin will inevitably fail because its economic model is broken. So I won't support it.

If you are not interested in doing so, would you release the source so someone else could host it?

I don't want to make my code public now. Maybe later.

[lfm]

How does what work?  Fractional reserve or auditing them with block explorer?

If you mean, how does one audit your addresses with block explorer, simply check the addresses that you have to make sure that there have been no transactions that you didn't do yourself and that the address balances add up to what you should have.  If you have more than what you should have, then the website is sharing accounts among users and tracking the individual values internally.  Which would allow the website owner to loan out portions of the pooled balance, much like how fractional reserve banks do now, since they don't actually keep your money on hand.  If there has been any transactions in or out of said accounts that you didn't perform, then that means the website owner is using member accounts to "float" his own activities.

EDIT:  Except I can't actually see all of the addresses used in my Mybitcoin.com account.  That's going to be something I need to ask for.

I don't think mybitcoin.com really works the way you think it does. I think it actually is just one big pool so far as bitcoin is concerned. mybitcoin.com then keeps its own database of accounts. afaik

[theymos]

Some people have been concerned about powerful pools with >50% of the CPU power, so I added a log of reorg events:
http://blockexplorer.com/q/reorglog

If someone with a lot of CPU tries to reverse transactions, it will appear in that log as several sequential blocks being replaced. A few non-sequential replacements now and then are normal.

[davout]

Some people have been concerned about powerful pools with >50% of the CPU power, so I added a log of reorg events:
http://blockexplorer.com/q/reorglog

If someone with a lot of CPU tries to reverse transactions, it will appear in that log as several sequential blocks being replaced. A few non-sequential replacements now and then are normal.

That's just awesome. Thank you !

[cypherdoc]

that is awesome! 

theymos, i assume ur monitoring this regularly (several times a day?) and would let us all know?

[davout]

He'd sell his coins first but then yes, he'd let us all know

[TraderTimm]

Some people have been concerned about powerful pools with >50% of the CPU power, so I added a log of reorg events:
http://blockexplorer.com/q/reorglog

If someone with a lot of CPU tries to reverse transactions, it will appear in that log as several sequential blocks being replaced. A few non-sequential replacements now and then are normal.

This is extremely useful. All it needs is a dedicated website "Block Watch" and a alert level associated with it

Thank you for providing this.

[joan]

Super !
Maybe display them in reverse chronological so the most recent are on top ?

[cypherdoc]

All it needs is a dedicated website "Block Watch" and a alert level associated with it

Now THAT is a good idea.  Even clever name.

[theymos]

that is awesome! 

theymos, i assume ur monitoring this regularly (several times a day?) and would let us all know?

I am not monitoring it. BBE will automatically stop updating if 5 or more blocks are replaced, though, and I will know about this event. (There is not yet any warning on the main BBE page after this happens, though I'll probably add one sometime in the future.)

This is extremely useful. All it needs is a dedicated website "Block Watch" and a alert level associated with it

Thank you for providing this.

You can make such a site, polling my page. Don't increase the alert level at all for a single replaced block. Increase it in an exponential way for each replaced block after one.

Polling quirk: if 5 or more blocks are replaced, the reorglog page will not log all five replacements. Instead, one replacement will be logged and then the last line will be:

Code:

Reorg limit: system shutdown

The alert level should increase when BBE is down, since it would be easy for an attacker to take down my site. However, my uptime has not been incredible in the past, so it should maybe only increase slowly in such a case...

Super !
Maybe display them in reverse chronological so the most recent are on top ?

I don't feel like redoing all of my testing of this to reverse the order. Logs are traditionally in chronological order, anyway.

[bitcool]

Thanks. Looks this is what I've been looking for. I don't quite understand your table definition though. Does "WHERE inputs IS NULL" restrict result only to coin-generation transactions?

It eliminates spent outputs. The total value of unspent outputs should equal the total BTC in circulation (as it does).

The LEFT JOIN matches each output with the input that spent it. If inputs IS NULL for a row, then the output is unspent.

I intend to release my getblock-to-SQL script at some point in the far future, since it allows easy access to stats like this. It's much too messy right now, though.

Is this the same method being used on you site?
  http://blockexplorer.com/q/totalbc

I hope you can consider providing these service to function as an early warning system for the bitcoin network.

[theymos]

Is this the same method being used on you site?
  http://blockexplorer.com/q/totalbc

I hope you can consider providing these service to function as an early warning system for the bitcoin network.

It's not.

The value returned with the SQL is now actually less than the "ideal" number, as some miners have thrown away block reward BTC. I might make a /q page for it eventually, as the difference is interesting.

[lfm]

Is this the same method being used on you site?
  http://blockexplorer.com/q/totalbc

I hope you can consider providing these service to function as an early warning system for the bitcoin network.

It's not.

The value returned with the SQL is now actually less than the "ideal" number, as some miners have thrown away block reward BTC. I might make a /q page for it eventually, as the difference is interesting.

It only one block (#124724) that doesn't balance this way so far. He was intending to throw away 0.00000001 BTC but accidentally also dropped a fee of 0.01 BTC so he made 0.01000001 BTC in all disappear. Of course its not really any different effect than someone losing their wallet.dat file. The value is gone either way.
For reporting purposes it could be credited to a special "lost" account address.

[John Tobey]

The value returned with the SQL is now actually less than the "ideal" number, as some miners have thrown away block reward BTC. I might make a /q page for it eventually, as the difference is interesting.

Abe now supports totalbc but reports the measured number (e.g., 7017349.98999999) rather than the "ideal" value BBE gives.  I do not plan to implement totalbc for future blocks.

http://abe.john-edwin-tobey.org/chain/Bitcoin/q/totalbc

[theymos]

The network provider for the server reports that there will be an outage from 5 PM to 6 PM Central US time on the 20^th for maintenance.

I don't know what you would do with this information, but I thought I'd pass it on...