There is a big focus for many on the type of framework or libraries they will be using within their applications. Some people like very slim frameworks... Others prefer things that just build the application for you.
I like them in between. As I have written before the Node MVVC, MVC, MVEC ... are any of those real? Anyway, the Nodejs ecosystem is broad but far from convenient.
This is why I went with Laravel recently, and it is not Javascript so always happy when I can relax and not have to read about how to do everything in Mongo Db when I just want to know from which damn folder to serve my views...
Yeah, I am an idiot, it is the views folder of course. Once I make it, then go change settings in about 5 different places. Looking at you Nest.
Anyway, now you know why this is in the fuckit tag, because I have no clue what I am writing about and I don't care.
One thing I recently sat a bit with and tried to be overly clever about, is also the title of this post. That is Laravel's Eloquent ORM and my need to query the database as though it was an AI.
So as a reminder to my future self.
Remind in 30 minutes
No GroupBy cannot be used as a Eloquent method. It is a query builder method. Ok and it is an Eloquent method but not to query SQL.
Remind of reminder
GroupBy is also collection method, that is the result of a Eloquent query.
Reminder..Page 2...
You (me) cannot use the convenient pagination from Laravel with GroupBy, unless you write your own. You will make the load on the database too much if you try aggregate 4 different tables results. Give it up.
Maybe Mongo it.
Do create a pivot - not pivot table. Feels like duplication? Get the fuck over it. Gets the job done? Well yeah. Setup Eloquent relations for the mega pivot containing the keys to all tables, and the extra information you are trying to compute filled by some trigger be that a Cron, Action (Event) or just manually.
Use nested Relations to then paginate, WITH the related data and just loop the data so you can get on with it already.
Read reminder
Dear past idiot, this future idiot has found a better way but thanx I would not have if I did not just fuckforward. Regards.