Welcome to Speedmi

🚀 Introducing Speedmi: A Powerful Open-Source Website Speed Analysis Tool

Ever wondered how your website could perform better in terms of speed and user experience? Look no further! We are excited to present Speedmi, a comprehensive website speed analyzer that extracts vital performance data from web pages and stores it in a PostgreSQL database for further analysis. 📊

🔥 Speedmi Features:

• ✅ Extracts URLs from a sitemap XML file
• ✅ Processes each URL using Google PageSpeed Insights API
• ✅ Collects various performance, accessibility, best practices, and SEO metrics
• ✅ Saves the metrics to a PostgreSQL database

🎓 Getting started:

• 1️⃣ Create a PostgreSQL database and table
• 2️⃣ Set up environment variables for your database credentials and Google PageSpeed API Key
• 3️⃣ Run the script by providing your sitemap URL

1: Create a PostgreSQL database and create a dedicated table:

CREATETABLEsite_speed_scores (
id SERIALPRIMARY KEY,
url VARCHAR(2083) NOT NULL,
timestampTIMESTAMP,
performance_score NUMERIC,
accessibility_score NUMERIC,
best_practices_score NUMERIC,
seo_score NUMERIC,
first_contentful_paint_score NUMERIC,
first_meaningful_paint_score NUMERIC,
largest_contentful_paint_score NUMERIC,
speed_index_score NUMERIC,
cumulative_layout_shift_score NUMERIC,
server_response_time_score NUMERIC,
is_crawlable_score NUMERIC,
console_errors_score NUMERIC,
total_byte_weight_score NUMERIC,
dom_size_score NUMERIC,
raw_json_data JSONB
);

2: Set the environment variables for your database credentials and Google PageSpeed API Key.

export DB_USER=
export DB_PASS=
export DB_HOST=
export DB_PORT=
export DB_NAME=postgres
export GOOGLE_SPEED_API_KEY=

3: Call the script passing your sitemap URL

python speedmi.py "https://example.com/sitemap.xml"

Upcoming Features

• ✨ Test