The Story (skip if ya just want the code) I’ve fussed with this problem for weeks. If you need to insert massive amounts of data (100k to 10mil) to your Laravel site there’s a lot of broken information. Some of it is outdated, others are just bits and pieces. But here’s generally how the story … Read more
Laravel’s official documentation about many to many sync states the following on syncing a third table value. How do you actually get those values however?
I’ve been having to look up relationship schemas too frequently and haven’t found a decent place that outlines them with migration and eloquent relationship declaration side by side. So if you’re looking for how to build a migration for (insert here) relationship, here it is. *Based on Laravel 7 One to One One to Many … Read more
Unsuccessful with the making columns case-insensitive framework level, I had to go deeper. Here’s how I changed my Postgres columns to be case-insensitive, and ultimately solve my model relationship problems. CITEXT Extension for Postgres You needs to provision the extension to the database. If you use Heroku (like me here’s a simple step). The citext module provides … Read more
If you’re working with a prepopulated dataset, there’s a chance where a foreign key string doesn’t quite match another table’s key. There’s not too much info on getting case insensitive relationships working other than digging into the database dictionary and building your own master class to pass a strtolower on the keys. Thankfully @TishoTM created … Read more
I was running a lengthy terminal process when my laptop was about to die. And what do you know? You can suspend terminal processes and resume them later. Suspend There are many ways to go about it. The simplest way is to press ctrl + z in the terminal that’s running the process. Shortcut “ctrl” … Read more
I’ve been fighting memory limits more often than I thought I would have to. Giving me the thought that perhaps I’m building my query wrong. But there are a few helpful helpers that can keep the memory low. Two of them being chunk() and cursor(). This speed test is brought to you by @ryo511. His … Read more
Credit goes to @tommysmile. type below: To have launchd start redis now and restart at login: Or, if you don’t want/need a background service you can just run: Test if Redis server is running. If it replies “PONG”, then it’s good to go! Location of Redis configuration file. Uninstall Redis and its files.
The Laravel relationship of Has Many Through is not in the docs, but it seems obvious once you read it. Thanks to @foxted on Laracast. class Post extends Eloquent{ … public function country(){ return $this->user->country; } } I should’ve been able to figure this one out without Google but… 🤦♂️
Starting out Laravel I heard a lot of good advice, particularly on Laracast. But others are confusing, particularly on MVC. The common question is where do you put business logic. You’ll hear that you want to keep your controllers skinny and models thin. What the hell? Using a service layer is the answer if you … Read more
