SQL NULLs are Weird!
– raymondtukpe.com – Edit
Here are some special cases that you should keep in mind when working with NULL.
Read more [raymondtukpe.com]
SQLite vs. MySQL: What are the differences between MySQL and SQLite?
The choice between the two depends on the specific requirements and use case of the application.
Read more [highperformancesqlite.com]
Join 9,500+ smart developers
Get my monthly newsletter with what I learn from running Spatie, building Oh Dear, and maintaining 300+ open source packages. Practical takes on Laravel, PHP, and AI that you can actually use.
No spam. Unsubscribe anytime. You can also follow me on X.
"Freek’s newsletter is one of the best ways to stay updated with the Laravel and PHP ecosystem. It consistently highlights useful packages, tools, and ideas from the community, especially the amazing work coming from Spatie. As a Laravel developer building SaaS and web platforms, I find it extremely helpful to discover practical tools and insights that improve my development workflow."
Laravel’s parallel testing on multiple DB connections
– sarahjting.com – Edit
Pretty cool that this behaviour can be customized easily.
Read more [sarahjting.com]
What I Wish Someone Told Me About Postgres
Postgres has many nuances and best practices that are important to understand.
Read more [challahscript.com]
Dynamically build Mail, DB, and Cache configurations in Laravel
– amitmerchant.com – Edit
Laravel’s new build() methods allow dynamic configuration of mail, database, and cache settings.
Read more [amitmerchant.com]
Accessing Databases in PhpStorm
– seankegel.com - submitted by Sean Kegel – Edit
Powerful Database Features You Didn't Know PhpStorm Had
Read more [seankegel.com]
Some cool SQLite things
– ryangjchandler.co.uk - submitted by Ryan Chandler – Edit
Just a small post about some of the cool things you can do / see in SQLite.
Read more [ryangjchandler.co.uk]
Working with DynamoDB in Laravel
– ashallendesign.co.uk - submitted by Ash Allen – Edit
Learn about how to use DynamoDB in Laravel for caching and storing Laravel models.
Read more [ashallendesign.co.uk]
Is it time to ditch MySQL and PostgreSQL for SQLite?
– onfold.sh - submitted by Nicolas Beauvais – Edit
SQLite is getting all the hype lately, but can it really compete with MySQL and PostgreSQL for production web applications?
Read more [onfold.sh]
Juggling Databases When Testing With Laravel: Tackling the Lock Wait Timeout Error
– www.conroyp.com - submitted by Paul Conroy – Edit
Writing tests to validate behaviour in a multi-tenancy, multi-database app can be challenging. "Lock wait timeout" errors, or transactions cleaned up in one db and not another - it can be very frustrating! Fortunately, Laravel has a way to support db transactions across multiple databases.
Read more [www.conroyp.com]
Choose Postgres queue technology
– adriano.fyi – Edit
A nice intro into using Postgres as your queuing solution, and some nice thoughts abou the importance of scale.
Read more [adriano.fyi]
Fast database queries are not always better
– timacdonald.me – Edit
Tim McDonald explains Laravel's cool whenQueryingForLongerThan method.
Read more [timacdonald.me]
Introducing laravel-backup-restore
– stefanzweifel.dev - submitted by Stefan Zweifel – Edit
Do you create automated backups of your database? Are you sure they work? laravel-backup-restore is a new package than can help you verify the integrity of your backups.
Read more [stefanzweifel.dev]
How to delay Laravel jobs and listeners within database transactions
– arunas.dev - submitted by Arunas – Edit
If you have jobs and listeners being fired within database transactions, it can lead to data inconsistencies if the transaction rolls back. Learn how to properly handle them here.
Read more [arunas.dev]
MySQL for Developers
– planetscale.com – Edit
This is a fantastic course by Aaron Francis. I've already watched most of the videos, and I can tell you it's one of the best courses I ever saw.
Read more [planetscale.com]
Easy, alternative soft deletion: `deleted_record_insert`
– brandur.org – Edit
Here's a strategy for soft deletes where you move data to another table instead of leaving it in-place.
Read more [brandur.org]
Using table triggers to log changes in your database tables.
– tray2.se - submitted by Patrik Ahlström – Edit
Tracking changes in a table or several tables for that matter can be essential for your application, and we are going to take a look on how to do that using only the MySQL/MariaDB database.
Read more [tray2.se]
Use a view instead of a complex Eloquent query in your Laravel application
– tray2.se - submitted by Patrik Ahlström – Edit
What is a database view, and how can we use it to make our code cleaner?
Read more [tray2.se]
Introducing LiteFS
The good people at Fly.io have but together a way to use SQLite in a distributed way.
Read more [fly.io]
Multi-Region Laravel With PlanetScale
Chris Fidao makes sure that an app feels fast no matter from where you visit it. Fascinating stuff!
Read more [fly.io]
