PostgresJul 25, 2025Postgres as Your Platform: Building Event-Driven Systems with Schema ChangesFor years, we’ve built elaborate scaffolding around our databases message queues to broadcast changes, cron jobs to sync schemas, webhooks to notify downstream systems. We needed this scaffolding because Postgres was “just” a database, a place to store rows and run queries. The r...Andrew Tate
PostgresJul 22, 2025Full-text searching the Web — on a single Postgres instance?Neon offers BM25 full text search directly within Postgres, via ParadeDB’s pg_search extension. You can read more about that in our announcement post, and in our comparison with Elasticsearch and with tsvector/tsquery in Postgres. The TL;DR is that supporting flexible full text s...George MacKerron
PostgresJul 14, 2025How to fix missing table errors in pg_cron“Timing is everything.” Some say that’s a quote from Shakespeare, but imho, the true bards of time are the 52 contributors to the pg_cron extension. The concept being pg_cron is simple run scheduled jobs directly within Postgres using familiar cron syntax. The simplicity belies t...Andrew Tate
PostgresJul 07, 2025Build Your Own Full-Text Search CMS with Neon and pg_searchA CMS is a “must have” for building a website. And your choices are many. If you want full stack, you can go with WordPress or Webflow. If you want headless, you can go with Sanity or Contentful. Heck, with the aid of a GitHub Action, you can just turn your Notion pages directly ...Tristan Partin
PostgresJul 02, 2025Neon Joins TanStack: Instant Postgres Integration for Faster JavaScript DevelopmentIt’s no secret that Neon loves TanStack, and we’re proud to support Tanner and the team as they prepare TanStack Start for its much anticipated 1.0 launch. Vite’s popularity is hard to ignore at this point. It’s everywhere! We believe that part of its success is the amazing devel...Atila Fassina
PostgresJun 25, 2025Why Postgres needs better connection security defaultsIn this post why are Postgres connections with sslmode=require insecure? How does Neon ensure secure connections? And what needs to happen to make secure Postgres connections the norm? It’s common to see sslmode=require on the end of a Postgres connection string. Maybe your own s...George MacKerron
PostgresJun 24, 2025How We Export Postgres Logs to Third-Party ServicesRead the docs and get started. " > We’ve been supporting metrics export to Datadog for a few months, and we just extended this capability to any OLTP compatible third party – but it has taken us much longer to ship any sort of Postgres log export. You might wonder why did it take...Roman Zaynetdinov
PostgresJun 24, 2025How We Export Metrics to Third-Party ServicesRead the docs and get started" > Exporting metrics has been a most requested feature by our users, and for good reason. Having Postgres metrics show up in the same dashboards as your app and infrastructure saves you time and headaches. This post walks through how we built native ...Roman Zaynetdinov
PostgresJun 13, 2025Comparing Native Postgres, ElasticSearch, and pg_search for Full-Text SearchImplementing 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....Ben Hagan
PostgresJun 09, 2025Managing Postgres Directly in VS CodeMicrosoft recently introduced a Visual Studio Code extension for Postgres database management. Similar in functionality to tools like PgAdmin or DBeaver, this extension embeds Postgres management directly into VSCode and comes fully integrated with GitHub Copilot, allowing it to ...Sam Harrison
