International environmental organization — Digital Ecosystem with Astro, Directus and PostgreSQL 18

The challenge

The site lived on WordPress with Elementor and TranslatePress, contacts were in HubSpot, and there was no private area for members, no certifications, and no in-house CRM.

The solution

We built an ecosystem with Astro 7, Directus 11 as a headless CMS, PostgreSQL 18 with pgvector, Redis and n8n, documented with 30 architecture decisions. The 301 redirects from the previous site were mapped, and the HubSpot contacts were reconciled one by one. Security lives in the database, with 92 Row Level Security policies, and the AI combines local models with Ollama, a LiteLLM gateway with per-consumer limits, and semantic search on pgvector. Lighthouse rose from 0.87 to 0.96.

Technologies used

• Astro
• Directus
• PostgreSQL
• pgvector
• n8n
• Ollama

Results

• 92 Row-level security policies
• 0,96 Lighthouse — Previously 0.87
• 30 Documented architecture decisions