Appears on
Articles3
Comparing Native Postgres, ElasticSearch, and pg_search for Full-Text Search
Implementing text search in Postgres is trivial. You can do it as simply as this: But like most simple things in SQL, it’s only simple when your data is simple—when you hit anything approaching scale, the simple things become hard. Full-text search is precisely one of these cases...
Postgres Event Triggers Are Now Supported in Neon
Postgres event triggers are a powerful (although often overlooked) feature. Regular Postgres triggers respond to row-level changes in a table, but event triggers fire on DDL commands like CREATE, ALTER, and DROP – allowing you to track schema changes, enforcing rules, and automat...
The 10 Most Popular Postgres Extensions on Neon
Postgres is loved not just for what it is, but for what it can become: its extension system lets you transform your database into a full-text search engine, a geospatial powerhouse, or a vector store for embeddings – all without switching tools. With many thousands of active data...