aprs.me/lib/aprsme/packets
Graham McIntire ff3a478bbd
perf: add LIMIT to unbounded DISTINCT ON, guard device table scan, add DB indexes
Bound batch DISTINCT ON queries by input count. Guard Repo.all(Devices) with exists? check. Add trigram GIN index on base_callsign and (has_weather, received_at DESC) partial index.

Ultraworked with Sisyphus

Co-authored-by: Sisyphus <clio-agent@sisyphuslabs.ai>
2026-06-01 16:49:48 -05:00
..
clustering.ex Move client-side logic to server-side LiveView 2026-02-20 08:54:34 -06:00
prepared_queries.ex perf: add LIMIT to unbounded DISTINCT ON, guard device table scan, add DB indexes 2026-06-01 16:49:48 -05:00
query_builder.ex Consolidate 24 packet columns into JSONB data field 2026-02-20 13:02:47 -06:00