Store bitcoin transactions in mysql How can I use the jsonRPC for the bitcoin client to export the chain into mysql and then sync the two as transactions come in? I'm writing a blockchain explorer for a new alt coin and unfortunately ABE won't work for this particular coin. I can query the chain using jsonRPC just fine for each transaction but I want to be able to store the chain in mySQL for speed and efficiency later on. 

Preferred technologies: php &amp; mysql.
You can't use jsonRPC to do this, because jsonRPC commands like gettransaction only work for wallet addresses you have in your wallet.  They don't work for arbitrary addresses.

Sites like blockchain.info basically read the physical blockchain files, not using jsonRPC.  You could do something similar.  I've heard that bitcoinj may do what you want, but I've never used that library.  You also want to check into Bitcore from BitPay.