Grandiloquent is a simple and elegant extension on Eloquent that makes mass writes to the database more efficient. My entire philosophy was to ensure that Eloquent methods, such as saveMany, and push, would be more efficient on the database.

This package only works with MySQL currently. It uses raw queries to achieve the functionality used here. Eventually I'd like to support all database types supported by laravel, but that is not the case yet.

Installation can be done by adding the following line to your composer.json require:

"jamesaspence/grandiloquent": "1.*"

##Configuration

You'll need to either A) extend the GrandModel class, or add the GrandModelTrait to your Eloquent classes. The idea is to make this configuration as simple as possible.

Grandiloquent will integrate directly into current workflow. For example, let's assume you have a model system defined thus:

<?php

use Grandiloquent/GrandModel;

class Book extends GrandModel
{
    public function chapters()
    {
        return $this->hasMany(Chapter::class);
    }
     
}

And then your Chapter model:

<?php

use Grandiloquent/GrandModel;

class Chapter extends GrandModel
{
    public function book()
    {
        return $this->belongsTo(Book::class);
    }
}

Using Grandiloquent, in order to save an array of models directly to their parent (in this case the Book), you can call the same function as you would with Eloquent:

$book = Book::find(1);
$chapters = [];
for($i = 0; $i < 5; ++$i)
{
    $chapter = new Chapter();
    $chapter->name = "Chapter $i";
    $chapters[] = $chapter;
}
$book->chapters()->saveMany($chapters);

You can also call saves directly on a collection, like so.

/** @var GrandCollection $books */
$books = Book::take(10)->get();
$books->saveMany();

These methods will perform all updates as a single query. However, inserts are still done individually.