I want to develop a web app like etherscan. I realized I have to extract and index all datas in a relational database. I have chosen Posturesql. All Datas I want to save are:
- transaction receipt
- transaction trace
- smart contract details
And I use geth IPC.
But it's not stable and it's to slow for my purpose.
What is the best practices? Is there another way to get all datas from genesis block to the last one? Can I read directly from the leveldb? How?