Release notes

New updates and improvements to the PIM Country Policy Profile Repository. Each release note documents what changed, what was added, and any fixes applied to the platform.

V0.0.4Latest

June 28, 2026

Country Views, Batch Upload, Translation & Authentication

A large feature cycle: per-country policy views, a batch upload module with automatic translation, original-link health tracking, on-demand English translation, and authentication for the translation feature — alongside a round of performance and robustness hardening.

NewPer-country policy pages — click a country to see its records sorted by tier, with bulk ZIP download of English and/or original-language documents
NewRedesigned Country Overview dashboard: Total Policies, Records with Uploaded Documents, Records with a Working Link, Original Language Non-English (Y/N), and Records with English — with country names linking to each country page
NewBatch upload module — import many policy records at once from an Excel template, with automatic document fetching (including Google Drive / SharePoint links) and optional DeepL translation of non-English originals; includes a downloadable template + data dictionary, a per-batch audit log, and results CSV export
NewOn-demand English translation — for records with no English version, generate one via DeepL from the country page, with a confirmation dialog showing the estimated character count; the result is stored with the "_ENG" suffix
NewEnglish translation provenance — each English document is tagged by source: Official, DeepL, Google Translate, WBG Translate, or Other
NewOriginal-link health indicators — a traffic-light "Original link" button (green = working, yellow = worked before but now broken, red = broken) across the records table, country pages, and detail view, plus a "Recheck links" action and an automatic weekly recheck
NewSign-in is now required to run translations, with a bootstrap registration flow (the first account becomes admin; later sign-ups are gated by an invite code) so the billed translation feature isn't open to the public
ImprovedFaster record saves — external link reachability is now checked in the background instead of blocking the save
ImprovedRepository page loads with fewer database round-trips, and a new composite index speeds up dashboard and language-breakdown queries
ImprovedDashboards and country pages now refresh immediately after records or documents change
ImprovedContent-first navigation order (Repository · Browse · Coach · Benchmark · API) and new landing-page entry points
ImprovedUpload language enforcement plus an original-language breakdown on the statistics page
FixedPDF text extraction now works reliably in the serverless environment (switched to unpdf)
FixedHardened the translation pipeline — capped translation polling time, a document size limit, and SSRF protection on document fetches

V0.0.3

April 9, 2026

Open Access & Document Language Tracking

Removed authentication requirements to make the platform fully open access. Improved document language tracking so the Country Overview dashboard accurately distinguishes between English and non-English document uploads.

NewPlatform is now fully open access — all users can create, edit, delete records and upload documents without signing in
NewCountry Overview dashboard now shows separate English Docs and Non-English Docs columns based on actual uploaded document language
NewStats strip on homepage updated with English Docs and Non-English Docs totals
FixedNon-English document counts now use actual language code instead of document slot type, fixing incorrect counts for English-only countries like Ireland
ImprovedRemoved Sign In button and session provider from navigation header

V0.0.2

April 9, 2026

Performance, Stability & RAG Pipeline

Major infrastructure improvements covering database performance, API stability, and a new export endpoint designed for downstream RAG pipelines such as PIM AI Coach.

NewNew export endpoint (GET /api/export/documents) for RAG pipeline integration with language filtering (?lang=ENG) and incremental sync (?since=timestamp)
NewCORS support for cross-origin access from pim-a-icoach.vercel.app and pim-ai-global.vercel.app
NewAPI pagination with limit/offset support on record listing (default 500, max 500)
NewGlobal error boundary with retry button for graceful error recovery
ImprovedAdded database indexes on policy tiers, countries, auth tables, and audit logs for faster queries
ImprovedAdded foreign key constraint from policy records to countries table to enforce data integrity
ImprovedSwitched record detail and edit pages from force-dynamic to ISR (60s revalidation) for better caching
ImprovedAdded Cache-Control headers to single record API endpoint
ImprovedZod validation schema now enforces max string lengths to reject oversized payloads
ImprovedRate limiting on export endpoint (10 requests per minute per IP)
FixedFixed document upsert race condition by replacing DELETE+INSERT with INSERT ON CONFLICT DO UPDATE
FixedAdded 30-second timeout on blob storage fetch to prevent hanging downloads
FixedFixed blob deletion order — now deletes blob before database record to prevent orphaned files
FixedAdded try-catch to JSON.parse in upload route to prevent crashes from malformed client payloads
FixedFixed SSR hydration issue with window.history access in record form cancel button
FixedCountryCombobox now shows error state instead of infinite spinner on network failure
FixedStrengthened blob URL hostname validation with exact subdomain structure check
FixedFixed parseInt NaN handling in query parameter parsing for tier filters

V0.0.1

February 28, 2026

Initial Release

First public release of the PIM Country Policy Profile Repository. Establishes the core platform for managing and referencing Public Investment Management policy and strategy documents across countries.

NewRepository browse page with search, country filter, and tier filter
NewPolicy record management: create, view, edit, and delete records
NewPer-record document attachments: one English file and one native-language file (PDF, Word, or Text)
NewTier classification system: Policy Guidance Tier and Strategy Tier (1–5)
NewMetadata fields: country, source, year, year revised, overview, pages, tokens, external link
New10 seed records across 8 countries covering foundational PIM legislation and strategies
NewDeployed on Vercel with Neon serverless Postgres and Vercel Blob storage