v3.0

Release Notes - v3.0

Overview

Version 3.0 refines the BugSnapper experience with robust documentation, SQLancer integration, and visual improvements. This update ensures users not only resolve bugs more efficiently, but also understand the tool better through structured guidance and intuitive visuals.

---

New Features

1. SQLancer-Specific Insights (Bug List & Visualization Page)

A new feature to filter bugs reported by SQLancer in the Bug List.

Additionally, the Visualization Page now includes a chart that compares the number of bugs found by SQLancer versus non-SQLancer sources for each DBMS—providing clearer insights into bug discovery trends.

---

2. Comprehensive Documentation Portal

A new MarkBind-powered documentation site has been launched!

Features include:

• 🧭 User Guide (UG) and Developer Guide (DG) with updated content
• ✅ Clear instructions on using core features
• 🛠️ Setup guides for future contributors

---

Live demo updated at: bug_analysis_web

🚀 BugSnapper v3.0 delivers a more informed and accessible experience—bridging powerful features with seamless usability and clarity. Ready to dive deeper and debug smarter?

v2.0

Release Notes - v2.0

Overview

Version 2.0 introduces intelligent decision-support features that transform raw bug analysis into actionable insights. This release focuses on helping users make informed decisions about DBMS selection and bug resolution through AI-powered suggestions.

---

New Features

🧠 1. DBMS Suggestion System (Visualization Dashboard)

• Smart Recommendation Button

  • New "GET_DBMS_SUGGESTION" button analyzes visualized data to provide:
    • 🏆 DBMS Suggestions based on bug metrics
    • 📋 Comparison Summary highlighting strengths/weaknesses
    • 🔍 Key Decision Factors (stability, fix speed, category prevalence)

• Customizable Prompt Integration

  • Suggestions generated based on project-specific requirements
  • Dynamic weighting of factors based on user priorities

🛠️ 2. Automated Solution Generator (GitHub Issue List)

• "GET_SOLUTION" Button
  • Appears when expanding issue cards
  • Provides:
    • Step-by-step resolution guidance
    • Related fixes from similar historical issues
    • Potential pitfalls to avoid

🎨 3. Visualization Page Redesign

• Improved Analytical Flow

---

Live demo updated at: bug_analysis_web

🚀 Version 2.0 transforms data into decisions - helping users choose the right DBMS and fix bugs faster!

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

Release v0.5

Release Notes - v0.5

Overview

This release marks the completion of the basic theme setup and the preparation of all reusable components needed for the project. Additionally, demo pages have been included to showcase how to use the visualization and other UI components.

New Features

• Basic Theme Setup

  • Established the fundamental design theme for the frontend.
  • Ensured consistency in styling across components.

• Reusable Components

  • Implemented key reusable components for the project:
    • BugsBarChart.js
    • BugsLineChart.js
    • card.js
    • GreyContainer.js
    • icon.js
    • MyTabs.js
    • NavBar.js
    • SearchBar.js
    • selectionField.js
  • These components provide modular and maintainable UI elements.

• Visualization Page

  • A dedicated page demonstrating how to integrate and use visualization components.

• Dummy Page

  • A page showcasing how to utilize all other reusable components.

Next Steps

• Integrate backend API calls.
• Enhance UI with dynamic data.
• Implement additional pages based on project requirements.

---

🚀 This marks a significant step forward in the frontend development process!