#Database

14 articles

Database design, optimization, and management techniques. Covers MySQL, PostgreSQL, migrations, indexing strategies, query optimization, and data modeling.

mysql postgresql sql indexing migrations

Database Read Replicas with Laravel: Optimizing Query Performance

Guide to setting up and using Database Read Replicas in Laravel with MySQL and PostgreSQL. Query routing, failover handling, and best practices.

laravel mysql postgresql +3 more

May 3, 2026

Database Sharding Strategies for Laravel Applications

Scale your Laravel database horizontally with sharding. Range-based, hash-based, and tenant-based strategies with practical Eloquent implementations.

laravel database sharding +2 more

Apr 25, 2026

Redis Deep Dive for Laravel Developers

Go beyond Cache::get/set. Master Redis data structures, pub/sub, Lua scripting, rate limiting, sessions, and real-time features in Laravel.

laravel redis caching +2 more

Apr 21, 2026

MySQL Slow Query Log — Finding and Optimizing Slow Queries in Production

A detailed guide to configuring and analyzing MySQL Slow Query Log, using tools like pt-query-digest, and building a comprehensive query performance monitoring workflow.

mysql database performance +3 more

Apr 17, 2026

MySQL Indexing Strategies — Designing Effective Indexes for Every Use Case

A comprehensive guide to indexing strategies in MySQL: from B-Tree, Hash, Full-text to Composite Index, Covering Index, and anti-patterns to avoid.

mysql database performance +3 more

Apr 16, 2026

MySQL Query Optimization with EXPLAIN — Understanding and Tuning Queries from the Ground Up

A comprehensive guide to using EXPLAIN in MySQL to analyze execution plans, understand how MySQL processes queries, and systematically optimize query performance.

mysql database performance +3 more

Apr 15, 2026

Mastering Common Table Expressions (CTEs) in Laravel Eloquent

Use Laravel's new withExpression support to handle complex recursive queries and clean up Eloquent syntax.

laravel database eloquent +2 more

Mar 12, 2026

Vector Search Strategy: pgvector vs Qdrant vs Pinecone

A deep comparison of vector database options for Laravel. Benchmarks, feature sets, and decision frameworks for choosing between PostgreSQL and dedicated engines.

laravel database vector-search +3 more

Feb 28, 2026

Advanced Eloquent: Subqueries, Composites & Performance

Master Eloquent Subqueries. Sort by relationships, safe memory usage, composite indexes, and advanced scope optimization.

laravel eloquent database +3 more

Feb 25, 2026

Database Transactions & Pessimistic Locking in Laravel

Master database transactions and locking strategies to handle concurrent operations, prevent race conditions, and ensure data integrity.

laravel database transactions +1 more

Feb 16, 2026

Database Indexing 101 for Laravel Developers

Why is your query slow? It's probably missing an index. Learn the basics of database indexing within Laravel Migrations.

laravel database mysql +1 more

Feb 10, 2026

Using JSON Columns in Eloquent: The Hybrid SQL/NoSQL Approach

Who needs MongoDB? Modern MySQL and PostgreSQL have powerful JSON support. Learn how to leverage it in Laravel Eloquent.

laravel database json +1 more

Feb 10, 2026

Solving the N+1 Query Problem in Laravel Eloquent

The #1 performance killer in Laravel apps. Learn how to detect N+1 problems and fix them using Eager Loading.

laravel eloquent performance +1 more

Feb 10, 2026

Optimizing Eloquent Performance

Techniques to speed up your Laravel database queries: Eager Loading, Chunking, and more.

laravel eloquent performance +2 more

Feb 10, 2026

Articles List

Database Read Replicas with Laravel: Optimizing Query Performance

Database Sharding Strategies for Laravel Applications

Redis Deep Dive for Laravel Developers

MySQL Slow Query Log — Finding and Optimizing Slow Queries in Production

MySQL Indexing Strategies — Designing Effective Indexes for Every Use Case

MySQL Query Optimization with EXPLAIN — Understanding and Tuning Queries from the Ground Up

Mastering Common Table Expressions (CTEs) in Laravel Eloquent

Vector Search Strategy: pgvector vs Qdrant vs Pinecone

Advanced Eloquent: Subqueries, Composites & Performance

Database Transactions & Pessimistic Locking in Laravel

Database Indexing 101 for Laravel Developers

Using JSON Columns in Eloquent: The Hybrid SQL/NoSQL Approach

Solving the N+1 Query Problem in Laravel Eloquent

Optimizing Eloquent Performance

Related Topics