Improve your pagination performance on large offsets using deferred joins

I got ~50% improvement in the example below

Article planetscale.com/blog/mysql-p...

#laravel implementation by Aaron Francis github.com/aarondfranci...

weekend vibes

The order of fields in a #go struct can have a big impact on memory usage. In this example, some padding was added to make up for the size difference between the uint16 and uint8 types. It's done for execution speed, but it can lead to increased memory usage.

More at go101.org/article/memo...

Do you need to generate complex(or not) PDFs in #laravel ?

Of course @spatie.be got your back spatie.be/docs/laravel...

Cool trick to invade private functions in #php

Ever heard of PHP's execution operators? You can wrap a command in backticks, and #php will run it as a shell command and give you the output.

Minimize the risk of breaking changes and ensure a more user-friendly API with Functional Options and Builder patterns.

Both patterns allow developers to customize only what they need, leaving the rest to sensible defaults.
#go #golang

Real project requirement: match users with jobs that haven't been considered yet. Used a CROSS JOIN to create the cartesian product of users and jobs. Filtered the results with a SUBSELECT to identify the combinations that didn’t already exist in the matchmaking table.
#SQL