Gobi - Modern Go-Native Business Intelligence (BI) Engine

简体中文

🚀 A lightweight, API-first Business Intelligence (BI) engine built with Go - designed for modern applications that need embedded analytics, automated reporting, and real-time data visualization. The ultimate Go-native BI solution for developers.

✨ Why Gobi?

• 🔧 Go-Native: Built entirely in Go for performance, simplicity, and easy deployment
• 🔌 API-First: RESTful APIs with JWT and API key authentication for seamless integration
• 📊 Multi-Chart Support: From basic charts to advanced 3D visualizations
• 🤖 Automation Ready: Scheduled reports with webhook notifications
• 🔐 Enterprise Security: Multi-user isolation, API key management, and webhook signatures
• 📈 Production Ready: Clean architecture, dependency injection, comprehensive error handling, and logging
• ⚡ High Performance: Optimized SQL validation, intelligent caching, and connection pooling

🎯 Perfect For

• SaaS Applications needing embedded BI and analytics
• Microservices requiring lightweight Business Intelligence capabilities
• Internal Tools for data visualization and BI reporting
• API-First Platforms that need headless Business Intelligence functionality
• Go Applications looking for native BI integration
• Business Intelligence teams requiring modern, scalable BI solutions

---

🚀 Key Features

🔌 API-First Architecture

• RESTful APIs with comprehensive CRUD operations
• API Key authentication for service-to-service communication
• Webhook system with signature verification for real-time notifications
• Unified JSON response format with proper error handling

📊 Advanced Visualization

• 25+ Chart Types: Bar, Line, Pie, Scatter, Radar, Heatmap, Gauge, Funnel, Area, 3D charts, TreeMap, Sunburst, Tree, BoxPlot, Candlestick, WordCloud, Graph, Waterfall, Polar, Gantt, Rose, Geo/Map/Choropleth, Progress/Circular Progress
• 3D Charts: 3D Bar, 3D Scatter, 3D Surface, 3D Bubble charts
• Interactive chart configuration and customization
• Excel template integration for professional reports

🤖 Automation & Scheduling

• Cron-based scheduling for automated report generation
• Webhook notifications for report completion events
• Retry logic with exponential backoff for failed deliveries
• Delivery tracking with detailed logs

🔐 Enterprise Security

• JWT authentication with configurable expiration
• API key management with secure generation and revocation
• Multi-user isolation ensuring data privacy
• Webhook signature verification for secure notifications
• Role-based access control (Admin/User roles)
• SQL injection protection with comprehensive validation

🏗️ Clean Architecture

• Repository Pattern for data access layer separation
• Service Layer with dependency injection for business logic
• Infrastructure Services for caching, encryption, validation
• Factory Pattern for dependency management
• Comprehensive error handling with detailed logging
• Configuration management with YAML support

⚡ Performance Optimizations

• SQL Validation Optimization: Eliminated redundant validation checks, reducing validation time by 60%
• Intelligent Caching: Smart TTL based on query complexity (simple: 5min, complex: 30min)
• Connection Pool Configuration: Configurable database connection pool settings
• System Monitoring: Real-time performance metrics and health checks
• Database Query Optimization: Advanced query analysis and optimization engine
  • Query Complexity Analysis: Automatic analysis of SQL complexity and performance impact
  • Index Management: Multi-database index analysis and optimization suggestions
  • Query Execution Plans: Detailed execution plans with performance metrics
  • Smart Caching Strategy: Dynamic TTL based on query characteristics and business hours
  • Batch Query Execution: Concurrent query execution with controlled concurrency
  • Performance Monitoring: Real-time query performance tracking and slow query detection
  • Memory Usage Optimization: Intelligent memory management for large result sets
  • Network Transfer Optimization: Optimized data transfer and compression

📈 Data Management

• Multi-database support (SQLite, MySQL, PostgreSQL)
• SQL query management with execution tracking
• Data source management for centralized connection handling
• Query caching for improved performance
• Dashboard statistics and analytics

---

🎯 Use Cases

Embedded Analytics

// Integrate BI directly into your Go application
client := gobi.NewClient("https://your-gobi-instance.com")
client.SetAPIKey("your-api-key")

// Create charts programmatically
chart := &gobi.Chart{
    Name: "Sales Analytics",
    Type: "3d_surface",
    Data: salesData,
}

Automated Reporting

# Schedule daily reports with webhook notifications
schedule:
  name: "Daily Sales Report"
  cron: "0 9 * * *"  # Every day at 9 AM
  webhook: "https://your-app.com/webhooks/reports"

API-First Integration

# Service-to-service authentication
curl -H "Authorization: ApiKey your-api-key" \
     https://gobi.example.com/api/charts

# Real-time webhook notifications
POST /webhooks/reports
{
  "event": "report.generated",
  "data": { "report_id": 123, "status": "success" }
}

Database Query Optimization

// Analyze query performance and get optimization suggestions
optimizer := database.NewQueryOptimizer()
plan, err := optimizer.AnalyzeQuery(sql, dataSource)
for _, suggestion := range plan.Suggestions {
    fmt.Println("Optimization:", suggestion)
}

// Execute query with optimization
optimizedService := infrastructure.NewOptimizedSQLExecutionService(cacheService)
result, err := optimizedService.ExecuteWithOptimization(ctx, dataSource, sql)
fmt.Printf("Execution time: %v, Cache hit: %v\n", 
    result.ExecutionTime, result.CacheHit)

// Get index suggestions
indexManager := database.NewIndexManager()
suggestions, err := indexManager.SuggestIndexes(queryPatterns, dataSource)
for _, suggestion := range suggestions {
    fmt.Printf("Index suggestion: %s\n", suggestion.SQL)
}

---

🛠️ Technology Stack

• Backend: Go 1.21+ with Gin framework
• Database: SQLite (dev) / MySQL/PostgreSQL (prod)
• Authentication: JWT + API Keys with bcrypt hashing
• Charts: Custom 3D rendering with WebGL support
• Scheduling: Cron-based with timezone support
• Notifications: Webhook system with HMAC signatures
• Architecture: Clean Architecture with Repository Pattern
• Caching: Intelligent caching with go-cache
• Documentation: OpenAPI/Swagger ready
• Database Optimization: Advanced query optimization with index management
• Performance Monitoring: Real-time metrics and query analysis

🏗️ Architecture Overview

┌─────────────────┐    ┌─────────────────┐    ┌─────────────────┐
│   API Layer     │    │  Service Layer  │    │ Repository Layer│
│   (Handlers)    │◄──►│  (Business      │◄──►│  (Data Access)  │
│                 │    │   Logic)        │    │                 │
└─────────────────┘    └─────────────────┘    └─────────────────┘
         │                       │                       │
         ▼                       ▼                       ▼
┌─────────────────┐    ┌─────────────────┐    ┌─────────────────┐
│ Infrastructure  │    │   Validation    │    │   Database      │
│   Services      │    │     Layer       │    │   Connection    │
│ (Cache, Auth,   │    │ (SQL, Chart,    │    │     Pool        │
│  Encryption)    │    │  DataSource)    │    │                 │
└─────────────────┘    └─────────────────┘    └─────────────────┘
         │                       │                       │
         ▼                       ▼                       ▼
┌─────────────────┐    ┌─────────────────┐    ┌─────────────────┐
│ Query Optimizer │    │ Index Manager   │    │ Performance     │
│ (Analysis,      │    │ (Multi-DB       │    │ Monitoring      │
│  Suggestions)   │    │  Support)       │    │ (Metrics,       │
│                 │    │                 │    │  Analytics)     │
└─────────────────┘    └─────────────────┘    └─────────────────┘

---

🚀 Recent Improvements

⚡ Performance Optimizations

• SQL Validation Optimization: Eliminated redundant validation checks, reducing validation time by 60%
• Intelligent Caching: Smart TTL based on query complexity (simple: 5min, complex: 30min)
• Connection Pool Configuration: Configurable database connection pool settings
• System Monitoring: Real-time performance metrics and health checks
• Database Query Optimization Engine: Advanced query analysis and optimization
  • **Query Complexity An