--- title: "Amazon teases a new Postgres(ish) service" publication: "Postgres Weekly" issue: 580 published_at: "2024-12-04" canonical_url: "https://postgresweekly.com/issues/580" --- Plus PostGIS Day videos, and a medley of useful Postgres tips. | #​580 — December 4, 2024 [Web Version](https://postgresweekly.com/issues/580) Together with [![Honeybadger\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_400,h_84/e_make_transparent/co_white,e_outline:7/a5ruvth763xxndgqvll3.png)](https://www.honeybadger.io/tour/logging-observability/?utm_source=postgresweekly&utm_medium=email&utm_campaign=2024-12-04-postgresweekly-primary) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/fv3u0ffwlfvxgutpwsb1.jpg)](https://aws.amazon.com/rds/aurora/dsql/features/) [_Amazon Aurora DSQL_: A New Postgres-Compatible Database](https://aws.amazon.com/rds/aurora/dsql/features/) — In ‘preview’ for now, _DSQL_’s promise is ‘virtually unlimited scalability’ with high availability and strong consistency, while being Postgres compatible ([kinda..?](https://x.com/craigkerstiens/status/1864029392831402475) No views, triggers, JSON, or foreign key constraints..). AWS Hero AJ Stuyvenberg [calls it](https://x.com/astuyve/status/1863992458637680935) _“the single most exciting launch I’ve seen from AWS in a while”_, so watch this space. ([Official press release.](https://press.aboutamazon.com/2024/12/aws-announces-new-database-capabilities-including-amazon-aurora-dsql-the-fastest-distributed-sql-database)) Amazon Web Services 💡 AWS's Marc Brooker has [put together a personal blog post](https://brooker.co.za/blog/2024/12/03/aurora-dsql.html) about DSQL that explains things a bit more, as well as some of the choices made in its architecture. [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/dc80778a.png)](https://www.honeybadger.io/tour/logging-observability/?utm_source=postgresweekly&utm_medium=email&utm_campaign=2024-12-04-postgresweekly-primary) [Full-Stack Observability from Honeybadger](https://www.honeybadger.io/tour/logging-observability/?utm_source=postgresweekly&utm_medium=email&utm_campaign=2024-12-04-postgresweekly-primary) — Honeybadger's new logging platform is a bit like Splunk, DataDog, or CloudWatch Logs, but with just the good parts and a reasonable price tag. Plus, it's easy to integrate with Crunchy Bridge, Journald, AWS, [and more!](https://www.honeybadger.io/tour/logging-observability/?utm_source=postgresweekly&utm_medium=email&utm_campaign=2024-12-04-postgresweekly-primary) Honeybadger sponsor [What I Wish Someone Told Me About Postgres](https://challahscript.com/what_i_wish_someone_told_me_about_postgres) — A diverse grab-bag of practical tips covering areas from normalization and the use of different types to SQL ‘eccentricities’, locks, and the use of JSONB. Hazel Bachrach **QUICK BITS:** - 🌐 PostGIS Day 2024 took place two weeks ago and [▶️ all the videos are now on YouTube.](https://www.youtube.com/playlist?list=PLesw5jpZchudlDbCzKtZwr5eCbvyT_FKW#postgisday) If you prefer more of a writeup of how the event went, [Paul Ramsey has a summary here.](https://www.crunchydata.com/blog/postgis-day-2024-summary) - 🇩🇪 [PostgreSQL Conference Germany 2025](https://2025.pgconf.de/) is taking place in Berlin next May 8-9. The [call for papers](https://2025.pgconf.de/call-for-papers/) is open till February 1, 2025 if you'd like to speak. - Amazon has introduced [Amazon S3 Tables](https://aws.amazon.com/blogs/aws/new-amazon-s3-tables-storage-optimized-for-analytics-workloads/), a way to store and query Iceberg-formatted tabular data on S3. [Transactional Schema Migration Across Tenant Databases with`pg_karnak`](https://www.thenile.dev/blog/distributed-ddl) — If you run a setup where each tenant/user of your system has its own database, maintaining the schemas across them can rapidly become tricky. pg_karnak is Nile’s distributed DDL layer for coordinating schemas across tenants. It hasn’t been open sourced _yet_, but this post digs deep into how it works. Gwen Shapira (Nile) [The `substring` Function, Regex Style](https://www.postgresonline.com/journal/index.php?/archives/415-Substring-function-Regex-style.html#substring) — While you can use Postgres’ `substring` function to extract parts of strings using numeric indices, did you know it supports using regular expressions too? Leo Hsu and Regina Obe [Optimizing Postgres Performance and Compression: pglz vs. LZ4](https://www.timescale.com/blog/optimizing-postgresql-performance-compression-pglz-vs-lz4/) — Did you know you can change the algorithm used to compress your TOAST data? It might be worth it if LZ4 is as fast as we see here. Keyur Panchal (Timescale) 📄 [Writing Composable SQL using Knex and Pipelines](https://lackofimagination.org/2024/11/writing-composable-sql-using-knex-and-pipelines/) – [Knex.js](https://knexjs.org/) is a popular SQL query builder in the JavaScript space. Aycan Gulez 📄 [Unique Constraint Violations During Inserts Can Cause Bloat](https://www.credativ.de/en/blog/credativ-inside/inserts-failing-on-unique-constraint-violations-cause-table-and-index-bloat-in-postgresql/) Josef Machytka 📰 Classifieds 🚀 [pgai Vectorizer](https://github.com/timescale/pgai/) automates embedding creation and syncing in Postgres with one SQL command—keeps embeddings updated, no tools needed. --- 🚀 Looking for fast, accurate search? Power up your query capabilities with [MongoDB Atlas Vector Search](https://shortclick.link/c1i2fo). 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/dlezaivmlaxmsnscjpf6.jpg)](https://supabase.com/blog/supabase-cron) [Supabase Cron: Job Scheduling in Postgres](https://supabase.com/blog/supabase-cron) — A module that uses the [pg_cron](https://github.com/citusdata/pg_cron) extension to manage recurring jobs on the Supabase platform (both via the dashboard or SQL). Vasilov, Rice, and Sutton (Supabase) - 🤖 [pgai v0.2](https://github.com/timescale/pgai) – Timescale's tools to work with RAG and LLMs in Postgres. With v0.2, its vectorizer now supports Ollama. - [pgwire 0.27](https://github.com/sunng87/pgwire) – The Postgres wire protocol implemented in a Rust library. - [PgParty 1.9](https://github.com/rkrage/pg_party) – Create Postgres partitions from Active Record in Ruby. **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|*).