https://codeforgeek.com/wp-content/uploads/2026/02/10-Simple-Steps-to-Solve-SQL-Problems.pngIf you find yourself getting confused or going blank while working on SQL questions, we have found 10 simple steps/methods to solve SQL problems with ease. In our previous tutorials in this SQL series, we have already covered: 150+ SQL Commands Explained With Examples to help you understand every major SQL command100 SQL MCQ Tests […]Planet MySQL
Take the Pain Out of Data Imports with Laravel Ingest
https://picperf.io/https://laravelnews.s3.amazonaws.com/featured-images/Laravel-Ingest-LN.png
Laravel Ingest by Robin Kopp is a configuration-driven ETL (Extract, Transform, Load) package that replaces one-off import scripts with declarative importer classes. It handles files from a few hundred to tens of millions of rows by processing them through PHP Generators and Laravel Queues, keeping memory usage consistent regardless of file size.
Main Features
- Declarative importer classes using a fluent
IngestConfigbuilder - Automatic resolution of
BelongsToandBelongsToManyrelationships - Duplicate handling strategies:
SKIP,CREATE,UPDATE, andUPDATE_IF_NEWER - Dry-run mode to validate imports before writing to the database
- Failed row tracking with downloadable CSV exports
- Column aliasing to map varying header names to a single field
- Dynamic model resolution based on row data
- Import sources: file upload, filesystem disks (including S3), URL, FTP, and SFTP
- Auto-generated Artisan commands and REST API endpoints per importer
Defining an Importer
After installing the package and running migrations, you create an importer class that implements IngestDefinition and returns an IngestConfig. By convention, these live in the App\Ingest namespace:
namespace App\Ingest;
use App\Models\Product;
use LaravelIngest\Contracts\IngestDefinition;
use LaravelIngest\DTOs\IngestConfig;
use LaravelIngest\Enums\DuplicateStrategy;
use LaravelIngest\Enums\SourceType;
class ProductImporter implements IngestDefinition
{
public function getConfig(): IngestConfig
{
return IngestConfig::for(Product::class)
->fromSource(SourceType::UPLOAD)
->keyedBy('sku')
->onDuplicate(DuplicateStrategy::UPDATE)
->map('Product Name', 'name')
->relate('Category', 'category', Category::class, 'slug')
->validate([
'sku' => 'required|string',
'Product Name' => 'required|string|min:3',
]);
}
}
Register the importer in your AppServiceProvider using the package’s tag:
use LaravelIngest\IngestServiceProvider;
$this->app->tag([ProductImporter::class], IngestServiceProvider::INGEST_DEFINITION_TAG);
Running Imports
Once registered, the package exposes both an Artisan command and an HTTP endpoint for each importer.
Via CLI:
php artisan ingest:run product-importer --file=products.csv
Via API (multipart form upload):
POST /api/v1/ingest/upload/product-importer
For dry runs, append the --dry-run flag to the Artisan command to validate the file and surface any errors without touching the database.
Monitoring
The package includes several Artisan commands for checking on running or completed imports:
php artisan ingest:list # List registered importers
php artisan ingest:status {id} # Show progress and row statistics
php artisan ingest:cancel {id} # Stop an in-progress import
php artisan ingest:retry {id} # Reprocess only the failed rows
Equivalent REST endpoints are also available:
GET /api/v1/ingest— recent runsGET /api/v1/ingest/{id}— status and statisticsGET /api/v1/ingest/{id}/errors/summary— aggregated error breakdownGET /api/v1/ingest/{id}/failed-rows/download— CSV of rows that failed
Events
The package dispatches events throughout the import lifecycle — IngestRunStarted, ChunkProcessed, RowProcessed, IngestRunCompleted, and IngestRunFailed — which you can listen to for notifications or custom side effects.
You can find Laravel Ingest on GitHub and read the full documentation at the Laravel Ingest docs.
Laravel News
The New Live-Action ‘Moana’ Trailer Welcomes You to the Rock
https://gizmodo.com/app/uploads/2026/03/TheRockMoana-1280×853.jpg
Last year around this time, Disney’s live-action Lilo & Stitch was about to arrive, and fans wondered if the studio would be able to bounce back from its live-action Snow White stumble and resume its streak of hit remakes. And… yep, no problem there. So the live-action Moana will be diving into much safer waters when it arrives July 10, even if this latest trailer suggests it’s basically a shot-for-shot remake of the original film. That includes Dwayne Johnson as Maui, complete with animated tattoos.
There’s also plenty of built-in goodwill for Moana as a franchise, including its animated sequel, Moana 2, which was a smash hit in 2024 after being retooled from Disney+ series to theatrical film.
This new live-action take on Moana stars Catherine Lagaʻaia as Moana alongside Johnson, who also voiced Maui in the animated films.
Disney also shared a new featurette, “Artistry of Moana,” offering a behind-the-scenes peek at the film with director Thomas Kail as well as Laga’aia, Johnson, and the film’s costume designer and choreographer.
The rest of the cast includes John Tui as Moana’s father, Chief Tui; Frankie Adams as Moana’s mother, Sina; and Rena Owen as Moana’s Gramma Tala. Auli’i Cravalho, the voice of Moana in the animated films, is among Moana‘s executive producers. The film features original songs by Lin-Manuel Miranda, Opetaia Foaʻi, and Mark Mancina, and an original score composed by Mancina.
There’s also a new poster today:

Moana hits theaters July 10.
Want more io9 news? Check out when to expect the latest Marvel, Star Wars, and Star Trek releases, what’s next for the DC Universe on film and TV, and everything you need to know about the future of Doctor Who.
Gizmodo
Pro cornhole player with no arms or legs arrested for fatally shooting passenger in his car
https://media.notthebee.com/articles/69c162834e9de69c162834e9df.jpg
Yes, this is a true story.
Not the Bee
Pro cornhole player with no arms or legs arrested for fatally shooting passenger in his car
https://media.notthebee.com/articles/69c162834e9de69c162834e9df.jpg
Yes, this is a true story.
Not the Bee
Pro cornhole player with no arms or legs arrested for fatally shooting passenger in his car
https://media.notthebee.com/articles/69c162834e9de69c162834e9df.jpg
Yes, this is a true story.
Not the Bee
Massachusetts Governor Mocked for Trying to Look Pro-Hunting After Anti-2A Attacks
https://media.townhall.com/cdn/hodl/2020/189/9568d7c2-0226-4824-8b36-70052e5550b1.jpg
Massachusetts Governor Mocked for Trying to Look Pro-Hunting After Anti-2A Attacks
https://media.townhall.com/cdn/hodl/2020/189/9568d7c2-0226-4824-8b36-70052e5550b1.jpg
A 1970s Leather-Topped Executive Desk with a Built-In Swappable Accessory Rail
https://s3files.core77.com/blog/images/1818845_81_142871_kHbNHRx8g.jpg
Though this was designed in the 1970s, this desk looks closer to modern-day furniture than say, a desk from the 1950s.



Danish designer Alex Linder’s Executive Desk has no drawers, and features a recessed aluminum rail that takes a variety of accessories: A desk lamp, a clock, a calendar, a countdown timer (presumably for meetings), little storage bins and, this being the ’70s, an ashtray.



The user chooses where to place the accessories within the rail.
The desk surface is leather, an unusual choice both now and then.




If this thing was height-adjustable and had appeared on a current-day Kickstarter, I wouldn’t bat an eye.
Core77
Build a legal document chatbot with the Laravel AI SDK
Laravel News Links