jed
Are you looking in the stellar core DB for this site?
No, I'm using fully-synced Horizon DB instance with some optimizations for queries performance (materialized views, triggers etc). Stellar-core DB has only up-to-date information on the accounts and ledgers status. In order to query historical data, I have to rely on the history_effectstable.
By the way, I stumbled upon the strange thing:
select count(*) from accounts
returns 81048
-- increment counter for account_created effect and decrement on account_removed
SELECT sum(CASE WHEN type = 0 THEN 1 WHEN type = 1 THEN -1 END)
FROM history_effects
WHERE type IN (0, 1)
returns 80890
Horizon and Core are fully synced, history_latest_ledger = core_latest_ledger. My only guess is that core DB at this time holds only the last 282,911 ledgers, while history DB contains all ledgers from the sequence 1. Nevertheless, it looks like the core db shouldn't hold dead accounts, so I'm confused here. Am I missing something?
OrbitLens: for the bugtracker you could just use github issues.
You see, I'm an old fan of Atlassian Jira ?, YouTrack also performs nicely. I'm going to compare both and see where the basic cloud plan has free public accounts feature.
I would just call it "# of accounts"
? will rename it on the next release.
If you have any other ideas on the features or UX, I will be grateful for feedback.
