Skip to content

2.0.0 - admin UX overhaul, advanced data modeling, security hardening, and mobile responsiveness

Choose a tag to compare

View all tags
@wrobeltomasz wrobeltomasz released this 15 May 18:32
2.0.0
f69636c
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

What's new:

A comprehensive release focused on admin UX overhaul, advanced data modeling, security hardening, and mobile responsiveness.

Major Features

Admin Interface Redesign

  • Collapsible side panel layout for improved information architecture and navigation
  • Responsive mobile UI with off-canvas navigation for touch devices
  • Icon buttons for grid edit/delete actions replacing text-based controls

Data Modeling Enhancements

  • Virtual computed columns with f(x) badge indicator for formula-based calculated fields
  • Many-to-Many (M2M) grid column support with chip renderer and dedicated Builder tab
  • Schema Map ERD (Entity-Relationship Diagram) tab with search functionality and PNG export

New Administrative Modules

  • Custom Views module for creating and managing personalized data perspectives
  • Database Migrations system (System → Migrations) for tracking and applying schema changes
  • Record Ownership tracking with full assignment history (System → Record Owner)
  • Comprehensive Performance diagnostics tab (System → Performance) with index advisor, slow query analyzer, bloat detection
  • Dedicated Cron Notifications management interface with run history, stats, and log cleanup

Grid & UX Improvements

  • Comment indicators in grid rows highlighting records with discussions
  • Duplicate record button for quick data duplication
  • Grid default sort order and initial load limit configuration per table
  • Grid drilldown quick-add for related records with pre-filled foreign keys
  • Tooltip pattern for grid headers and date columns

Documentation & Configuration

  • Expanded admin documentation (9 new comprehensive reference sections covering Migrations, Ownership, Grid Configuration, Performance, Cron, and more)
  • Dynamic table of contents in documentation sidebar with smooth scroll navigation
  • Demo column descriptions integrated into schema
  • Updated dashboard module documentation

Security

  • 5 security audit priority fixes addressing identified vulnerabilities
  • Enhanced session security and input validation across admin panel

Technical Improvements

  • Refactored HTML rendering with improved DOM structure
  • Anchor IDs on all documentation headings for deep linking support
  • HTML/CSS/JS optimization for better performance
  • Bug fixes for tbody rendering and styling inconsistencies

System Requirements

  • PostgreSQL with mandatory primary key column named id
  • PHP 8.1+ with argon2id password hashing
  • Modern browser with ES6 support (Chrome, Firefox, Safari, Edge)

Installation & Upgrades

Fresh Install: Run System → Migrations → Apply Pending Migrations to initialize all system tables and default admin account.

Upgrading from 1.9:

  1. Back up your database and config
  2. Deploy the new version
  3. Run System → Migrations → Apply Pending Migrations
  4. Review new System tabs (Migrations, Performance) to optimize your setup

Download OpenSparrow

Assets 3
Loading