Laravel 10 makes writing whereExists
queries in Laravel applications much easier. Previously, it the whereExists
relation required a custom query within a closure but luckily, Laravel 10 solves this in a better way with a much higher developer UX.
In our licensing platform at beyondco.de, we manage licenses of multiple products. If we want to list all orders that include a Tinkerwell license, we would need to write an Eloquent like this:
Order::whereExists(function ($query) { $query->from('licenses')->whereColumn('licenses.order_id', 'orders.id');})->count();)->count();
Laravel 10 makes that a lot easier by simply taking the License
model and doing the heavy lifting on it's own:
Order::whereExists( License::whereColumn('licenses.order_id', 'orders.id');)->count();
This looks cleaner and is easier to understand – which is all we care about when we talk about developer UX.
“I don't know why anyone wouldn’t use Tinkerwell. I can't even remember how I used to test code on the go before it.”
Mohamed Said
VP of Engineering at Foodics
“I use Tinkerwell when I need to quickly dive into my application and view or check some data. I love using it as a scratch pad while developing to get some insights as I make changes and update the code.”Kevin Batdorf
Developer
The must-have companion to your favorite IDE. Quickly iterate on PHP code within the context of your web application.
Buy now Learn more