Download Latest Version
2.6.0 - RAG, Multilingual Support _ Mass Edit source code.tar.gz (2.7 MB)
Get an email when there's a new version of OpenSparrow
| Name | Modified | Size | Downloads / Week |
|---|---|---|---|
| Parent folder | |||
| opensparrow-2.0.0.zip | 2026-05-15 | 2.6 MB | |
| 2.0.0 - admin UX overhaul, advanced data modeling, security hardening, and mobile responsiveness source code.tar.gz | 2026-05-15 | 2.5 MB | |
| 2.0.0 - admin UX overhaul, advanced data modeling, security hardening, and mobile responsiveness source code.zip | 2026-05-15 | 2.6 MB | |
| README.md | 2026-05-15 | 3.2 kB | |
| Totals: 4 Items | 7.7 MB | 0 | |
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:
- Back up your database and config
- Deploy the new version
- Run System → Migrations → Apply Pending Migrations
- Review new System tabs (Migrations, Performance) to optimize your setup