README

Track your Laravel seeders execution like migrations with batch support, execution time tracking, and comprehensive status management.

✨ Why Use Seeder Tracker?

In large Laravel applications, managing database seeders becomes complex:

Duplicate executions can corrupt data or waste time
No visibility into which seeders have run
Performance issues go unnoticed
Environment differences cause inconsistencies

Seeder Tracker solves these problems by bringing migration-like tracking to your seeders!

🚀 Features

📊 Migration-like tracking - Know exactly which seeders have run
⏱️ Performance monitoring - Track execution time and memory usage
🔄 Batch management - Group related seeder executions
🛡️ Duplicate prevention - Prevent accidental re-runs in production
📈 Rich analytics - Detailed performance insights and reporting
🎯 Environment-aware - Smart controls based on your environment
💾 Metadata storage - Store custom data from seeder results
🔍 Auto-discovery - Automatically find and track all project seeders

📦 Installation

Install via Composer:

composer require ruzaik11/laravel-seeder-tracker

Publish configuration and migrations:

php artisan vendor:publish --provider="Ruzaik\SeederTracker\SeederTrackerServiceProvider"
php artisan migrate

🎯 Quick Start

1. Create a Trackable Seeder

Replace Seeder with TrackableSeeder:

<?php

namespace Database\Seeders;

use Ruzaik\SeederTracker\Seeders\TrackableSeeder;
use App\Models\User;

class UsersTableSeeder extends TrackableSeeder
{
    protected function seedData()
    {
        // Your seeding logic
        $users = User::factory(100)->create();
        
        // Return metadata for tracking
        return [
            'users_created' => $users->count(),
            'admin_users' => $users->where('is_admin', true)->count(),
        ];
    }
}

2. Run Your Seeders

php artisan db:seed --class=UsersTableSeeder
# ✅ Seeder UsersTableSeeder executed successfully in 1,234ms

3. Check Execution Status

php artisan seeder:status

📊 Seeder Execution Status

+------------------+-------------+------------------+-------+
| Seeder           | Status      | Executed At      | Batch |
+------------------+-------------+------------------+-------+
| UsersTableSeeder | ✅ Executed | Dec 21, 2024 14:30 | 1    |
| ProductSeeder    | ⏳ Pending   | Not executed     | N/A   |
+------------------+-------------+------------------+-------+

Summary: 1/2 seeders executed

📋 Available Commands

Status Management

# Basic status
php artisan seeder:status

# Detailed view with performance metrics
php artisan seeder:status --detailed

# Reset specific seeder
php artisan seeder:status --reset=UsersTableSeeder

# Reset all tracking (with confirmation)
php artisan seeder:status --reset-all

Performance Analytics

# Show performance insights
php artisan seeder:performance

# Limit results
php artisan seeder:performance --limit=5

🔧 Advanced Usage

Environment-Aware Seeding

use Ruzaik\SeederTracker\Traits\SeederHelper;

class ProductionDataSeeder extends TrackableSeeder
{
    use SeederHelper;
    
    protected function seedData()
    {
        // Only run in specific environments
        return $this->runInEnvironments(['production', 'staging'], function () {
            // Production-specific seeding logic
            return ['production_data_created' => true];
        });
    }
}

Performance Optimization

protected function seedData()
{
    $startCount = $this->getTableCount('products');
    
    // Batch insert for better performance
    Product::insert($this->generateProductData(1000));
    
    return [
        'products_created' => $this->getTableCount('products') - $startCount,
        'batch_size' => 1000,
        'optimization' => 'batch_insert_used',
    ];
}

Transaction Safety

protected function seedData()
{
    return DB::transaction(function () {
        // All seeding logic in transaction
        $categories = Category::createMany($this->categoryData());
        $products = Product::createMany($this->productData());
        
        return [
            'categories_created' => count($categories),
            'products_created' => count($products),
            'transaction_safe' => true,
        ];
    });
}

⚙️ Configuration

Customize behavior in config/seeder-tracker.php:

return [
    // Database table for tracking
    'table' => 'seeder_tracking',
    
    // Enable automatic tracking
    'auto_track' => true,
    
    // Prevent duplicate executions
    'prevent_duplicates' => env('SEEDER_PREVENT_DUPLICATES', true),
    
    // Strict environments (always prevent duplicates)
    'strict_environments' => ['production'],
];

📈 Performance Monitoring

Track seeder performance automatically:

php artisan seeder:performance

📊 Performance Summary

Total executions: 15
Average execution time: 1,247ms
Total time spent: 18.7s
Average memory usage: 12.3MB

🐌 Slowest Seeders
+------------------+----------------+-------------+------------------+
| Seeder           | Execution Time | Memory Used | Executed At      |
+------------------+----------------+-------------+------------------+
| ProductSeeder    | 3,456ms        | 25.4MB      | Dec 21, 14:30    |
| UsersTableSeeder | 2,123ms        | 15.7MB      | Dec 21, 14:25    |
+------------------+----------------+-------------+------------------+

🏃 Fastest Seeders
+------------------+----------------+-------------+------------------+
| Seeder           | Execution Time | Memory Used | Executed At      |
+------------------+----------------+-------------+------------------+
| RoleSeeder       | 45ms           | 2.1MB       | Dec 21, 14:20    |
| SettingSeeder    | 67ms           | 3.2MB       | Dec 21, 14:22    |
+------------------+----------------+-------------+------------------+

🧪 Testing

The package includes comprehensive tests:

# Run tests
composer test

# Run with coverage
composer test-coverage

📚 Examples

Check the examples/ directory for:

Basic seeder implementation
Advanced environment-aware seeding
Performance optimization techniques
Transaction handling patterns

🔧 Troubleshooting

See TROUBLESHOOTING.md for common issues and solutions.

📈 Development Journey

This package was developed over 3+ months with focus on:

October 2024: Foundation and core architecture
November 2024: Tracking logic and performance monitoring
December 2024: Enhanced commands and comprehensive documentation
January 2025: Community feedback and optimization

🤝 Contributing

Contributions are welcome! Please:

Fork the repository
Create a feature branch
Add tests for new functionality
Submit a pull request

📄 License

MIT License. See LICENSE for details.

👨‍💻 Credits

Ruzaik Nazeer - Creator and maintainer
Laravel Community - Inspiration and feedback

Built with ❤️ for the Laravel community
Website • Email • Packagist

ruzaik11 / laravel-seeder-tracker

Maintainers

Details