New year, new chapter. Wishing everyone good health, fresh goals, and new hopes as we set sail into what’s ahead. 🏴‍☠️

Kicking off the year with a strong focus on NEM Explorer. A lot of back-and-forth with PR feedback, refining logic, and slowly shaping the backend into something more accurate and reliable.

Summary of Key Work

• Completed harvesting fees logic and integrated into database
• Discovered and utilized beneficiary and totalFee from API
• Progressed on /account and /accounts endpoints
• Added beneficiary support in lightapi/python
• Improved test coverage and addressed multiple PR feedback cycles

Work

Nem Explorer (Puller)

• Discovered that beneficiary and totalFee are available directly from the API, which reduces the need for additional network calls during block processing.
• Initially implemented harvesting fees calculation based on block data, but later removed it since totalFee from the API can be used directly, making manually calculation unnecessary.
• Added beneficiary (harvester) field into database schema. Previously I relied on the block signer public key and performed extra lookups to resolve the actual beneficiary (since the singer can be remote account). This change eliminates additional API calls.
• Continued improving account processing logic and added more unit tests.

**Nem Explorer (**REST API)

• Added a new  /account endpoint, allowing the frontend to query account information by public key or address.
• Introduced a /accounts listing endpoint with support for pagination, and sorting balance and filtering by harvesting status.