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 ==================== 13 articles by Mohamed Said on Laravel, PHP, databases, APIs and infrastructure, written from production work. Search articles ⌕×Search Topic hubs ---------- ←→ - [AI48 articles](https://msaied.com/articles?category=ai&search=indexing&sort=new) - [Composer Pacakge81 articles](https://msaied.com/articles?category=composer-pacakge&search=indexing&sort=new) - [Filament27 articles](https://msaied.com/articles?category=filament&search=indexing&sort=new) - [Laravel267 articles](https://msaied.com/articles?category=laravel&search=indexing&sort=new) - [Livewire13 articles](https://msaied.com/articles?category=livewire&search=indexing&sort=new) - [Open Source44 articles](https://msaied.com/articles?category=open-source&search=indexing&sort=new) - [PHP27 articles](https://msaied.com/articles?category=php&search=indexing&sort=new) - [Tips & Tricks32 articles](https://msaied.com/articles?category=tips-tricks&search=indexing&sort=new) Topics ------ [All topics](https://msaied.com/articles?search=indexing&sort=new) [AI 48](https://msaied.com/articles?category=ai&search=indexing&sort=new) [Composer Pacakge 81](https://msaied.com/articles?category=composer-pacakge&search=indexing&sort=new) [Filament 27](https://msaied.com/articles?category=filament&search=indexing&sort=new) [Laravel 267](https://msaied.com/articles?category=laravel&search=indexing&sort=new) [Livewire 13](https://msaied.com/articles?category=livewire&search=indexing&sort=new) [Open Source 44](https://msaied.com/articles?category=open-source&search=indexing&sort=new) [PHP 27](https://msaied.com/articles?category=php&search=indexing&sort=new) [Tips & Tricks 32](https://msaied.com/articles?category=tips-tricks&search=indexing&sort=new) 13 articles ------------ Topics Sort articles Newest first Oldest first Sort [Search: indexing ×Remove search](https://msaied.com/articles?sort=new) [ Clear filters](https://msaied.com/articles) [![](https://cdn.msaied.com/755/2afbdc0a82de6bd61d3739c09554dda0.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-mess)8 Oct 2026·4 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Casting Without the Mess](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-mess) JSONB columns unlock flexible schemas, but misused they become performance traps. Learn how to index, query, and cast JSONB in Laravel with precision — no raw SQL sprawl. [![](https://cdn.msaied.com/643/656efe6f0c30b559bcdb27456edcc366.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-pain-2)8 Sep 2026·3 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Casting Without the Pain](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-pain-2) JSONB columns unlock flexible schemas inside PostgreSQL, but misused they become slow blobs. Learn how to index, query, and cast JSONB correctly in Laravel Eloquent without sacrificing type safety. [![](https://cdn.msaied.com/532/0c1c122849d3f997950ffca44076f86c.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-pain-1)10 Aug 2026·4 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Casting Without the Pain](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-pain-1) JSONB columns unlock flexible schemas in PostgreSQL, but raw queries get ugly fast. Learn how to index, query, and cast JSONB in Laravel with clean Eloquent patterns that stay performant at scale. [![](https://cdn.msaied.com/529/5d6560d5f6f0a2cdc483fbfecc24707d.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-bloat-2)9 Aug 2026·4 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Casting Without the Bloat](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-bloat-2) JSONB columns let you store flexible data without sacrificing query performance. Learn how to index, query, and cast JSONB in Laravel using real Eloquent patterns that stay fast at scale. [![](https://cdn.msaied.com/528/3c1e1dba1e2f4ca6b8686cf670dcd3b8.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-bloat-1)9 Aug 2026·3 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Casting Without the Bloat](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-bloat-1) JSONB columns give you schema flexibility without sacrificing query performance. Learn how to index, query, and cast JSONB data in Laravel using real Eloquent patterns and raw PostgreSQL power. [![](https://cdn.msaied.com/527/ccaba2b97bd9c80bd87c9e4886481cb6.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-bloat)9 Aug 2026·4 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Casting Without the Bloat](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-bloat) JSONB columns unlock flexible schemas without sacrificing query performance. Learn how to index, query, and cast PostgreSQL JSONB data in Laravel using real Eloquent patterns that stay fast at scale. [![](https://cdn.msaied.com/526/bc43aae3afe723f9a29f47820735edf5.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-chaos-2)9 Aug 2026·3 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Casting Without the Chaos](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-chaos-2) JSONB columns unlock flexible schemas, but without the right indexes and Eloquent integration they become a performance trap. Here is how to use them correctly in production Laravel apps. [![](https://cdn.msaied.com/479/d7c54bd7a42ee57610a29f19a2c5e0fa.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-overhead)28 Jul 2026·4 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Casting Without the Overhead](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-casting-without-the-overhead) JSONB columns unlock flexible schemas, but misused they become performance sinkholes. This guide covers GIN indexes, containment operators, Eloquent casts, and query patterns that keep PostgreSQL fast. [![](https://cdn.msaied.com/356/592e07bf3b46443cb950d9bb31725ba6.png)](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-schema-less-columns-done-right)3 Jul 2026·3 min read ### [PostgreSQL JSONB in Laravel: Indexing, Querying, and Schema-less Columns Done Right](https://msaied.com/articles/postgresql-jsonb-in-laravel-indexing-querying-and-schema-less-columns-done-right) JSONB columns can replace entire pivot tables or EAV nightmares — if you index them correctly and query through Eloquent without leaking raw SQL everywhere. Here is the practical playbook. ← Newer1. 1 2. [2](https://msaied.com/articles?search=indexing&page=2) 1 / 2 [Older →](https://msaied.com/articles?search=indexing&page=2) 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 (48) ](https://msaied.com/articles?category=ai&search=indexing&sort=new) [Composer Pacakge (81) ](https://msaied.com/articles?category=composer-pacakge&search=indexing&sort=new) [Filament (27) ](https://msaied.com/articles?category=filament&search=indexing&sort=new) [Laravel (267) ](https://msaied.com/articles?category=laravel&search=indexing&sort=new) [Livewire (13) ](https://msaied.com/articles?category=livewire&search=indexing&sort=new) [Open Source (44) ](https://msaied.com/articles?category=open-source&search=indexing&sort=new) [PHP (27) ](https://msaied.com/articles?category=php&search=indexing&sort=new) [Tips & Tricks (32) ](https://msaied.com/articles?category=tips-tricks&search=indexing&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)