Is it time to ditch MySQL and PostgreSQL for SQLite?
– onfold.sh - submitted by Nicolas Beauvais
SQLite is getting all the hype lately, but can it really compete with MySQL and PostgreSQL for production web applications?
Read more [onfold.sh]
Posts tagged with database
Juggling Databases When Testing With Laravel: Tackling the Lock Wait Timeout Error
– www.conroyp.com - submitted by Paul Conroy
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]
Join thousands of developers
Every two weeks, I share practical tips, tutorials, and behind-the-scenes insights from maintaining 300+ open source packages.
No spam. Unsubscribe anytime. You can also follow me on X.
Choose Postgres queue technology
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
Tim McDonald explains Laravel's cool whenQueryingForLongerThan method.
Read more [timacdonald.me]
Introducing laravel-backup-restore
– stefanzweifel.dev - submitted by Stefan Zweifel
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
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
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`
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
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
What is a database view, and how can we use it to make our code cleaner?
Read more [tray2.se]
Introducing LiteFS
– fly.io
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
– fly.io
Chris Fidao makes sure that an app feels fast no matter from where you visit it. Fascinating stuff!
Read more [fly.io]
Fill Gaps in Statistical Time Series Results
Pretty cool that you can achieve this by executing a query, and without application logic.
Read more [sqlfordevs.com]
Is COUNT(*) slow in MySQL?
– aaronfrancis.com - submitted by Aaron Francis
Spoiler: it is optimized to be fast, and you should use it.
Read more [aaronfrancis.com]
The Slotted Counter Pattern
A very nice technique to decrease concurrency and prevent deadlocks.
Read more [planetscale.com]
How do database indexes work?
This post will walk through how database indexes work, with a particular focus on MySQL, everyone’s (well, many people’s) favorite homegrown organic database.
Read more [planetscale.com]
Efficient Pagination Using Deferred Joins
I wonder if Laravel should use this technique by default. It seems to have a major positive impact on performance.
Read more [aaronfrancis.com]
Things You Should Know About Databases
Let's explain the two most important topics when working with RDBMSs: indexes and transactions.
Read more [architecturenotes.co]
Add comments to SQL queries made by Laravel
We've released a new package called spatie/laravel-sql-commenter. This one can add comments to SQL queries. These comments allow you to easily pinpoint the origin of a query when looking at your query log.
New UUID formats
There are a couple of nice ideas there to solve longstanding problems with UUIDs
Read more [www.ietf.org]