#​422 — September 15, 2021

Web Version

Postgres Weekly

A Roundup of Postgres GUIs in 2021 — A post from 2020 that’s been updated a little for 2021 covering some common database clients like pgAdmin, Navicat, DBeaver, HeidiSQL, Datagrip, and several others.

Angel D'az (Retool)

Boundless TEXT and Back Again — With Postgres, there’s no performance difference between having a VARCHAR(n) column or a boundless TEXT one, but what about if you want to limit the length? Brandur shares a slightly messy story from Stripe of what can happen if there are no limits in place, along with his current rationale for using VARCHAR after all.

Brandur Leach

How Postgres Aggregation Inspired Our Hyperfunctions’ Design — Our engineers break down how PostgreSQL aggregation works, how it inspired the design of TimescaleDB’s hyperfunctions, and how it interacts with continuous aggregates & other advanced features – complete with examples and pictures. 🚀

Timescale sponsor

Trademark Actions Against the PostgreSQL Community — If cross-border trademark disputes aren’t your bag, move on – long story short, the Postgres core team and the community association with manages Postgres’s trademark (and from who we got kind permission for this newsletter’s name) are in a conflict with Fundación PostgreSQL over the use of the name. If you want to see the other side of the story, Álvaro Hernández of Fundación PostgreSQL has it in the more.. intensely-titled ‘Postgres Core Team launches unprecedented attack against the Postgres Community.’

PostgreSQL News

Creating Indexes Before or After Bulk Loading? — Does it matter whether you create an index before or after a large ingestion of data? Hans-Jürgen performs one of his characteristic benchmarks to find out. (In short: after is faster, but it may not suit your workflow.)

Hans-Jürgen Schönig

Using jq to Get Information Out of 'pgbackrest'pgBackRest is a popular backup and restore tool and it can return its output in JSON format, making it ideal to parse with the even more popular jq JSON command line processor.

Luca Ferrari

How We Went All In On sqlc/pgx for Postgres in Gosqlc generates Go from files of SQL queries which provide many of the same benefits as an ORM without some of the downfalls. This is not a one size fits all scenario though and is hugely a matter of preference.

Brandur Leach

Build Internal Tools in Minutes with Retool, Where Visual Programming Meets the Power of Real Code

Retool sponsor

Release Dates of Different Postgres Versions of AWS RDS and Aurora — I’m not sure how useful this is but I like how it’s presented :-)

Brian Likes Postgres

Bun 1.0: Simple and Performant Database Client Library for Go — Supporting Postgres, MySQL, and SQLite, Bun is a modern SQL-first database client library for Go developers with built-in migration and fixtures support. Why not use GORM, Ent or go-pg instead? They have some answers for that question.

Vladimir Mihailenco

PostGIS 3.2.0 Alpha 1 Released — The first preview release of the upcoming PostGIS 3.2.0 is here and targets Postgres 14 beta 3.

Regina Obe