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
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
Let’s say you have two Collections with the same ID. $a = collect([ ‘id’ => 1, ‘name’ => ‘Johnny’ ]); $b = collect([ ‘id’ => 1, ‘age’ => 14 ]); There’s not a helper to merge the two for a result like this. $c = [ ‘id’ => 1, ‘name’ => ‘Johnny’, ‘age’ => 14]; … Read more
If your app doesn’t have user registration and instead account managers have to create users manually there are a few ways to about password management. The following article from Tyler Jeffords is really helpful. Let the admin set a password for each user they add. (insecure) Randomly generate a password and send it in an … Read more
This is a niche issue with: Laravel, Valet, Passport, Guzzle, Curl, API If you’re using Laravel Passport and you’re doing something like this: use GuzzleHttp\Client; try { $client = new Client(); $client->post(‘site.test/oath/token’, [some params]); And you get an error “Laravel guzzle cURL error 6: Could not resolve host” while making an api post request. Check … Read more
