Skip to content

v0.1.8: bounded, index-backed observation query path

Choose a tag to compare

View all tags
@cyanheads cyanheads released this 13 Jul 22:28
v0.1.8
This tag was signed with the committer’s verified signature.
cyanheads Casey Hand
SSH Key Fingerprint: lkZCAfVCK5qsrcvEYCs0BnVRDCX7pKsdCZkw5yYKMuw
Verified
Learn about vigilant mode.
e44d659
This commit was signed with the committer’s verified signature.
cyanheads Casey Hand
SSH Key Fingerprint: lkZCAfVCK5qsrcvEYCs0BnVRDCX7pKsdCZkw5yYKMuw
Verified
Learn about vigilant mode.

bounded, index-backed observation query path

Drops the per-call COUNT(*) that stalled the event loop on large domains.

Fixed:

  • Event-loop-blocking query path (#3) — the unbounded per-call COUNT(*) becomes a LIMIT+1 overflow probe, and two composite indexes ((element_code, year) and (item_code, element_code, year)) back an ORDER BY year spill sort. Indexes apply to already-synced mirrors on next startup, no re-sync.

Changed:

  • Spilled and preview rows now order by year (was area, item, element, year); the output declares no ordering and faostat_dataframe_query re-sorts.
  • totalCount past the 50,000-row staging cap is a floor, not the exact match count (truncated is true).

88 tests pass; bun run devcheck clean.

CHANGELOG v0.1.8

Assets 3
Loading