Details

Reviewers

None

Group Reviewers

Restricted Project

Summary

It would be nice to know how many active addresses we have on the eCash network. This information is available onchain but, since its main value is analysis and not app functionality, it is not indexed elsewhere.

This is the kind of thing metachronik is designed to index.

Add some indexing for unique scripts seen onchain. Ignore OP_RETURN and EMPP scripts which are handled separately.

Goals

What is the Monthly Active User stat for the eCash network? How does this change with time?
What is growth of eCash addresses like on the network?
How has address behavior changed before and after major forks?

Test Plan

npm test

Diff Detail

Repository

rABC Bitcoin ABC

Branch

active-addrs

Lint

Lint Errors

Severity	Location	Code	Message
Error	apps/metachronik/mocks/blockTxs.ts:4	ESLINT	header/header
Error	apps/metachronik/mocks/blockTxs.ts:35379	ESLINT	eol-last
Error	apps/metachronik/test_indexer_with_mocks.js:1	ESLINT	header/header
Error	apps/metachronik/test_mock_indexing.js:1	ESLINT	header/header
Error	apps/metachronik/test_mock_indexing.js:7	ESLINT	@typescript-eslint/no-unused-vars
Error	apps/metachronik/test_mock_indexing.js:36	ESLINT	@typescript-eslint/no-unused-vars

Unit

No Test Coverage

Build Status

Buildable 34066
Build 67601: Build Diff
Build 67600: arc lint + arc unit

Event Timeline

bytesofman created this revision.Aug 5 2025, 18:38

Herald added a reviewer: Restricted Project. · View Herald TranscriptAug 5 2025, 18:38

Harbormaster completed remote builds in B34049: Diff 55106.Aug 5 2025, 18:38

lint, update dockerfile for ci deploys

Harbormaster completed remote builds in B34050: Diff 55107.Aug 5 2025, 18:46

use materialized views for script activity

Harbormaster completed remote builds in B34052: Diff 55109.Aug 5 2025, 22:15

distinctions between spent and active, clean up original schema

Harbormaster completed remote builds in B34061: Diff 55118.Aug 6 2025, 17:31

schema changes

Harbormaster completed remote builds in B34066: Diff 55125.Aug 7 2025, 16:54

more iterating, add charts

Harbormaster completed remote builds in B34067: Diff 55128.Aug 7 2025, 22:00

still need to do this but fell off the radar. not high priority at the moment, should improve metachronik and add simpler stuff first that is solving a problem and not an info wish.

[metachronik] Add indexing for addresses by activity
AbandonedPublicDraft
Actions

Details

Diff Detail

Event Timeline

Revision Contents
Changeset List

Diff 55125

apps/metachronik/SCRIPT_ACTIVITY_SCHEMA.md

apps/metachronik/migration.sql

apps/metachronik/mocks/blockTxs.ts

apps/metachronik/package-lock.json

apps/metachronik/package.json

apps/metachronik/src/database/schema.sql

apps/metachronik/src/index.ts

apps/metachronik/src/services/tests/scriptParser.test.ts

apps/metachronik/src/services/chronik.ts

apps/metachronik/src/services/database.ts

apps/metachronik/src/types/index.ts

apps/metachronik/src/utils/scriptParser.ts

apps/metachronik/test_indexer_with_mocks.js

apps/metachronik/test_mock_indexing.js

metachronik.Dockerfile

[metachronik] Add indexing for addresses by activityAbandonedPublicDraftActions

Details

Diff Detail

Event Timeline

Revision ContentsChangeset List

Diff 55125

apps/metachronik/SCRIPT_ACTIVITY_SCHEMA.md

apps/metachronik/migration.sql

apps/metachronik/mocks/blockTxs.ts

apps/metachronik/package-lock.json

apps/metachronik/package.json

apps/metachronik/src/database/schema.sql

apps/metachronik/src/index.ts

apps/metachronik/src/services/__tests__/scriptParser.test.ts

apps/metachronik/src/services/chronik.ts

apps/metachronik/src/services/database.ts

apps/metachronik/src/types/index.ts

apps/metachronik/src/utils/scriptParser.ts

apps/metachronik/test_indexer_with_mocks.js

apps/metachronik/test_mock_indexing.js

metachronik.Dockerfile

[metachronik] Add indexing for addresses by activity
AbandonedPublicDraft
Actions

Revision Contents
Changeset List

apps/metachronik/src/services/tests/scriptParser.test.ts