Can’t believe it’s already the end of 2025. Time went by way too fast, feels like there’s still so much I haven’t finished yet. Am I slow… or is time just speeding up? 😛

This month was very heads-down, focusing on NEM Explorer backend work, especially around account processing. Most of the effort went into refining sync workflows, database schemas, and making sure the foundations are solid before moving faster.

Summary of Key Work

• Designed and implemented accounts database schemas
• Developed account processing logic based on transactions and blocks.
• Integrated account processing into the block sync workflow
• Added multisig information and owned mosaics support in lightapi/python
• Implemented reusable retry logic
• Researched and wrote a Qiita Article

Work

Nem Explorer (Account processing)

• Accounts are a core concept in any blockchain. To ensure all relevant accounts are stored correctly, I implemented logic to extract account addresses from all transaction types and block signer.
• Once accounts are identified, the system queries account information and owned mosaics from the node. To avoid request failures or timeout, I added retry logic that re-queries the node a fixed number of times before giving up.
• The retrieved data is then processed and persisted into the database as part of the account pipeline.

Lightapi / Python

• To support complete account data in the Explorer, I extended LightAPI by adding missing endpoint and fields