Posts tagged with mysql
Mattias delves into optimizing SQL queries using indexes, focusing on MySQL 8.0. He explains how indexes work, how to analyze slow queries using MySQL’s EXPLAIN keyword, and the impact of different index configurations on query performance.
Read more [ohdear.app]
The choice between the two depends on the specific requirements and use case of the application.
Read more [highperformancesqlite.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.
– tighten.com - submitted by Jamison Valenta
Learn how to add full-text search into your Laravel apps. From simple LIKE queries to MySQL full-text indexes, and landing on Laravel Scout powered by @typesense.
Read more [tighten.com]
– flareapp.io - submitted by Spatie
Discover how we migrated Flare from MySQL to Postgress with the help of Laravel's query builder.
Read more [flareapp.io]
– 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]
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]
– 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]
– aaronfrancis.com - submitted by Aaron Francis
Spoiler: it is optimized to be fast, and you should use it.
Read more [aaronfrancis.com]
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]
– aaronfrancis.com - submitted by Aaron Francis
An introduction to using bitmasks in general, and their usage in PHP, Laravel, and MySQL.
Read more [aaronfrancis.com]
– 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]
Tobias explains how you can make this operation very fast even if your table has several million records.
Read more [tpetry.me]
When reviewing the contents of the database of Flare, we encountered a table with 1 billion records. Technically that isn't a problem. Flare runs on Vapor and uses an Aurora database, so it can handle that scale. But of course, there's a cost for storing that many records.
We dove in and concluded that we could safely delete about 900 million records. They all were created before a specific date.
Read more [flareapp.io]
Recently we started using GitHub Actions to test all our packages. You can read more about our general setup in this blog post.
For most of the packages, this works great. However, some of our packages, such as Laravel Tags, use JSON functions that are not available in SQLite. Luckily it's straightforward to use a database like MySQL in GitHub Actions.
Laurie Voss, co-founder of npm, explains how databases work, what the difference is between MySQL and something like Redis, why MySQL is popular and much more!
My twitter-friend Simon had a simple question that contained much complexity: how do databases work? The result was an absurdly long thread of 70+ tweets, in which I expounded on the workings and history of databases as used by modern web developers, and Simon chimed in on each tweet with further questions and requests for clarification. The result of this collaboration was a super fun tiny explanation of databases which many people said they liked, so here it is, lightly edited for clarity.
Read more [seldo.com]
Mathias Hansen shares how API response time data is used at Geocodio and how to work with this kind of data in MySQL.
The API is the backbone of our business, so over the years we have continously worked to improve and ensure consistent performance. We look at many parameters such as uptime and error rates, but one of the key metrics is API response time. This is how we use this data.
Read more [www.codemonkey.io]
⚠️ Make sure to always use the right types when querying (Eloquent version) ⚠️#laravel #php #mysql #castingisfun pic.twitter.com/TMnjYbuoCe
— Freek Van der Herten (@freekmurze) February 10, 2019
Read more [twitter.com]
My colleague Brent explains how you can easily work with MySQL views in Laravel.
MySQL views are a way of storing queries on the database level, and producing virtual tables with them. In this post we'll look at why you want to use them and how they can be integrated in Laravel with Eloquent models.
Read more [stitcher.io]
In an older post on his blog Mohamed Said demonstrates how you can leverage virtual columns to speed up queries on data stored as JSON.
Laravel 5.3 is shipped with built-in support for updating and querying JSON type database fields, the support currently fully covers MySQL 5.7 JSON type fields updates and lookups,...
Let's see how we may create a generated column to store users favorite color for later indexing.
https://themsaid.com/laravel-mysql-json-colum-fast-lookup-20160709
Logan Henson, a developer at Tighten, wrote a new post on the company blog about MySQL's cool ST_Distance_Sphere function.
On a client project recently, we had to make it easy to filter database query results based on the distance between a user and an entity in our database. It's easy to get overwhelmed in that context, worrying about the crazy amount of PHP calculations you're going to have to run. ... If you need to calculate this, you can actually get surprisingly far by just using MySQL!
https://tighten.co/blog/a-mysql-distance-function-you-should-know-about