wtf is solana-realtime-indexer?

solana-realtime-indexer is a work in progress tool, written in Rust, that watches trading activity on the Solana blockchain in real time, specifically for two trading platforms called pump.fun and PumpSwap. It listens to a live stream of blockchain activity, figures out which parts of that activity are actual trades, and saves them into a Postgres database. The author explains a few specific problems this project is trying to solve well. First, it looks at what actually happened in a trade rather than just what a user originally requested, since the price can move between the moment someone asks to buy and the moment the trade actually completes, so reading only the request would give wrong numbers. Second, it looks inside transactions that route through other programs before reaching pump.fun, since a lot of trading volume happens this way and a tool that only checks the surface level of a transaction would miss those trades entirely. Third, it gives every individual trade a reliable unique identifier built from several pieces of information together, because the simpler approach most similar tools use can accidentally treat two separate trades within the same transaction as if they were the same one, losing data. The project also includes a way to record raw blockchain traffic to a file and play it back later through the same processing logic, which is how its automated tests confirm that the same input always produces the same output without needing a live network connection. To try it, someone would clone the repository, copy an example settings file, and run the built in test suite, which uses a small saved sample of blockchain data and finishes in about a quarter of a second. Running it against live mainnet trading data requires a Yellowstone gRPC connection, a way of streaming blockchain data, configured in the settings file. According to the README, live decoding, database schema setup, and reliable trade replay already work, while a proper database writing pipeline and a query interface are still planned. The project has no GitHub stars yet and is released under the MIT license.