Tag "database" tricks

Inside my seeders I often use this trick to prevent from re-seeding already present values. For example, if you are creating a base seed of production data -- say a pre-defined list of values -- and add a new item but do not want to delete all seed data and re-seed, you can try this. Note that, there are some flaws to it. Such as: It will not delete missing values if your new list has changed, or if you set the attributes too specific, you may end up creating a duplicate (for instance, if you have the same item with different `order` values due to rearranging in the list).

Pull a ready-to-go array from an Eloquent model to build a dynamic dropdown in your views

Automatic adding user id. In the: First create columns into database tables with names "updated_by" and "created_by"

It truncates all tables and then it runs all seeders available.

This stumped me for some time and after digging around I found it works great, the uploaded file can be removed from the server as well as the database entry. works well for file sharing and image sharing sites.

Combining Model Observers and Cache Tags for very simple but elegant automatic cache flushing on Eloquent Model updates. Can handle both a Model and its Relations easily!

Here's a simple little scope that you can use to get a random collection of Model objects from the database.

Use this to generate a select box from a Eloquent Collection

In the background create your paginated response however you wish.