In 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...

Read 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...

Read 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 ...

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....

Microsoft 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 ...

Postgres 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...