Freek.dev

While Amazon S3 is awesome for storage, It also has a feature called S3 Select. With S3 Select, You can use a simple SQL query to filter the content of the stored objects. and retrieve only a subset of data that you need.

Data Providers in PHPUnit, Inline Data Providers and how to use them in PHPUnit

Working with datetime in PHP could be a real pain if you don't take advantage of popular libraries like Carbon. It's all good until you have to convert dates provided on user input into another timezone (eg. UTC) and vice versa. Other example could be that you have to manage various input datetime formats, and sanitize them into a consistent one before saving it to database.

Let's see how to make Indeterminate checkbox state without using any plugins.

Markdown Editor Component with AlpineJS & Laravel Blade. This component also works with Laravel Livewire.

While building your app in Laravel PHP Framework, you have multiple ways of protecting your API routes with various auth guards or Basic auth. Would it be nice to support both API guard and Basic auth at the same time?

Are you getting errors with laravels groupBy()? Here is short explanation of why.

You might think that the way your store your data isn't really that important. Well it's more important than you think it is. A good database design just like good clean code is the key to performance, not only for the end user but also for you the developer. A poor database model just like poorly written code will slow you down and furthermore it will slow your database queries down which results in a slow application.

I made a script to easily take consistent measurements using Apache Benchmark. It includes an easy way to compare multiple measurements in a visual way.

Let's improve your users privacy with file encryption without using any 3rd party packages.

## Common SQL errors and how to solve them in Laravel A post about how to prevent and solve the most common SQL errors in Laravel.

In your infrastructure stack, Laravel and Hasura compliment each other extremely well. Hasura works really well because it magically converts GraphQL queries to SQL and is able to intelligently pick up your table relationships through the use of Foreign Keys. Hasura provides a SQL like GraphQL layer that Laravel developers will love to use!

Here, we will be looking at a hidden feature in Laravel which can be called Bootable Trait. Using this method we can easily use Traits to handle many things that we want to do when model is booted.

Handle SES webhooks with scale

GitHub offers a dependabot service that can let you know of any potential security issues with your dependencies and automatically create a Pull Request for you. This works great without any configuration if you have a repo that contains npm, composer or gem dependencies, but you may need additional configuration if your lock files aren’t in the root directory, or in separate directories in the case of a monorepo.

Due to its flexibility and ease of usage, Docker has become one of the most widely used, if not the most widely used, methods of distributing software. Learn the process of containerizing a Laravel application for both the development and the production environment.

How we migrated to GitHub Actions from Jenkins

This package adds CASE statement support to the Laravel Query Builder.

Laravel comes with sail.. But have you tried Lando? If not, you should!

Here, we will be looking at how to make a Laravel Collection clone. We will learn about two interfaces of PHP which will help us access an object as an array and loop through the object, and they are ArrayAccess and Iterable respectively. We will all be implementing some methods like map, filter, reduce and sum.