faraday/db/sqlc
bitromortac e852394bdd
db: add channel event pruning query and index
Add a PruneChannelEvents query that bounds the channel_events table by both
size and age in a single statement: an id-keyset offset enforces a maximum
event count and a timestamp filter enforces a retention window, OR-joined so
each limit applies independently. The query returns the number of rows deleted
so callers can surface pruning activity.

Add a standalone timestamp index so the global age-based prune does not scan
the full table. The existing composite index leads with channel_id and cannot
serve a channel-agnostic timestamp filter.
2026-06-22 10:10:00 +02:00
..
migrations db: add channel event pruning query and index 2026-06-22 10:10:00 +02:00
queries db: add channel event pruning query and index 2026-06-22 10:10:00 +02:00
chanevents.sql.go db: add channel event pruning query and index 2026-06-22 10:10:00 +02:00
db.go mod: add sqldbv2 and boilerplate 2026-03-30 11:50:52 +02:00
db_custom.go db: add chanevents tables and queries 2026-04-01 15:06:37 +02:00
models.go chanevents+db: add sync row 2026-04-02 12:25:36 +02:00
querier.go db: add channel event pruning query and index 2026-06-22 10:10:00 +02:00