Skip to content

v2026.3.17

Choose a tag to compare

@jeffdc jeffdc released this 17 Mar 22:57
· 137 commits to main since this release

What's New

  • WCVP plant database migrated from SQLite to Postgres — Host plant lookups, WCVP search, and range sync now use a dedicated Postgres database on the same cluster. This eliminates SQLite cold-start delays and connection issues. The async loading feedback added earlier makes any remaining latency visible.
  • Global search region filter visible when results are empty — The region scope bar now shows even when no results match, so you can see and clear active filters.
  • Whitespace bug fixed in species creation — Leading/trailing whitespace in species names is now trimmed across all forms, preventing duplicate or malformed records.

Technical Changes

  • Dropped ecto_sqlite3 and exqlite dependencies — one fewer native compilation step in builds
  • Typed Ecto schemas (WcvpName, WcvpDistribution) replace untyped maps throughout the WCVP lookup API
  • WCVP build task rewritten for Postgres with batch inserts, streaming S3 upload, and CSV header validation
  • New mix gallformers.wcvp.restore task for developer setup from S3 dump artifact
  • Consolidated CI workflow, fixed test infrastructure for Postgres
  • Dev workflow improvements: download-db fixes, Makefile cleanup, prod data test fixes

Full Changelog: v2026.3.16...v2026.3.17