Polymorphic relationships with FQN
I'm using polymorphic relationships. I've just realized they wasn't working due to fully qualified n...
Command bus
I really like the look of https://github.com/LaravelIO/laravel.io/tree/nextVersion/src/CommandBus I...
Group by pagination without performance issues when there is over 15K results.
Laravel Eloquent query builder suffers grouping by a column and counting the results for the paginat...
Database query where a join is null
Simple version of database. mortgages | id | case_id(cases@id) | | 1 | 1 | | 2 | 2...
Services and database foreign keys
Does anyone know if you need to still maintain foreign key constraints in services? Say I have a use...
Session expires in a middle of an ajax request
You could also just ping the server every minute to keep the session active. Really poor example but...
DB Count on group by.
I have managed to get this. select count(*) as `count` from (select COUNT(*) from `mortgages` inner...
DB Count on group by.
@jgarifuna sorry that doesn't work, that still returns the first result which unfortunately is wrong...
SQL Storing Searchable Meta Data
Well meta is going to be user defined so I am guessing they could have anything from: user: { name:...
SQL Storing Searchable Meta Data
So I would analyze it for? I was considering making a meta table with 2 columns, keys (string [dot n...
