--- title: "Heroku Postgres switching to Amazon Aurora?" publication: "Postgres Weekly" issue: 533 published_at: "2023-12-06" canonical_url: "https://postgresweekly.com/issues/533" --- Plus imagine something like npm but for Postgres extensions. | #​533 — December 6, 2023 [Web Version](https://postgresweekly.com/issues/533) Together with [![EDB\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_308,h_100/e_make_transparent/co_white,e_outline:7/vrltbo1rhou91lmjw2rl.png)](https://info.enterprisedb.com/GL-MS-2023--EDB-Postgres-AWS-Cloud.html?utm_medium=advertising&utm_source=postgres-weekly&utm_content=cloud-microsite&utm_campaign=GL-MS-2023--EDB-Postgres-AWS-Cloud) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/abbflozzmeokknncagpr.jpg)](https://www.crunchydata.com/blog/advent-of-code-in-postgresql-tips-and-tricks-from-2022) [Tips and Tricks for Doing _Advent of Code_ in Postgres](https://www.crunchydata.com/blog/advent-of-code-in-postgresql-tips-and-tricks-from-2022) — The annual [Advent of Code](https://adventofcode.com/) programming competition is back! Greg is an old hand at using SQL and PL/pgSQL to solve the challenges, so if you want to give it a try too, here he explains how to get started and some Postgres-specific tips and tricks (which are useful for other tasks too!) Greg Sabino Mullane [![\](https://copm.s3.amazonaws.com/95539e16.png)](https://info.enterprisedb.com/GL-MS-2023--EDB-Postgres-AWS-Cloud.html?utm_medium=advertising&utm_source=postgres-weekly&utm_content=cloud-microsite&utm_campaign=GL-MS-2023--EDB-Postgres-AWS-Cloud) [Lower Your Cloud Spend and Increase Postgres Performance on AWS](https://info.enterprisedb.com/GL-MS-2023--EDB-Postgres-AWS-Cloud.html?utm_medium=advertising&utm_source=postgres-weekly&utm_content=cloud-microsite&utm_campaign=GL-MS-2023--EDB-Postgres-AWS-Cloud) — If you’re struggling with increasing costs and decreasing performance of AWS RDS or Aurora, it’s time to look at EDB Postgres. Benefits include: high availability options and always available Postgres experts, Oracle compatibility and transparent pricing. AWS+EDB Postgres are better together. EDB Postgres sponsor [Everyone's Postgres Event Experiences](https://www.cybertec-postgresql.com/en/pgsql-phriday-014-wrapping-up/) — As part of the latest _PGSQL Phriday_ blogging event, many Postgres users wrote about their experiences going to various Postgres meetups and conferences. If you’ve never been to any, you might find the writeups illuminating. Michael Christofides shared [his thoughts](https://www.pgmustard.com/blog/some-thoughts-on-postgres-events), Claire Giordano produced an epic [illustrated guide to Postgres at PASS Data Summit 2023](https://www.citusdata.com/blog/2023/12/01/illustrated-guide-to-postgres-at-pass-data-summit-2023/), Postgres.fm did [▶️ an hour long show on events](https://postgres.fm/episodes/events), and more besides. There’s _a lot_ to enjoy here. Pavlo Golub et al. **IN BRIEF:** - ⭐️ I haven't found a big writeup about it _yet_ but it appears [Heroku is migrating its Postgres platform to using Amazon Aurora](https://toots.coronet.io/@fernomac/111496792312657734) under the hood – that's a huge development. - [PowerSync](https://www.powersync.com/blog/introducing-powersync-v1-0-postgres-sqlite-sync-layer) is a new Postgres to SQLite bi-directional sync layer. - Sticking with SQLite, Richard Hipp has unveiled [a huge evolution of JSON support in SQLite](https://sqlite.org/forum/forumpost/fa6f64e3dc1a5d97) so now SQLite, like Postgres, has both JSON and JSONB.. 😄 [Can You Extract SQL from the WAL?](https://rjuju.github.io/postgresql/2023/12/06/extract-sql-from-wal.html) — Given a `wal_level` of “replica”, is it at all possible to extract SQL from such WALs? Not usually, says Julien in this first of a series of posts, but if you dig deep, there are many useful things you _can_extract. Julien Rouhaud [One Team's Postgres Database Optimization Story](https://bajtos.net/posts/2023-11-optimising-spark-db-perf) — It’s a tale as old as time: you launch an app, it gets popular, and the database starts to show the strain. This is how one team monitored what was going on and introduced some fixes. Miroslav Bajtoš [Closing Cursors](https://okbob.blogspot.com/2023/12/close-cursors.html) — Tools like [Ora2Pg](https://ora2pg.darold.net/) make it possible to port Oracle data, procedures and functions to Postgres, but with any big architectural change, subtle differences can cause curious outcomes, as here. Pavel Stěhule 💡 Related to this, Pavel has released v2.7 of the [plpgsql_check](https://github.com/okbob/plpgsql_check) PL/pgSQL in order to warn you about unclosed cursors in procedures. [Create a Fast Time-Series Graph with Materialized Views](https://www.timescale.com/blog/creating-a-fast-time-series-graph-with-postgres-materialized-views/) — Starts with the Postgres approach, before moving on to Timescale’s _continuous aggregates._ Dylan Paulus (Timescale) Code and Tools [pgxman: It's Like `npm` for Postgres](https://www.hydra.so/blog-posts/the-design-of-postgres-extension-manager-pgxman) — Postgres has a rich ecosystem of extensions ([PGXN](https://pgxn.org/) offers one way to follow them) but installing them can be tricky. There have been numerous attempts at cleaning things up, such as Supabase’s [dbdev](https://database.dev/), and Hydra is having a go with [pgxman](https://pgxman.com/) (‘Postgres Extension Manager’) which takes a more npm-esque approach. Joe Sciarrino (Hydra) [Six Things to Monitor with PostgreSQL](https://www.red-gate.com/hub/product-learning/sql-monitor/six-things-to-monitor-with-postgresql?topic=postgresql-monitoring&product=sql-monitor&utm_source=email&utm_medium=email&utm_campaign=postgres) Redgate sponsor [pguint: An Unsigned Integer Types Extension](https://github.com/petere/pguint) — Brings signed 8 bit integer and unsigned 8, 16, 32, and 64 bit integer types to Postgres 9.1+ (64 bit platforms only). Peter Eisentraut [check_pgactivity 2.7: A Postgres Plugin for Nagios](https://github.com/OPMDG/check_pgactivity) — If you use Nagios for monitoring, use this to have it monitor Postgres as well. v2.7 adds Postgres 15/16 support. OPM Development Group [PLV8ify: Turn JavaScript Files into PLV8 Functions](https://github.com/divyenduz/plv8ify) — Bundles TS/JS input and writes SQL containing Postgres functions using the PLV8 extension. Appears to be in its early stages. Divyendu Singh - [Stateless Postgres Query Router 1.0](https://www.postgresql.org/about/news/stateless-postgres-query-router-100-released-2759/) – Yandex's approach to horizontal sharding. ([GitHub repo.](https://github.com/pg-sharding/spqr)) - [Crunchy Postgres for Kubernetes 5.5](https://www.crunchydata.com/blog/announcing-crunchy-postgres-for-kubernetes-5-5) - [ScalikeJDBC 4.1](https://github.com/scalikejdbc/scalikejdbc) – SQL-based DB access library for Scala. - [Schemalint 1.0.5](https://github.com/kristiandupont/schemalint) – Schema linter. **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|*).