CryptoCoin Explorer - Coin Block Explorers.

[dreamwatcher]

UPDATE:

I have changed the database type used with the Terracoin explorer in an effort to stop the database access deadlock occurring with the explorers.

The issue seems more predominant with the Terracoin explorer, which is strange in itself as the Terracoin explorer required the least amount of modification of ABE.

I will closely monitor the change over the next few days, but hopefully this will help fix the deadlock issue occurring with all three explorers.

[dreamwatcher]

Hmm, the Freicoin explorer just  database deadlocked.

I would like to get a few opinions:

For a multi-process enviroment, each R/W its own database.

Is MySQL or POSTGRES a better choice? Or should I consider SQLITE?

Added: ABE is  running in Python 2.7 for each of the explorers.

[Sunny King]

Hmm, the Freicoin explorer just  database deadlocked.

I would like to get a few opinions:

For a multi-process enviroment, each R/W its own database.

Is MySQL or POSTGRES a better choice? Or should I consider SQLITE?

Added: ABE is  running in Python 2.7 for each of the explorers.

Are all three explorers run on the same database instance? Which database backend are you using right now?

[dreamwatcher]

Hmm, the Freicoin explorer just  database deadlocked.

I would like to get a few opinions:

For a multi-process enviroment, each R/W its own database.

Is MySQL or POSTGRES a better choice? Or should I consider SQLITE?

Added: ABE is  running in Python 2.7 for each of the explorers.

Are all three explorers run on the same database instance? Which database backend are you using right now?

Different databases and logins, but 1 database server. (Well 2 now, MySql and POSTGRES)

As of now - PPC and Feicoin are using MySql and Terracoin is using POSTGRES

[Sunny King]

Different databases and logins, but 1 database server. (Well 2 now, MySql and POSTGRES)

As of now - PPC and Feicoin are using MySql and Terracoin is using POSTGRES

If you are already using mysql & postgres those are very solid database engines so most likely it's the abe code needs some work to eliminate deadlock issues.

[dreamwatcher]

Well, I have thought of a couple things I can do, both of which can be done or just one or the other.

1. ABE is actually designed to handle multiple chains in a single instance. I have not perused this due to the modifications needed for PPC and FRC. I would have to code quite a large amount of conditional statements, and basically it would be like starting from square one.

Advantages - I could run 3 or 4 ABE instances, with some attached to MySQL and some attached to POSTGRES. I could then load balance incoming requests between the ABE instances.
Disadvantages - Lot of code work

2. I did a little investigation into cost, I have found it would actuality be cheaper to upgrade my Internet access and get a static address, then to continue just having a personal level of Internet access and pay separately for the VPS.
I have plenty of hardware stocked where I could make a real server which would perform much better then a VPS and a couple of commercial grade routers (older, but would work fine for this).

Advantages - Cheaper while providing better service

Disadvantages - All maintenance and security is on my shoulders, nobody to call if it all goes to crap.

[crazy_rabbit]

I was curious if you could find a way to add a "Richest Addresses" feature to the explorer? I would be curious to know who the richest TRC addresses are. :-)

[crazyearner]

Is their a reason why it takes so long to confirm and says for block 16/504 more blocks to be confirmed before payment. Is that by total network or by me alone ?

[dreamwatcher]

Is their a reason why it takes so long to confirm and says for block 16/504 more blocks to be confirmed before payment. Is that by total network or by me alone ?

PPC has always used 520 confirmations for block maturity for both POW and POS blocks.

You could study the White paper, or browse the official git site.

www.ppcoin.org/static/ppcoin-paper.pdf

https://github.com/ppcoin/ppcoin

Sunny's Official thread

https://bitcointalk.org/index.php?topic=101820.0


FuzzyBear PPC website:

http://ppcointalk.org/

[dreamwatcher]

I was curious if you could find a way to add a "Richest Addresses" feature to the explorer? I would be curious to know who the richest TRC addresses are. :-)

I will look into adding this and other features during the site revamp I am currently working on. Thanks for the suggestion.

Suggestion for Terracoin part of explorer:

User can select 20, 50, 100 or 2016 blocks listed per page, but none of those values matter with Terracoin. Values that make sense are
30, 60, 120, 150, 300, 600 and eventualy 1200.

I see no reason why this cannot be done. I will implement it during the revamp.

I am curious as to why those values make for better use?

[crazy_rabbit]

Awesome!

[dreamwatcher]

Cryptocoin explorer is back up. I apologize for any inconvenience.

Unfortunately the  outage will delay the revamp for a short time.

[crazyearner]

any news for when terracoin will be working

[crazy_rabbit]

Down for me as well. :-(

[Vitalicus]

http://www.cryptocoinexplorer.com:2750/
A server error occurred.  Please contact the administrator.

[dreamwatcher]

Should be back up.

I am still having issues with database deadlock and continue to try and find a solution. Strangely enough it is still mostly with TRC and not PPC or FRC.

I am considering changing to a blockchain.info type system, now that the base system is available on github.

* I have changed the TRC search shortcuts to reflect 30,60,120,480 and 1920 items.




I have been busy over the last few weeks with things other than cryptocoinexplorer, though I should have a bit more time now. However spring semester started last week, so I will try my best to dedicate some time to cryptocoinexplorer.

[dreamwatcher]

http://www.cryptocoinexplorer.com:2750/
A server error occurred.  Please contact the administrator.

That error was due to a mysql security update and should be up now. (Both PPC and FRC)

[crazy_rabbit]

I think the TRC dameon needs to be restarted. :-)

[crazy_rabbit]

Should be back up.

I am still having issues with database deadlock and continue to try and find a solution. Strangely enough it is still mostly with TRC and not PPC or FRC.

I am considering changing to a blockchain.info type system, now that the base system is available on github.

* I have changed the TRC search shortcuts to reflect 30,60,120,480 and 1920 items.




I have been busy over the last few weeks with things other than cryptocoinexplorer, though I should have a bit more time now. However spring semester started last week, so I will try my best to dedicate some time to cryptocoinexplorer.

Do you think you could post a link to the blockchain.info on github?

thanks!

[dreamwatcher]

Should be back up.

I am still having issues with database deadlock and continue to try and find a solution. Strangely enough it is still mostly with TRC and not PPC or FRC.

I am considering changing to a blockchain.info type system, now that the base system is available on github.

* I have changed the TRC search shortcuts to reflect 30,60,120,480 and 1920 items.




I have been busy over the last few weeks with things other than cryptocoinexplorer, though I should have a bit more time now. However spring semester started last week, so I will try my best to dedicate some time to cryptocoinexplorer.

Do you think you could post a link to the blockchain.info on github?

thanks!

https://github.com/zootreeves/blockchain.info

Lots and lots of JavaScript, after familiarizing myself with python for ABE, now I have to do the same with JavaScript development..