WhoDB: Updates and Improvements (November 2024)

WhoDB has seen several significant updates in recent releases, bringing improved functionality, bug fixes, and enhanced user experience. Let's dive into the key changes across the last few versions.

Core Functionality Improvements

Enhanced Database Support

• MySQL & PostgreSQL Configuration: Added extensive support for database configuration using GORM syntax
• MySQL Host Path Support: New functionality for configuring MySQL host paths
• Redis Multi-Database: Implemented support for managing multiple Redis databases
• Default Schema Initialization: Added capability to initialize default schemas through login profiles

Query and Data Handling

• Large Text Support: Improved buffering logic to handle larger text fields more effectively
• SQL Condition Handling: Enhanced backtick support in SQL conditions
• PostgreSQL View Sorting: Fixed sorting issues specifically for PostgreSQL views

User Interface Enhancements

New Features

• Storage Unit Filtering: Added filtering capability for storage units
• Version Display: Implemented deployment version display in the sidebar
• Settings Page: New dedicated settings page for configuration management
• Login Page Redesign: Streamlined login page with removal of card layout for cleaner aesthetics

Query Interface Improvements

• Response Viewer: Fixed caching mechanism for submitted code
• SELECT Query Display: Improved table display for SELECT queries with case-insensitive detection

Performance & Metrics

Analytics Integration

• Optional Metrics: Added Highlight.run metrics integration (optional feature)
• Metrics Control: New settings interface to enable/disable metrics collection
• Server Resource Management: Improved server start/stop procedures for better resource handling

Bug Fixes

• Enhanced filter condition handling
• Improved response viewer functionality
• Better resource cleanup during server shutdown

Technical Updates

• Numerous dependency updates across both frontend and backend components
• Enhanced GraphQL implementation
• Improved TypeScript type definitions

What's Next?

The development team continues to focus on stability, performance, and user experience improvements. Users are encouraged to provide feedback through the in-built contact form or through GitHub.