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
PostgresMay 28, 2025The Difference Between Postgres Logging and PGAuditPostgres has some excellent internal logging capabilities. With a simple logging_collector = on and a couple of other config flags, you can get an incredibly detailed picture of your Postgres operations, from individual SQL statements to connection attempts, error messages, and l...Monica Steinke
PostgresMay 27, 2025Recreating S3 in Postgres using PostgRESTStoring files directly in a database is generally discouraged in favour of dedicated object storage like S3 or Azure Blob, which is the more scalable and cost effective approach. However, in practice, you might sometimes find yourself putting binary data in a relational database ...Sam Harrison
PostgresMay 23, 2025Escaping the AWS RDS Cost SpiralIf you look at RDS pricing, everything looks quite affordable (storage, compute, backups) – so how are so many teams spending six figures on it? Usage is part of the story, of course, but those bills are also very inflated. At scale, there’s more going on. Scaling a database does...Carlota Soto
PostgresMay 08, 2025Postgres 18 Beta Is Out: 7 Features You Should Know AboutPostgres 18 Beta 1 just shipped. As with previous major releases, this beta includes previews of all features planned for general availability. Read the release notes for the full list of updates, but we’re gonna go through some highlights on this post. New in Postgres 18 Asynchr...Heikki Linnakangas
PostgresMay 05, 2025Rethinking Snapshots at Scale: Neon vs AWS RDSSnapshots are a critical safety net for any team running Postgres in production. If you’re using AWS RDS, you’re probably relying on them mostly as protection against accidental changes. But if your database grows to many terabytes, the experience of actually using those snapshot...Carlota Soto