Efficient Distance Querying in MySQL
Link – – aaronfrancis.com - submitted by Aaron Francis
A clever use of MySQL indexes and generated columns to make blazing fast geolocation searches.
Read more [aaronfrancis.com]
Sevalla is the all-in-one PaaS for your web projects. Host and deploy your applications, databases, object storage, and static sites. Enjoy advanced deployment pipelines, a complete database studio, instant preview apps, and one-click templates. The pricing is simple: no hidden fees, no seat-based pricing, and you pay only for what you use. Get real human support from developers.
Get started now with a $50 credit at Sevalla.com.
Database and Eloquent ORM: New features and improvements since the original Laravel 8 release (1/2)
Link – – protone.media - submitted by Pascal Baljet
In this series, I show you new features and improvements to the Laravel framework since the original release of version 8. This week is about the Database and Eloquent features in Laravel 8.
Read more [protone.media]
Stay up to date with all things Laravel, PHP, and JavaScript.
You can follow me on these platforms:
On all these platforms, regularly share programming tips, and what I myself have learned in ongoing projects.
Every month I send out a newsletter containing lots of interesting stuff for the modern PHP developer.
Expect quick tips & tricks, interesting tutorials, opinions and packages. Because I work with Laravel every day there is an emphasis on that framework.
Rest assured that I will only use your email address to send you the newsletter and will not use it for any other purposes.
A look at new features and improvements since the original Laravel 8.0 release: Collections
Link – – protone.media - submitted by Pascal Baljet
The Laravel team released so many great Laravel 8.x updates over the last year, it's incredible! I wrote a series of blog posts highlighting some of the best new features and improvements. Today: Collections.
Read more [protone.media]
The Visitor Pattern in PHP
Link – – doeken.org - submitted by Doeke Norg
The Visitor Pattern opens up your entities to extension without changing them (much); and keeps the code separate.
Read more [doeken.org]
How to test that an Eloquent model actually exists
In your tests, you might have used assertDatabaseHas to make sure that a model actual is persisted.
Ensuring data(base) consistency during concurrent requests
Link – – blog.frankdejonge.nl - submitted by Robin Dirksen
Bugs caused by race conditions can be a huge source or frustration. They are difficult to identify and often difficult to remedy.
Read more [blog.frankdejonge.nl]
Things I Didn't Know About SQS
Link – – laravel-news.com
Chris Fidao wrote another excellent post on AWS.
Read more [laravel-news.com]
How to update large data in Laravel
Link – – 42coders.com
Here are a few best practices for working with a large tables.
Read more [42coders.com]
Laravel Worldwide Meetup #11: Building APIs & Models/Spotlight With Livewire
Here's the recording of the latest edition of the Laravel Worldwide meetup. Philo Hermans showed off two great Livewire packages that he made. Steve McDougall did a cool live coding session on how to build APIs. And at the end, our suprise guest Caneco gave a nice little presentation on Lumen as…
My current setup (end 2021 edition)
My current setup (end 2021 edition)
After tweeting out a screenshot, it often get questions around which editor, font or color scheme I'm using. Instead of replying to those questions individually I've decided to just write down the settings and apps that I'm using.
Creating multi-worksheet Excel files with Simple Excel
Link – – www.csrhymes.com
Here's how to use our spatie/simple-excel package to reate multi-worksheet files.
Read more [www.csrhymes.com]
Avoid describing your data multiple times in a Laravel app using laravel-data
In the vast majority of applications you work with data structures. Sometimes that data is described multiple times. Think for instance of a form request that tries to validate a blog post model, and an API transformer class for that same blog post model. Changes are that both classes describe the same properties.
Using our new laravel-data package, those structures only need to be described once.
We Analyzed 425,909 Favicons
Link – – iconmap.io
The people at IconMap fetched the Tranco top 100,000 websites and analyzed their favicons
Read more [iconmap.io]
Exploring Blade internals
Liam Hammet explores the inner workings of Blade.
You will find all videos in this playlist on YouTube.
Faking HTTP requests in Laravel
Have you ever had to write an API integration from scratch? Where you're managing the HTTP calls yourself instead of being able to rely on third-party packages?
The benefits of testing (video)
Link – – spatie.be
In this video, which is part of the Testing Laravel video course, I explain the benefits of testing.
Read more [spatie.be]
Test-driving complex features with Laravel & Pest
Link – - submitted by Mateus Guimarães
Mateus Guimaraes show a couple of neat tests powered by Pest.
Three types of mocks
Mocking, faking; these might sound like intimidating words if you don't know what they are about, but once you do, you'll be able to improve your testing skills significantly.
Part of "the art of testing" is being able to test code in some level of isolation to make sure a test suite is trustworthy and versatile. These topics are so important that we actually made five or six videos on them in our Testing Laravel course.
In this post, I want to share three ways how you can deal with mocking and faking. Let's dive in!
A Laravel package to crawl and index content of your sites
The newly released spatie/laravel-site-search package can crawl and index the content of one or more sites. You can think of it as a private Google search for your sites. Like most Spatie packages, it is highly customizable: you have total control over what content gets crawled and indexed.
To see the package in action, head over to the search page of this very blog.
In this post, I'd like to introduce the package to you and highlight some implementation and testing details. Let's dig in!
Using Factory sequences in Laravel
One of the things I really like about modern Laravel projects, are the new model factories introduced in Laravel 8.