--- title: "🎧 Postgres gets a new podcast" publication: "Postgres Weekly" issue: 463 published_at: "2022-07-13" canonical_url: "https://postgresweekly.com/issues/463" --- Plus deep dives into column order in Postgres tables. | #​463 — July 13, 2022 [Web Version](https://postgresweekly.com/issues/463) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/s9qtubbavnoqyklkrzoh.jpg)](https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null) [How Postgres 15 Improves `UNIQUE` and `NULL`](https://blog.rustprooflabs.com/2022/07/postgres-15-unique-improvement-with-null) — The author took a look at the latest Postgres 15 beta and dug into an improvement to `UNIQUE` constraints on columns with `NULL` values where it’s possible to make Postgres treat nulls as either distinct values or not. Peter Eisentraut, who developed this feature, popped up on Hacker News [to note](https://news.ycombinator.com/item?id=32054151): _“The background here is that the SQL standard was ambiguous about which of the two ways an implementation should behave. So in the upcoming SQL:202x, this was addressed by making the behavior implementation-defined and adding this `NULLS [NOT] DISTINCT` option to pick the other behavior.”_ Ryan Lambert [![\](https://copm.s3.amazonaws.com/c3f812ce.png)](https://www.polyscale.ai/platform/) [Scale Your Postgres Instance Globally, in Minutes](https://www.polyscale.ai/platform/) — PolyScale.ai is a plug-and-play database edge cache that keeps your database queries fast, everywhere. Run low-latency, multi-region applications or serverless functions, without the cost and complexity of traditional database scaling. PolyScale.ai sponsor [Column Order in Postgres Does Matter](https://www.cybertec-postgresql.com/en/column-order-in-postgresql-does-matter/) — You might think that the order of columns in a database table is just a trivial consequence of that table's history and doesn’t matter much at a technical level. But it can, says Hans-Jürgen, though his example does lean on a particularly extreme example(!) Hans-Jürgen Schönig 💡 GitLab has a handy article on why they require their developers order columns in a specific way in [Ordering Table Columns in PostgreSQL](https://docs.gitlab.com/ee/development/ordering_table_columns.html) – if you want to learn more about this matter. [Initial Findings from the State of PostgreSQL 2022 Survey](https://www.timescale.com/blog/state-of-postgresql-2022-first-findings/) — It takes a while to crunch the data to find insights from large community surveys, so Timescale is taking a dip in the shallow end first with a look at demographics (notably, most respondents were _not_ from North America) and a few answers to open ended questions. Ryan Booz **QUICK BITS:** - 🎤 Postgres is getting its own podcast! [Postgres.fm](https://postgres.fm/) features two developers, responsible for Postgres AI and pgMustard respectively, discussing all things Postgres on a weekly basis. Only one episode for now, but we'll feature the show again as it develops. [Listen to episode 1.](https://postgres.fm/episodes/slow-queries-and-slow-transactions) - Azure PostgreSQL Flexible Server now [supports the Pgrouting and PLV8 extensions](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/introducing-support-for-pgrouting-and-plv8-extensions-in/ba-p/3552072) if you want to get your geographic routing or JavaScript powered Postgres functions on. - We mentioned it a couple of weeks ago, but on social everyone seems to have suddenly noticed [Amazon Aurora now supports Postgres 14](https://www.infoq.com/news/2022/07/amazon-aurora-postgresql-14/) and we didn't want anyone to think we missed it ;-) [Some Notes on GitLab’s Postgres Schema Design](https://shekhargulati.com/2022/07/08/my-notes-on-gitlabs-postgres-schema-design/) — It’s been a worrying long time since we’ve seen a real world database design article doing the rounds, so it’s fun to see Shekhar poking around in Gitlab’s (seemingly rather well designed) database a little. Shekhar Gulati [Data to Go: Postgres Logical Replication](https://www.crunchydata.com/blog/data-to-go-postgres-logical-replication) — Need your data to be copied to a new location on the regular for further processing, consolidation, or more? Postgres 10+’s logical replication is for you. This is a quick explainer that also compares it to _streaming_ replication. Elizabeth Christensen [Tracing Gorm Queries with OpenCensus and Google Cloud Tracing](https://incident.io/blog/gorm-tracing) — [GORM](https://gorm.io/) is a powerful ORM for Go and the team at Incident use it for working with their Postgres database. Here’s how they trace what’s going on in order to keep an eye on performance. Alex Russell-Saw [Free eBook: Understanding Databases](https://www.linode.com/content/understanding-databases-ebook/?utm_source=postgres_weekly&utm_medium=newsletter_sponsorship&utm_campaign=newsletter_sponsorship-postgres_weekly-dbaas&utm_content=&utm_term=) Linode sponsor [Enabling and Enforcing SSL/TLS for Postgres Connections](https://www.percona.com/blog/enabling-and-enforcing-ssl-tls-for-postgresql-connections/) Agustín (Percona) **RELEASES:** [FerretDB 0.5](https://github.com/FerretDB/FerretDB) – A MongoDB alternative on top of Postgres. [Good Job 3.1](https://github.com/bensheldon/good_job) – Postgres-based background job backend for Ruby on Rails. [norm 2.5](https://github.com/moigagoo/norm) – An ORM for the Nim language. [usql 0.11](https://github.com/xo/usql) – Universal CLI tool for SQL databases. [libpqxx 7.7.4](https://github.com/jtv/libpqxx) – Official C++ client API for Postgres. [pgsync 0.7.1](https://github.com/ankane/pgsync) – Sync data from one Postgres database to another. **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|*)