Lighthouse Report Enhancements & Data Storage Updates
What developments have taken place today?
Here’s a summary of the recent code changes:
Lighthouse Report Enhancements: The Lighthouse report now includes a final screenshot thumbnail, displaying image data securely and providing optional width/height information. Error handling has been implemented to manage invalid data. Additionally, the code now captures and displays detailed domain and certificate information in an informative card, including the full certificate chain and enhanced error handling for loading data. Security scoring is integrated into the Lighthouse report, saving scores and audit references alongside the decoded report as a JSON file. Improved logging using
console.logstatements has been added, along with RabbitMQ integration for sending lighthouse data.Issue Categorization & Display: The Lighthouse report now categorizes issues by severity (critical and moderate), presenting them in distinct sections within the HTML output, complete with color-coded visuals and toggleable details.
ClickHouse Data Storage Modifications: Significant changes have been made to the
website_url_ping_historyClickHouse table schema, including new columns for performance monitoring metrics (DNS lookup time, connection time, etc.) and a modified table engine (MergeTree) with optimized indexing. A migration script is included for reverting these changes. A repository structure has been established for interacting with the ClickHouse database using parameterized queries to prevent SQL injection.
Summary:
These commits represent a significant effort to improve the Lighthouse analysis process, enhance user interface clarity and detail, and optimize data storage performance and reliability. The addition of security scoring and detailed reporting provides valuable insights into website vulnerabilities, while the ClickHouse modifications promise improved query efficiency and data capture for URL ping history analysis.