Filter op categorie:
The Hidden Superpowers of PostgreSQL: Geospatial Queries
02 Jun 2025 | Ayoub EZZINI
Faced with analyzing millions of real estate transactions across an entire country, I thought I'd need separate geospatial databases and complex data pipelines. Instead, PostgreSQL's PostGIS extension handled proximity calculations, spatial indexing, and real-time property valuations with simple SQL queries.
The Hidden Superpowers of PostgreSQL: Fuzzy Search
02 May 2025 | Ayoub EZZINI
Discover how we avoided adding unnecessary complexity to our stack by unlocking PostgreSQL's hidden superpowers. Learn how the simple pg_trgm extension transformed our search capabilities without sacrificing performance.