If you are using Laravel’s firstOrCreate() method and get a unique id violation error, there is a chance you have repopulated your database retroactively in Postgres. Postgres triggers the next id in the sequence on row creation instead of on import. So it thinks the next sequence in the id field is an existing ID … Read more
The Story (skip if ya just want the code) I’ve fussed with this problem for weeks. If you need to import massive amounts of csv 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 … 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
