Articles | Mohamed Said      [Skip to content](#main)  [ ![](https://cdn.msaied.com/01KT78WE565VEMM3PSNQAAB0MH.png) Mohamed SaidLaravel Backend Engineer ](https://msaied.com) - [Home](https://msaied.com)
- [Projects](https://msaied.com/projects)
- [Articles](https://msaied.com/articles)
- [Certificates](https://msaied.com/certificates)
- [About](https://msaied.com#about)

           [  Contact](https://msaied.com#contact) Menu 

Menu
----

Close 

 - [HomeStart here](https://msaied.com)
- [ProjectsCase studies](https://msaied.com/projects)
- [ArticlesEngineering notes](https://msaied.com/articles)
- [CertificatesCredentials](https://msaied.com/certificates)
- [AboutHow I work](https://msaied.com#about)
- [ContactGet in touch](https://msaied.com#contact)

  [Start a conversation](https://msaied.com#contact) [WhatsApp](https://wa.me/201094619204) [Email](mailto:hello@msaied.com) 

  1. [Home](https://msaied.com)
2. /
3. Articles

  Engineering library
====================

 54 articles by Mohamed Said on Laravel, PHP, databases, APIs and infrastructure, written from production work.

 Search articles ⌕×Search 

    Topic hubs
----------

←→

- [AI52 articles](https://msaied.com/articles?category=ai&search=database&sort=new)
- [Composer Pacakge85 articles](https://msaied.com/articles?category=composer-pacakge&search=database&sort=new)
- [Filament31 articles](https://msaied.com/articles?category=filament&search=database&sort=new)
- [Laravel290 articles](https://msaied.com/articles?category=laravel&search=database&sort=new)
- [Livewire16 articles](https://msaied.com/articles?category=livewire&search=database&sort=new)
- [Open Source47 articles](https://msaied.com/articles?category=open-source&search=database&sort=new)
- [PHP34 articles](https://msaied.com/articles?category=php&search=database&sort=new)
- [Tips &amp; Tricks37 articles](https://msaied.com/articles?category=tips-tricks&search=database&sort=new)

  Topics
------

 [All topics](https://msaied.com/articles?search=database&sort=new) [AI 52](https://msaied.com/articles?category=ai&search=database&sort=new) [Composer Pacakge 85](https://msaied.com/articles?category=composer-pacakge&search=database&sort=new) [Filament 31](https://msaied.com/articles?category=filament&search=database&sort=new) [Laravel 290](https://msaied.com/articles?category=laravel&search=database&sort=new) [Livewire 16](https://msaied.com/articles?category=livewire&search=database&sort=new) [Open Source 47](https://msaied.com/articles?category=open-source&search=database&sort=new) [PHP 34](https://msaied.com/articles?category=php&search=database&sort=new) [Tips &amp; Tricks 37](https://msaied.com/articles?category=tips-tricks&search=database&sort=new)    54 articles
------------

Topics    Sort articles Newest first  Oldest first  Sort  

 [Search: database ×Remove search](https://msaied.com/articles?sort=new) [ Clear filters](https://msaied.com/articles) 

  [![](https://cdn.msaied.com/343/2f38128287a6e9daeaafa8cf91abe79a.png)](https://msaied.com/articles/practical-rag-in-laravel-pgvector-embeddings-and-retrieval-pipelines)2 Jul 2026·3 min read 

### [Practical RAG in Laravel: pgvector, Embeddings, and Retrieval Pipelines](https://msaied.com/articles/practical-rag-in-laravel-pgvector-embeddings-and-retrieval-pipelines) 

 Build a production-ready retrieval-augmented generation pipeline in Laravel using pgvector, OpenAI embeddings, and a clean retrieval service — without reaching for a dedicated vector database.

   [![](https://cdn.msaied.com/330/f1a9301a3bc438423da4dacba50c555f.png)](https://msaied.com/articles/clonio-cli-clone-production-databases-with-anonymized-data)30 Jun 2026·3 min read 

### [Clonio CLI: Clone Production Databases With Anonymized Data](https://msaied.com/articles/clonio-cli-clone-production-databases-with-anonymized-data) 

 Clonio CLI copies a production database into development, CI, or test environments while rewriting sensitive columns on the way through — faking names, masking tokens, and remapping keys so data stays usable but no longer identifies real people.

 [Laravel](https://msaied.com/articles?category=laravel) [Open Source](https://msaied.com/articles?category=open-source) 

   [![](https://cdn.msaied.com/321/6c6dac115e95b0b01f6e7c04c430614c.png)](https://msaied.com/articles/laravel-ai-sdk-tool-calling-agents-and-conversation-persistence-1)29 Jun 2026·3 min read 

### [Laravel AI SDK: Tool-Calling Agents and Conversation Persistence](https://msaied.com/articles/laravel-ai-sdk-tool-calling-agents-and-conversation-persistence-1) 

 Build reliable tool-calling AI agents in Laravel using the AI SDK, with typed tool definitions, structured responses, and conversation history persisted to your database without leaking state between requests.

   [![](https://cdn.msaied.com/307/d9832b90141b009f63e8e55ea856cb3a.png)](https://msaied.com/articles/advanced-eloquent-casts-custom-cast-classes-value-objects-and-inbound-only-transforms)27 Jun 2026·4 min read 

### [Advanced Eloquent Casts: Custom Cast Classes, Value Objects, and Inbound-Only Transforms](https://msaied.com/articles/advanced-eloquent-casts-custom-cast-classes-value-objects-and-inbound-only-transforms) 

 Go beyond built-in Eloquent casts. Learn to build custom cast classes, wrap primitives in value objects, and apply inbound-only transforms — keeping your models clean without leaking domain logic into the database layer.

   [![](https://cdn.msaied.com/295/d977bd189583149245c03d6d763d9db5.png)](https://msaied.com/articles/readwrite-splitting-connection-pooling-and-sticky-reads-in-laravel-2)26 Jun 2026·4 min read 

### [Read/Write Splitting, Connection Pooling, and Sticky Reads in Laravel](https://msaied.com/articles/readwrite-splitting-connection-pooling-and-sticky-reads-in-laravel-2) 

 Learn how Laravel's database layer handles read/write splitting, when sticky reads matter, and how to layer PgBouncer or ProxySQL connection pooling without surprising your application.

   [![](https://cdn.msaied.com/292/a09cfdc4dcc65660fb6ada3aae3fa264.png)](https://msaied.com/articles/cursor-pagination-chunked-iteration-and-lazy-collections-at-scale-in-laravel)25 Jun 2026·4 min read 

### [Cursor Pagination, Chunked Iteration, and Lazy Collections at Scale in Laravel](https://msaied.com/articles/cursor-pagination-chunked-iteration-and-lazy-collections-at-scale-in-laravel) 

 Offset pagination breaks under large datasets. Learn how cursor pagination, chunked iteration, and lazy collections let you process millions of rows in Laravel without blowing memory or stalling your database.

   [![](https://cdn.msaied.com/249/715a7f51161f8138c11371578b8ca49b.png)](https://msaied.com/articles/database-performance-partial-indexes-covering-indexes-and-query-plan-analysis-in-laravel)20 Jun 2026·4 min read 

### [Database Performance: Partial Indexes, Covering Indexes, and Query Plan Analysis in Laravel](https://msaied.com/articles/database-performance-partial-indexes-covering-indexes-and-query-plan-analysis-in-laravel) 

 Partial and covering indexes can slash query times dramatically, yet most Laravel apps never use them. Learn how to design, apply, and verify these indexes using migrations, raw DDL, and EXPLAIN output.

   [![](https://cdn.msaied.com/243/78878facaaaca520b683f11457ef4785.png)](https://msaied.com/articles/monitor-laravel-queues-commands-and-schedulers-on-any-driver-with-vigilance)19 Jun 2026·4 min read 

### [Monitor Laravel Queues, Commands, and Schedulers on Any Driver with Vigilance](https://msaied.com/articles/monitor-laravel-queues-commands-and-schedulers-on-any-driver-with-vigilance) 

 Vigilance is a Laravel monitoring dashboard that tracks jobs, Artisan commands, and scheduled tasks across every queue driver—database, Redis, SQS, Beanstalkd, and sync—in one unified timeline.

 [Laravel](https://msaied.com/articles?category=laravel) [Composer Pacakge](https://msaied.com/articles?category=composer-pacakge) 

   [![](https://cdn.msaied.com/232/957c64b845fcbcfced4036abb0409225.png)](https://msaied.com/articles/readwrite-splitting-connection-pooling-and-sticky-reads-in-laravel-1)18 Jun 2026·4 min read 

### [Read/Write Splitting, Connection Pooling, and Sticky Reads in Laravel](https://msaied.com/articles/readwrite-splitting-connection-pooling-and-sticky-reads-in-laravel-1) 

 Learn how Laravel's database layer handles read/write splitting, when sticky reads save you from replication lag bugs, and how to layer PgBouncer or ProxySQL connection pooling without breaking your app.

   [← Newer](https://msaied.com/articles?search=database&page=4)1. [1](https://msaied.com/articles?search=database&page=1)
2. [2](https://msaied.com/articles?search=database&page=2)
3. [3](https://msaied.com/articles?search=database&page=3)
4. [4](https://msaied.com/articles?search=database&page=4)
5. 5
6. [6](https://msaied.com/articles?search=database&page=6)

 5 / 6 [Older →](https://msaied.com/articles?search=database&page=6)   

  Have a technical challenge?
----------------------------

Tell me what you’re building. I reply within two working days.

 [Discuss your project ↗](https://msaied.com#contact) 

Topics
------

Close 

 [All topics](https://msaied.com/articles) [AI (52) ](https://msaied.com/articles?category=ai&search=database&sort=new) [Composer Pacakge (85) ](https://msaied.com/articles?category=composer-pacakge&search=database&sort=new) [Filament (31) ](https://msaied.com/articles?category=filament&search=database&sort=new) [Laravel (290) ](https://msaied.com/articles?category=laravel&search=database&sort=new) [Livewire (16) ](https://msaied.com/articles?category=livewire&search=database&sort=new) [Open Source (47) ](https://msaied.com/articles?category=open-source&search=database&sort=new) [PHP (34) ](https://msaied.com/articles?category=php&search=database&sort=new) [Tips &amp; Tricks (37) ](https://msaied.com/articles?category=tips-tricks&search=database&sort=new)  

  © 2026 Mohamed Said · Built with Laravel, meant to last.Senior Backend Engineer specializing in Laravel, scalable SaaS platforms, APIs, and cloud infrastructure. I build secure, high-performance web applications that help businesses grow.

 - [Home](https://msaied.com)
- [Articles](https://msaied.com/articles)
- [Certificates](https://msaied.com/certificates)
- [GitHub](https://github.com/EG-Mohamed)
- [LinkedIn](https://www.linkedin.com/in/msaiedm/)
- [WhatsApp](https://wa.me/201094619204)
- [Email Address](mailto:hello@msaied.com)
- [My CV](https://drive.google.com/file/u/0/d/1MF20IPRJyzfy32mhEutjL5EpSls0w2Q8/view)
- [Sitemap](https://msaied.com/sitemap.xml)
