Supabase Wrappers: An FDW Framework Written in Rust — Foreign data wrappers (FDWs) provide a mechanism within Postgres to access data on remote/external systems, whether other SQL databases or flat files. Supabase has built Wrappers in an attempt to bring a myriad of FDWs under one roof (already including ones to integrate with Stripe, Firebase, and Airtable) and to make it easier to build more.

❤️ Postgres — You need a database provider that loves Postgres as much as you do. We'll take care of all the hassle - monitoring, backups, HA, disaster recovery so you don't have to. Want amazing support? We'll be there when you have questions.

Crunchy Bridge sponsor

Faster PostgreSQL to BigQuery Transfers — The author, well known for his ‘1.1 Billion Taxi Rides’ database benchmarks, demonstrates how using ClickHouse to export Postgres tables to Parquet for importing into BigQuery is quicker than using compressed CSVs. A beautifully practical post and of obvious interest to anyone doing GIS work in particular.

Mark Litwintschik

A Short Summary of 2022 in the Postgres World — Back in December, we did a best of Postgres Weekly in 2022 issue but Avinash takes a more news-oriented look at what happened to Postgres last year, including its DB Engines ranking, releases, brand new extensions, and security vulnerabilities.

Avinash Vallarapu

Looking at Index Types in Postgres — A straightforward primer introducing common types of indexes used by Postgres including B-Trees, GIST, GIN and BRIN indexes.

Grant Fritchey

Generate Excel Workbooks from Postgres on AWS — A distinctly AWS-flavored recipe for extracting data from Postgres (both RDS and Aurora) into Excel workbooks by way of AWS Lambda and S3.

Shaik, Chintha, and Agarwal (AWS)

Free eBook Download: Understanding Kubernetes (Updated Edition)

Linode sponsor

SUBSTR Functionality Differences Between Oracle and Postgres — Valuable if you’re involved in a migration..

Deepak Mahto

pg_rowalesce: Coalescence for Rows — rowalesce() is like coalesce(), but for rows and other composite types.

Rowan Rodrik van der Molen

PL/Haskell 1.1: Use Haskell from within SQL Functions — Procedural, meet functional.

Ed Behn

sqld: A 'Server Mode' for libSQL/SQLite — This is a bit of an unusual one. Rather than using Postgres’s wire protocol in front of another database, this is essentially SQLite in front of the Postgres wire protocol (the idea being apps that use SQLite - or the libSQL fork of it, anyway - can continue to act as they already do, but are actually using Postgres behind the scenes).

libSQL