Is there a database of all transactions?

2

1

The blockchain is a database of all valid transactions, but is there a company/project that also logs all transactions which were broadcasted, but didn't made it to the chain? Blockchain.info for example, keeps a history of all double-spends, so I assume they keep such a log, but its not publicly available.

I could very easily calculate how much was lost by transaction maleability if something like that was publicly available.

Muis

Posted 2014-02-27T10:54:19.233

Reputation: 1 897

1Blockchain info does not keep for a long time double spend transactions. They keep them about several days.Zergatul 2014-02-27T11:00:06.230

@Zergatul That their interface doesnt show any older than a few days, doesnt necessarly mean they are not stored in their database. I would be surprised if they took the effort to actually delete them, since they require virtually no space compared to the valid tx's.Muis 2014-02-27T11:13:00.027

1If this is true, someone can easily spam their database.Zergatul 2014-02-27T11:45:12.963

@Zergatul Good point!Muis 2014-02-27T11:49:58.657

Answers

0

I haven't seen anything that is tracking all transaction including failed ones, etc although this project looks like it has promise:

http://codesuppository.blogspot.co.uk/2013/07/work-in-progress-on-bitcoin-blockchain.html

That said I'm not even certain what your suggesting would be possible. Consider the following scenario.

If a person / organisation were monitoring and recording all transactions and I were to submit a transaction that then where then to be marked invalid and discarded, the nature of bitcoin is that you send your transaction to peer nodes who in turn will broadcast those out if they verify the transaction. Now If someone can explain to me otherwise than fine but surely this transaction would only have a limited number of broadcasts before a different chain showing it to be be invalid was received and the erroneous block discarded. Now unless the 'monitoring party' where within the peers that received the broadcast there would be no way for them to track it?

hafnero

Posted 2014-02-27T10:54:19.233

Reputation: 841

0

Muis, a friend and I are working on that exact project. We want to track which transactions get mined and how long it takes different types of to get mined.

Its kind of a large ugly monster right now but we are actively working on it. The database of transactions is stored in a postgresdb.

Check it out: https://github.com/NSkelsey/TxWaitTime

Nick Skelsey

Posted 2014-02-27T10:54:19.233

Reputation: 1