bitcool
Legendary
Offline
Activity: 1441
Merit: 1000
Live and enjoy experiments
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 09, 2011, 04:27:28 AM |
|
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.
|
|
|
|
theymos (OP)
Administrator
Legendary
Offline
Activity: 5306
Merit: 13237
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
February 27, 2011, 11:14:02 AM |
|
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 (OP)
Administrator
Legendary
Offline
Activity: 5306
Merit: 13237
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
March 06, 2011, 06:42:28 AM |
|
|
1NXYoJ5xU91Jp83XfVMHwwTUyZFK64BoAD
|
|
|
|
hacim
Member
![*](https://bitcointalk.org/Themes/custom1/images/star.gif)
Offline
Activity: 64
Merit: 10
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 15, 2011, 04:28:29 AM |
|
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 (OP)
Administrator
Legendary
Offline
Activity: 5306
Merit: 13237
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 15, 2011, 06:14:25 AM |
|
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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
May 28, 2011, 06:26:33 AM |
|
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 (OP)
Administrator
Legendary
Offline
Activity: 5306
Merit: 13237
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 09, 2011, 01:06:14 PM |
|
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/reorglogIf 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
Activity: 1372
Merit: 1007
1davout
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 09, 2011, 03:56:47 PM |
|
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/reorglogIf 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
Activity: 1764
Merit: 1002
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 09, 2011, 04:08:31 PM |
|
that is awesome!
theymos, i assume ur monitoring this regularly (several times a day?) and would let us all know?
|
|
|
|
davout
Legendary
Offline
Activity: 1372
Merit: 1007
1davout
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 09, 2011, 04:14:16 PM |
|
He'd sell his coins first but then yes, he'd let us all know ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif)
|
|
|
|
TraderTimm
Legendary
Offline
Activity: 2408
Merit: 1121
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 09, 2011, 04:14:31 PM |
|
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/reorglogIf 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](https://bitcointalk.org/Smileys/default/smiley.gif) Thank you for providing this.
|
fortitudinem multis - catenum regit omnia
|
|
|
joan
Jr. Member
Offline
Activity: 56
Merit: 1
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 09, 2011, 04:27:22 PM |
|
Super ! Maybe display them in reverse chronological so the most recent are on top ?
|
|
|
|
cypherdoc
Legendary
Offline
Activity: 1764
Merit: 1002
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 09, 2011, 05:09:24 PM |
|
All it needs is a dedicated website "Block Watch" and a alert level associated with it ![Smiley](https://bitcointalk.org/Smileys/default/smiley.gif) Now THAT is a good idea. Even clever name.
|
|
|
|
theymos (OP)
Administrator
Legendary
Offline
Activity: 5306
Merit: 13237
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 09, 2011, 05:51:51 PM |
|
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](https://bitcointalk.org/Smileys/default/smiley.gif) 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: 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
Activity: 1441
Merit: 1000
Live and enjoy experiments
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 11, 2011, 04:10:52 PM |
|
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/totalbcI hope you can consider providing these service to function as an early warning system for the bitcoin network.
|
|
|
|
theymos (OP)
Administrator
Legendary
Offline
Activity: 5306
Merit: 13237
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 11, 2011, 04:51:28 PM |
|
Is this the same method being used on you site? http://blockexplorer.com/q/totalbcI 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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 19, 2011, 01:48:38 PM |
|
Is this the same method being used on you site? http://blockexplorer.com/q/totalbcI 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
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
August 10, 2011, 04:50:37 AM |
|
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 (OP)
Administrator
Legendary
Offline
Activity: 5306
Merit: 13237
|
![](https://bitcointalk.org/Themes/custom1/images/post/xx.gif) |
June 19, 2012, 06:33:08 AM |
|
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
|
|
|
|