OpenSparrow v3.0 - GDPR anonymization, ETL, PostgreSQL-Native Config, and a Unified UI

#php #lowcode #postgres #rag

OpenSparrow v3.0 is out. The GDPR anonymization module introduced in 2.9 is now fully covered by end-to-end tests and runs on the new PostgreSQL-native config store, the user menu gets a "My comments" panel and a restyled "My records" list, and the RAG assistant can talk to Ollama Cloud.

Data Anonymization (GDPR/EDPB) - hardened for production

The anonymization module (System > Anonymization) - per-column rules with a date threshold, dry-run preview, EDPB-style risk reports, and a scheduled cron worker - now has full end-to-end test coverage, so rule creation, scheduling, and the dry-run/report flow are regression-tested on every release. It also picked up a dedicated tile on the admin overview dashboard for quicker access alongside ETL, Print, and Workflows.

Under the hood, anonymization rules moved along with the rest of the app's configuration onto the new spw_config PostgreSQL store (see below), which means rule changes now get the same optimistic locking and full audit trail as everything else - no more silently-clobbered config files.

User Records & My Comments

My comments - a new panel in the avatar menu lists every comment you've written, newest first. Each entry shows the start of the comment plus which table/record it belongs to; clicking it jumps straight to that record's Comments tab.
My records restyled - the existing "My records" quick list (records assigned to you, configured per table in admin) now shows the assignment date next to each entry, and a bug where the admin's "clear config" action didn't actually persist has been fixed.

RAG assistant: Ollama Cloud

The AI assistant's admin settings gained an encrypted Ollama Cloud API key field - stored encrypted at rest, sent as a Bearer token, and never shown back in the UI (only whether one is configured, with a button to clear it). This lets the assistant use the paid Ollama Cloud tier instead of a local Ollama install. The cloud connectivity check timeout was also bumped from 8s to 30s after real-world testing showed the shorter window was too aggressive.

Also in this release

Application configuration (schema, menu, dashboard, calendar, automations, users, anonymization rules...) moved from JSON files into a spw_config PostgreSQL table with optimistic locking and full change history
New Print module for block-based report templates
Views got grid-style filters, row grouping with subtotals, and inline drill-down
A UI unification pass across admin and frontend - shared search/filter bar, one button component, unified typography, collapsed row actions
Multiple Kanban boards, a private Notes panel with reminders, and a configurable password policy for users
New admin module - System > ETL. Define named source connections (MySQL, MariaDB, PostgreSQL, SQLite, or a CSV file over FTP/FTPS), then jobs that load them into local PostgreSQL tables.