Filament's QueryBuilder wasn't designed for PostgreSQL JSONB attributes.

Wrote up how to extend it with a custom operator that handles all the edge cases.

Free to read (sign in required) on Filament Mastery
filamentmastery.com/articles/extending-filaments-querybuilder-for-postgresql-jsonb-filters

#Laravel #filamentphp #PostgreSQL

Been working on a new Filament Mastery article.

It started as "I just need to filter a JSONB column"
It ended with a custom QueryBuilder operator and a deep dive into SQL's three-valued logic.

Subscribe if you'd like to be notified when it's live: filamentmastery.com

#Laravel #filamentphp #PostgreSQL

Is FilamentPHP slow with large tables ?

In this case study, performance was improved using PostgreSQL partitions + proper indexing.

👉 filamentmastery.com/articles/filament-slow-on-large-table-optimize-with-postgres-partitions

#filamentphp #Laravel #PostgreSQL

Development update for Hunter — the platform we’re building for creators.

We’re currently using SQLite to develop quickly and efficiently. It’s the ideal choice for rapid iteration during early-stage prototyping.

However, as we prepare for production and user growth, we’re transitioning to PostgreSQL.

Here’s why PostgreSQL is the right fit:
• Scales with user demand
• Native support for JSON and complex data structures
• Strong consistency and integrity
• Reliable for long-term performance

Building solid foundations is part of our vision for a scalable, sustainable platform.

#HunterPlatform #PostgreSQL #ProductDevelopment #TechStack #SoftwareEngineering