←back to thread

Show HN: Chain Traverser – Fast Ethereum graph explorer

(dictynna.com)
53 points anophelon | 1 comments | 13 Oct 24 19:21 UTC | HN request time: 0.203s | source
Show context
C-Loftus ◴[14 Oct 24 00:12 UTC] No.41832907[source]▶
Is anyone using graph databases or sparql for these sorts of use cases? sparql is so powerful but not sure if there is enough metadata with ethereum for it to be useful.
replies(3): >>41833118 #>>41834438 #>>41834975 #
1. anophelon ◴[14 Oct 24 07:05 UTC] No.41834975[source]▶
I initially tried using Memgraph but faced stability issues and a lack of flow control tools during traversal, making it impossible to load one month’s worth of Ethereum blockchain data. The current solution, however, handles 10 times more data hosted on the same machine.

ClickHouse is an excellent database, provided you don't need to traverse graphs. Graph traversal requires many queries, and frequent disk interactions can significantly degrade performance.