v1.0

Release Notes - v1.0

Overview

This major release transforms the project from a basic demo to a fully functional bug analysis platform! We've introduced core analytical features, admin management capabilities, and deep integrations with GitHub data. This release focuses on cross-DBMS comparisons, AI-powered insights, and foundational systems for categorization.

---

New Features

1. Visualization Dashboard (Core Feature)

• Multi-DBMS Comparisons:
  • Interactive charts comparing 3+ DBMSs:
    📊 DBMS Bug Distribution (pie/bar charts)
    📈 Bugs Over Time (time-series line charts)
    ⏱️ Mean Time-to-Fix (TTF) Comparisons
  • Drill-Down Functionality: Click any DBMS to view:
    • Detailed category breakdowns
    • Trend analysis for number of issue opened and closed every month
    • AI-Generated Summary: Auto-generated insights highlighting key patterns

2. GitHub Issue List

• Centralized bug repository with 1000+ pre-analyzed issues from:
  • DuckDB | TiDB | CockroachDB (expandable list)
• Smart Features:
  • 🔍 Filter by DBMS/category/status
  • 🏷️ View AI-assigned categories
  • ↗️ One-click GitHub navigation (issue links)

3. Category Management (Admin-Only)

• Custom Taxonomy System:
  • Manage categories used by AI classifiers (e.g., "Query Optimization", "Security Vulnerabilities")
  • Add/remove/edit categories with validation

4. DBMS Management (Admin-Only)

• Supported DBMS: DuckDB, TiDB, CockroachDB
• Management Features:
  • ➕ Add new DBMS (GitHub org/repo integration)

---

Take note that currently role-based management is not implemented

---

🚀 Version 1.0 lays the foundation for becoming the ultimate cross-DBMS bug analysis toolkit!

Note: Live demo now available at bug_analysis_web