PostgreSQL 17 on Cloud SQL has new features across security, developer experience, performance, tooling, and observability.

A wrapper around psql where connection information is pulled from Azure Key Vault - kometen/rusty_psql

Parses PostgreSQL dump files into an array of schema objects. - gajus/pg-dump-parser

The reigning champion of MySQL proxies, ProxySQL, has set its sights to conquer new territory. Today marks the dawn of a new era as ProxySQL unveils its 3.0.0-Alpha release, bringing PostgreSQL - the darling of developers, and the titan of open source databases - under its formidable umbrella. A Game Changing Expansion Long respected for its

Accelerated Sparse Linear Algebra with Postgres and SuiteSparse - OneSparse/OneSparse

I wrote a blog post a couple of weeks ago entitled Is pg_dump a Backup Tool? . In that post, I argued in the affirmative, but also said that...

Because Postgres have counterintuitive rules around case.

Today, I want to share a different type of post. Nothing polished. Just me goofing around with PostgreSQL's full-text search capabilities.

PostgreSQL and MariaDB are the fastest mainstream open-source databases. MySQL has some catching up to do.

Migrating in-place from PostgreSQL to MySQL Alex Toumazis, Software Engineer Oct 7, 2024 The Yelp Reservations service (yelp_res) is the service that powers reservations on Yelp. It was acquired along...

We at Tembo truly love Postgres. We're convinced everyone would love Postgres just as much as we do if only upgrading Postgres between major versions wouldn't be so darn difficult.

Iceberg/Delta Columnstore Table in Postgres.

Simple HTTP server to help build intuition for MemoryContexts in Postgres - eatonphil/pgweb

The native Mac app for PostgreSQL all new again

Stream, transform, and route PostgreSQL data in real-time. - shayonj/pg_flo

pg_flo is a powerful PostgreSQL data replication tool that enables real-time streaming, table routing, data transformation, and secure data masking between databases.

Open-source Snowflake and Fivetran alternative bundled together

Pongo - Mongo but on Postgres and with strong consistency benefits - event-driven-io/Pongo

We're Sequin, an open source message stream like Kafka, but built on Postgres. Like any Postgres maxi, we tend to find ourselves down a Postgres rabbit hole a couple times per month. This is one of those times :) Who doesn't like to go a little overboard with Postgres? Extensions like

Check what features you are missing in the version of Postgres you are using.

When dealing with very large PostgreSQL tables (we're talking 15TB+), sometimes routine maintenance like archiving very old data can become surprisingly challenging

Querying your database across associations can become a bottleneck in your Rails application. Julian Rubisch, our first guest author, explains why and suggests an efficient solution.

With all these LLMs flying around, PDFs have become popular data sources again. Wait, can a blob of binary be considered a data source, just because human eyes can interpret it visually? Well, no. Unless you can run SQL queries on top of them. This post discusses that.

This canary-based partitioning strategy is a safer, more controlled way to handle large-scale database partitioning and query optimization. Get real-time statistics and gradual optimization, reducing the risks with traditional partitioning processes.

Copy to/from Parquet in S3 from within PostgreSQL.

Understand the recommended data types, storage requirements, and pros and cons of each for various use cases