tidx@0.7.0

Minor Changes

• Added decoded stablecoin-DEX event tables dex_pairs, dex_orders, and dex_fills as insert-time ClickHouse materialized views over logs. dex_fills denormalizes the OrderFilled/OrderPlaced join at ingest (token, side, tick attached per fill, ordered by (token, block_num, log_idx)), turning pair-swap and OHLC scans into a primary-key range read instead of a join plus correlated subquery. (by @jxom, #227)
• Added dex_pair_liquidity, a ClickHouse view that joins dex_pairs to the DEX escrow balances in token_balances_snapshot, so the exchange pairs-by-liquidity endpoint can read ranked pairs directly instead of over-fetching escrow balances and intersecting base/quote pairs in memory. (by @jxom, #227)
• Added token_holder_counts, a refreshable ClickHouse materialized view that pre-aggregates per-token holder counts from token_balances_snapshot, so token detail and holder endpoints hit a point lookup instead of a high-cardinality count() scan over every holder row. (by @jxom, #226)

Patch Changes

• Denormalized the tx-level type and fee_token onto the ClickHouse receipts table (populated from the matching tx at ingest, with a migration for existing deployments), so receipt-list queries no longer have to join txs to read those fields. (by @jxom, #230)

What's Changed

• chore: sync Cargo.lock with tidx 0.6.1 by @jxom in #211
• Set Postgres statement timeout for TIDX pools by @decofe in #212
• ci: add PR audit workflow by @decofe in #215
• fix: PR audit comment token by @legion2002 in #216
• [codex] fix PR audit author association check by @legion2002 in #217
• [codex] allow same-repo PR audit comments by @legion2002 in #218
• fix: repair ClickHouse derived backfill gaps by @kamsz in #220
• fix: run ClickHouse derived repairs in background by @kamsz in #221
• fix: make ClickHouse derived repairs resilient by @kamsz in #222
• Chunk receipt backfill writes by @kamsz in #223
• feat(clickhouse): denormalize tx type/fee_token onto receipts by @jxom in #230
• feat(clickhouse): add decoded stablecoin-DEX event tables by @jxom in #227
• feat(clickhouse): add token_holder_counts refreshable materialized view by @jxom in #226
• chore: release tidx@0.7.0 by @github-actions[bot] in #231

New Contributors

• @legion2002 made their first contribution in #216

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.6.1...tidx@0.7.0

tidx@0.6.1

Patch Changes

• Added token_balances_snapshot, a refreshable ClickHouse materialized view that pre-aggregates holder balances from token_holder_deltas on a schedule so holder counts and listings hit the primary key instead of timing out on high-cardinality tokens. (by @jxom, #208)

What's Changed

• Remove pgroll runtime migrations by @kamsz in #200
• fix: correct backfill progress eta by @kamsz in #201
• fix: avoid blocking startup on ClickHouse backfills by @kamsz in #202
• docs: use hosted TIDX indexer endpoints by @decofe in #203
• Validate ClickHouse PREWHERE expressions by @brendanjryan in #205
• Normalize ClickHouse function identifiers by @brendanjryan in #207
• Align ClickHouse query timeouts by @brendanjryan in #206
• feat: pre-aggregate holder balances via refreshable MV by @jxom in #208
• style: fix rustfmt failure on main from #208 by @jxom in #210
• chore: release tidx@0.6.1 by @github-actions[bot] in #209

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.6.0...tidx@0.6.1

tidx@0.6.0

Minor Changes

• Added ClickHouse materialized views for token and address analytics: token_transfers, token_balances, token_supply, token_approvals, token_transfer_stats, token_metadata, address_transfers, address_balances, address_txs, and contract_creations. Available when running with engine="clickhouse". (by @jxom, #198)

What's Changed

• fix: validate any all operands by @brendanjryan in #190
• fix: externalize rpc credentials by @brendanjryan in #195
• fix: bound query result sizes by @brendanjryan in #194
• fix: isolate query statement timeouts by @brendanjryan in #193
• fix: cap live query streams by @brendanjryan in #192
• fix: harden clickhouse query validation by @brendanjryan in #191
• feat: add clickhouse MVs by @jxom in #196
• chore: add changelog for clickhouse materialized views by @jxom in #198
• chore: release tidx@0.6.0 by @github-actions[bot] in #199

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.5.6...tidx@0.6.0

tidx@0.5.6

Patch Changes

• Added a consensus_proposer column to the blocks table for TIP-1031 (by @0xrusowsky, #178)

What's Changed

• feat(block): track consensus proposer pubkey by @0xrusowsky in #178
• veria: make status endpoint cheap by @goksu in #186
• veria: enforce clickhouse query row caps by @goksu in #187
• feat: support user ctes with event queries by @goksu in #188
• [codex] bump pgroll to v0.16.2 by @kuyziss in #189
• chore: release tidx@0.5.6 by @github-actions[bot] in #185

New Contributors

• @0xrusowsky made their first contribution in #178
• @kuyziss made their first contribution in #189

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.5.5...tidx@0.5.6

tidx@0.5.5

Patch Changes

• Harden PostgreSQL SQL validation by fixing CTE scope handling, schema-qualified table checks, recursive depth accounting, LIMIT ALL rejection, and traversal of previously unchecked AST clauses. (by @brendanryan, #179)
• Validate public ClickHouse queries, block system catalogs and dangerous table functions, enforce ClickHouse request timeouts, and validate view SELECT SQL before execution. (by @brendanryan, #180)
• Bound PostgreSQL query result processing by streaming rows with a hard request limit and appending automatic LIMIT clauses on a separate line. (by @brendanryan, #181)
• Hardened view administration by failing closed for trusted CIDR checks, rejecting malformed CIDR configuration, hot-reloading active trusted CIDRs, and requiring an explicit admin mutation header. (by @brendanryan, #182)

What's Changed

• ci: strengthen cargo verification by @brendanjryan in #183
• fix: bound postgres query results by @brendanjryan in #181
• fix: harden sql validator traversal by @brendanjryan in #179
• fix: harden admin view access by @brendanjryan in #182
• fix: validate clickhouse queries by @brendanjryan in #180
• chore: release tidx@0.5.5 by @github-actions[bot] in #184

New Contributors

• @brendanjryan made their first contribution in #183

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.5.4...tidx@0.5.5

tidx@0.5.4

Patch Changes

• Added pgroll support to the tidx binary and Docker image, including bundled (by @o-az, #175)

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.5.3...tidx@0.5.4

tidx@0.5.3

Patch Changes

• Fixed a migration ordering issue. (by @o-az, #172)

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.5.2...tidx@0.5.3

tidx@0.5.2

Patch Changes

• Added support for virtual address detection (by @o-az, @0xrusowsky, @malleshpai #170)

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.5.1...tidx@0.5.2

tidx@0.5.1

What's Changed

• feat: /status endpoint & remove Andantino references by @o-az in #149
• chore: release tidx@0.5.1 by @github-actions[bot] in #150

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.5.0...tidx@0.5.1

tidx@0.5.0

What's Changed

• feat: add ClickHouse HTTP basic auth support by @gakonst in #105
• fix: enable native-tls for ClickHouse HTTPS connections by @gakonst in #106
• fix: persist CH backfill cursor in PG to prevent gaps after restart by @gakonst in #107
• Faster clickhouse backfill by @kamsz in #108
• fix: retry CH backfill on failure instead of giving up by @decofe in #109
• fix: correct backfill_remaining_blocks metric in gap-fill paths by @kamsz in #110
• fix: support Basic auth scheme in rate limit bypass by @goksu in #111
• feat: remove API rate limiting by @goksu in #112
• feat: where filter pushdown by @gorried in #113
• fix: populate txs.gas_used by @gorried in #115
• fix: cap receipt backfill batch range to 10 blocks by @decofe in #116
• fix: adaptive receipt backfill splits range on RPC response too large by @decofe in #117
• perf: batch UPDATE txs once per tick instead of per-range in receipt backfill by @decofe in #118
• feat: add api_pg_url for read replica support by @decofe in #119
• perf: drop redundant ASC indexes by @decofe in #121
• perf: move statement_timeout=0 to pool config by @decofe in #123
• perf: parallelize PG and CH writes in SinkSet by @decofe in #122
• perf: parallelize block/tx/log/receipt writes within each batch by @decofe in #124
• perf: increase pool size for parallel write concurrency by @decofe in #130
• perf: bound gap detection query to avoid full-table scan by @decofe in #127
• test: add has_gaps integration tests by @decofe in #131
• fix: restore per-connection statement_timeout for sync writers by @decofe in #132
• perf: switch write_blocks to COPY BINARY by @decofe in #128
• perf: replace DELETE+COPY with staging table ON CONFLICT DO NOTHING by @decofe in #129
• perf: single PG transaction for batch writes by @decofe in #138
• perf: drop redundant idx_logs_topic1 index by @decofe in #137
• perf: drop redundant block_num DESC indexes by @decofe in #133
• perf: use bare CREATE TEMP TABLE instead of LIKE by @decofe in #135
• perf: use bare CREATE TEMP TABLE in write_batch by @decofe in #143
• perf: use single transaction for realtime block+tx writes by @decofe in #144
• fix: make receipt backfill writes atomic by @decofe in #142
• feat: CLI improvements + agent skills by @jxom in #145
• fix: fetch receipts+logs inline during realtime sync by @o-az in #141
• fix: use latest tag for tidx docker image by @jxom in #146
• chore: add changeset for v0.5.0 by @jxom in #147
• chore: release tidx@0.5.0 by @github-actions[bot] in #148

New Contributors

• @kamsz made their first contribution in #108
• @decofe made their first contribution in #109
• @goksu made their first contribution in #111
• @gorried made their first contribution in #113
• @o-az made their first contribution in #141

Full Changelog: https://github.com/tempoxyz/tidx/compare/tidx@0.4.0...tidx@0.5.0