Pagination, pervasive as it is in web applications, is easy to implement inefficiently. This post examines different methods of server-side pagination and their tradeoffs in PostgreSQL. Methods explored include limit-offset, cursors, keyset pagination, as…

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes - GitHub - zalando/postgres-operator: Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

Unmodified Postgres with some useful extensions. Contribute to supabase/postgres development by creating an account on GitHub.

The <code>text</code> type in Postgres, why it’s awesome, and why you might want to use <code>varchar</code> anyway. Also, a story about trying to get string parameters bounded at Stripe.

Touring the ORM and Postgres landscape in Go, and why sqlc is today’s top pick.

Today I wanted to call some extra attention to those little things, the ones that don't get the spotlight, but simply make a developer's life better.

Validate that existing indexes are useful, get index recommendations to improve performance, and reduce load on your database. Learn more!

How a mysterious stall in database queries uncovered a performance limitation with PostgreSQL.

This post is about an incident we caused while creating over one million indexes and the resulting lessons we learned about building large, distributed systems at fast-growing startups.

Run PostgreSQL 14 on Kubernetes, and see how convenient it is to use distributed features like parallel remote Postgres queries!

With an effort to make Notion faster and more reliable for years to come — we migrated Notion’s PostgreSQL monolith into a horizontally-partitioned database fleet.

Supabase is hiring Cloud Platform Engineers and SREs

A few highlights of the last couple months include an updated front end, in place upgrades, Postgres 14 support, and maintenance windows. Plus a bonus preview of what's coming soon.

StackGres is a fully-featured platform for running PostgreSQL on Kubernetes. Deploy in minutes an Enterprise-Grade Postgres-as-a-Service, in your infrastructure. 100% Open Source.

How do you balance query time and relevance with Postgres text search? Stephen Gutekanst, an engineer working on Sourcegraph's API docs feature, shares tips for stirring code analysis with search indexing

Calculate and project monthly recurring revenue (ARR) and annual recurring revenue (ARR) with PostgreSQL.

Learn how audit tables helped us avoid a serious incident, and how you can create audit tables in your own Postgres databases.

Learn how you can leverage Python and Pandas from directly inside PostgreSQL to build your own recommendation engine.

Babelfish for PostgreSQL is an Apache-2.0 and PostgreSQL open source project that adds a Microsoft SQL Server-compatible end-point to PostgreSQL to enable your PostgreSQL database to understand the SQL Server wire protocol and commonly used SQL Server commands.