--- title: "A Postgres GUI client roundup" publication: "Postgres Weekly" issue: 422 published_at: "2021-09-15" canonical_url: "https://postgresweekly.com/issues/422" --- Plus a dispute over the 'PostgreSQL' trademark. | #​422 — September 15, 2021 [Web Version](https://postgresweekly.com/issues/422) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/pslzvoamdiae0nmrbgow.jpg)](https://retool.com/blog/best-postgresql-guis-in-2020/) [A Roundup of Postgres GUIs in 2021](https://retool.com/blog/best-postgresql-guis-in-2020/) — 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](https://brandur.org/text) — 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 [![\](https://copm.s3.amazonaws.com/80a399bc.jpg)](https://tsdb.co/two-step-aggregation-blogpost) [How Postgres Aggregation Inspired Our Hyperfunctions’ Design](https://tsdb.co/two-step-aggregation-blogpost) — 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](https://www.postgresql.org/about/news/trademark-actions-against-the-postgresql-community-2302/) — 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.’](https://postgresql.fund/blog/postgres-core-team-attacks-postgres-community/)_ PostgreSQL News [Creating Indexes Before or After Bulk Loading?](https://www.cybertec-postgresql.com/en/postgresql-create-indexes-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'](https://fluca1978.github.io/2021/09/10/pgbackrest-jq.html) — [pgBackRest](https://pgbackrest.org/) 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](https://stedolan.github.io/jq/) JSON command line processor. Luca Ferrari [How We Went All In On `sqlc/pgx` for Postgres in Go](https://brandur.org/sqlc) — [sqlc](https://github.com/kyleconroy/sqlc) 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](https://retool.com/?utm_source=sponsor&utm_medium=newsletter&utm_campaign=cooperpress) Retool sponsor [Release Dates of Different Postgres Versions of AWS RDS and Aurora](https://www.brianlikespostgres.com/rds-aurora-release-dates.html) — 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](https://bun.uptrace.dev/) — 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](https://bun.uptrace.dev/guide/#why-not). Vladimir Mihailenco [PostGIS 3.2.0 Alpha 1 Released](http://postgis.net/2021/09/11/postgis-3.2.0alpha1/) — The first preview release of the upcoming PostGIS 3.2.0 is here and targets Postgres 14 beta 3. Regina Obe **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)