coinos-server.git/scripts, branch regtest-fulcrum

scripts: add dedup-invoices cleanup for already-duplicated :invoices

2026-06-18T14:41:21Z

The source fix (LPOS guard in generate, 2d2f9856) stops NEW duplicate entries but doesn't remove the ones already accumulated. This one-time script scrubs them: scans every :invoices list and removes duplicate ids, keeping each id's original creation-order position. Dry-run by default; pass --apply to write. Idempotent. Scope on a recent prod snapshot: 2,785 of 8,735 lists had dupes (16,363 duplicate entries). Co-Authored-By: Claude Opus 4.8 (1M context)

scripts: add wiped-history audit and rebalance-economics model

2026-06-13T21:21:53Z

audit-wiped-history.ts (read-only) finds accounts whose :payments index was wiped by the changeid bug — balance>0 with empty history in both db and arc. rebalance-economics.ts models whether the lightning->liquid bridge throughput is fee-positive against on-chain rebalance cost. Co-Authored-By: Claude Opus 4.8 (1M context)

analytics: missing-history audit + lightning->liquid arb finder

2026-06-04T19:14:15Z

audit-missing-history.ts: read-only audit classifying every user's payment history as clean / recoverable (record in arc not db) / lost (gone from both). Full-scan finding: of 6,330 users with history, 77% are "arc-only" which is the NORMAL archived state — the payments route reads via gf() (archive fallback) so those render fine in the app. True loss is 58 users / 59 records (0.02%). So there is no widespread history loss; "missing history" reports are almost always either dropped receive-callbacks (record never written, like apk403's 1100 sats) or one of the rare 59. ln-liquid-arb.ts: finds users funding via lightning and withdrawing via liquid (the pattern draining the liquid hot wallet / forcing threshold cuts). Reports per-user through-flow + net liquid drainers. Co-Authored-By: Claude Opus 4.8 (1M context)

analytics: --csv flag for month-over-month trend tracking

2026-06-04T07:42:15Z

Appends one metrics row per run to a CSV (header written if file is new): date, users, MAU/WAU, payments, volume, custody, fee revenue, bolt12 recipients, and per-type volume/txn columns. Notice goes to stderr so it doesn't pollute the saved stdout report or --json output. Drives the new monthly snapshot cron (~/scripts/analytics-cron.sh). Co-Authored-By: Claude Opus 4.8 (1M context)

analytics: monthly insight reports + signup instrumentation

2026-06-04T06:10:20Z

scripts/analytics.ts — streams live db (SCAN, never KEYS) and reports for a trailing window (default 30d): MAU/WAU, new users, custody total + top holders, network volume by type (lightning/liquid/bitcoin/internal/bolt12/ fund), most-active and highest-volume users, and bolt12 recipients with a "regular" flag for the Ocean mining-reward stream. scripts/analytics-geo.ts — top countries from the request log. Counts only /login + /register events tied to a username (raw cf-ipcountry volume is dominated by datacenter/nostr traffic). Surfaces a distinct-IP-per-country column so proxy/VPN egress is visible, and filters a known credential-test bot IP. Honest result: US #1, then GB/CA/JP/DE/ES/BR. lib/register.ts — stamp `created` (ms epoch) and store `country` (CF/ ipregistry code) on new users, so future reports get real signup timing and geography from the db directly instead of log archaeology. Existing users predate this; backfill is out of scope. Co-Authored-By: Claude Opus 4.8 (1M context)

catch reverse errors

2026-03-17T05:53:11Z

adjust ln minfee

2026-03-15T22:49:17Z

handle socket errors

2026-02-25T20:06:04Z

tech debt jubilee

2023-01-09T05:05:34Z

prettier

2022-09-06T16:20:25Z