Bitcoin Forum
December 05, 2016, 10:53:08 AM *
News: To be able to use the next phase of the beta forum software, please ensure that your email address is correct/functional.
 
   Home   Help Search Donate Login Register  
Pages: « 1 2 [3] 4 5 »  All
  Print  
Author Topic: Bitcoin Block Explorer  (Read 27046 times)
bitcool
Legendary
*
Offline Offline

Activity: 1441

Live and enjoy experiments


View Profile
February 09, 2011, 04:27:28 AM
 #41

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.
1480935188
Hero Member
*
Offline Offline

Posts: 1480935188

View Profile Personal Message (Offline)

Ignore
1480935188
Reply with quote  #2

1480935188
Report to moderator
1480935188
Hero Member
*
Offline Offline

Posts: 1480935188

View Profile Personal Message (Offline)

Ignore
1480935188
Reply with quote  #2

1480935188
Report to moderator
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction. Advertise here.
1480935188
Hero Member
*
Offline Offline

Posts: 1480935188

View Profile Personal Message (Offline)

Ignore
1480935188
Reply with quote  #2

1480935188
Report to moderator
1480935188
Hero Member
*
Offline Offline

Posts: 1480935188

View Profile Personal Message (Offline)

Ignore
1480935188
Reply with quote  #2

1480935188
Report to moderator
1480935188
Hero Member
*
Offline Offline

Posts: 1480935188

View Profile Personal Message (Offline)

Ignore
1480935188
Reply with quote  #2

1480935188
Report to moderator
theymos
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
February 27, 2011, 11:14:02 AM
 #42

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...)

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
theymos
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
March 06, 2011, 06:42:28 AM
 #43

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

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
theymos
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
May 06, 2011, 02:04:03 AM
 #44

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.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
hacim
Member
**
Offline Offline

Activity: 64


View Profile
May 15, 2011, 04:28:29 AM
 #45

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!

15yns1RVpBHZ8uj8mGVUJVCyPh5ieW3FQx
theymos
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
May 15, 2011, 06:14:25 AM
 #46

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.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
lfm
Full Member
***
Offline Offline

Activity: 196



View Profile
May 28, 2011, 06:26:33 AM
 #47

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
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
June 09, 2011, 01:06:14 PM
 #48

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.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
davout
Legendary
*
Offline Offline

Activity: 1358


1davout


View Profile WWW
June 09, 2011, 03:56:47 PM
 #49

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
Legendary
*
Offline Offline

Activity: 1764



View Profile
June 09, 2011, 04:08:31 PM
 #50

that is awesome! 

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

Activity: 1358


1davout


View Profile WWW
June 09, 2011, 04:14:16 PM
 #51

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

TraderTimm
Legendary
*
Offline Offline

Activity: 1652



View Profile
June 09, 2011, 04:14:31 PM
 #52

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 Smiley

Thank you for providing this.

fortitudinem multis - catenum regit omnia
joan
Jr. Member
*
Offline Offline

Activity: 56



View Profile
June 09, 2011, 04:27:22 PM
 #53

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

Activity: 1764



View Profile
June 09, 2011, 05:09:24 PM
 #54

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


Now THAT is a good idea.  Even clever name.
theymos
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
June 09, 2011, 05:51:51 PM
 #55

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 Smiley

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.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
bitcool
Legendary
*
Offline Offline

Activity: 1441

Live and enjoy experiments


View Profile
June 11, 2011, 04:10:52 PM
 #56

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
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
June 11, 2011, 04:51:28 PM
 #57

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.

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
lfm
Full Member
***
Offline Offline

Activity: 196



View Profile
June 19, 2011, 01:48:38 PM
 #58

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
Hero Member
*****
Offline Offline

Activity: 481



View Profile WWW
August 10, 2011, 04:50:37 AM
 #59

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

Can a change to the best-chain criteria protect against 51% to 90+% attacks without a hard fork?
theymos
Administrator
Legendary
*
Offline Offline

Activity: 2492


View Profile
June 19, 2012, 06:33:08 AM
 #60

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

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

1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
Pages: « 1 2 [3] 4 5 »  All
  Print  
 
Jump to:  

Sponsored by , a Bitcoin-accepting VPN.
Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!