Daily Development Updates: Data Visualization, Schema Changes & UI Improvements
What developments have taken place today?
Today’s changes focus on enhancing data visualization, refining database schemas, improving filter management, and updating website presentation elements. Several key improvements were implemented across multiple areas of the application.
The primary improvement involves restructuring how duration bar charts display network performance metrics. Instead of mapping individual data points to labels, the code now aggregates timings into minute intervals, creating a more concise and informative visualization. This includes sorting data by creation date, grouping timings into minutes, calculating average timings for various stages (DNS lookup, connection, TLS handshake, etc.), and updating chart configurations to reflect this aggregated data. Tooltips were also enhanced to display relevant time intervals. Further refinements addressed zooming behavior to ensure consistent visual representation during zoom operations.
A significant database modification was made to the website_url_ping_history table. New columns for timing metrics (DNS lookup time, connection time, TLS handshake time, TTFB, download time, redirect time) were added alongside a replacement for the deprecated page_data column and the change of “duration” to “total_time”. This expansion allows for more detailed analysis of website performance. A new SQL migration was included to facilitate this schema change.
The user interface saw improvements with the addition of a modal window for managing filters applied to tables. This provides users with granular control over data displayed in tables, including disabling filtering functionality altogether. New CSS styles were added to support the filter component and its associated UI elements. The implementation also includes new helper functions for handling user search forms.
Furthermore, several updates were made to certificate management within website records. The Website struct now incorporates fields for certificate expiration date, issuer, serial number, signature algorithm, and public key, enabling more comprehensive monitoring of certificate validity. The database query used for searching websites was also updated to retrieve these expanded certificate details.
Finally, minor updates included dependency versioning, adjusting default pagination parameters in controller functions to ensure consistent behavior, modifying a script generating SQL statements to insert data into the database, and updating website title and sections with new descriptions and formatting.
These changes collectively contribute to improved data analysis capabilities, enhanced user experience through filter management, and increased system robustness by streamlining data handling processes. The overall aim is to provide more insightful visualizations of network performance while maintaining a flexible and maintainable codebase.
data visualization database schema website updates certificate management filter management