--- title: "A promising new storage engine for Postgres" publication: "Postgres Weekly" issue: 444 published_at: "2022-03-02" canonical_url: "https://postgresweekly.com/issues/444" --- Plus a thorough backup tool, a 'diff' for Postgres schemas, and migrating from SQL Server to Aurora. | #​444 — March 2, 2022 [Web Version](https://postgresweekly.com/issues/444) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ueeegngjrj7ibpbgtzqs.jpg)](https://github.com/orioledb/orioledb) [OrioleDB: A New Cloud-Native Storage Engine for Postgres?](https://github.com/orioledb/orioledb) — It’s early days for this project, but OrioleDB is a Postgres extension aimed at bringing some modern ideas to how tables are accessed, including undo logs, copy-on-write checkpoints, row-level WAL, and lock-less page reading. It’s in alpha (and Postgres 14 only) but this is an approach to watch. Alexander Korotkov et al. [![\](https://copm.s3.amazonaws.com/4e607d9f.png)](https://about.sourcegraph.com/use-cases/?utm_campaign=use-cases-ddg-tofu-fy23-q1&utm_medium=newsletter&utm_source=postgres-weekly#streamline-code-reuse) [Stop Wasting Time Rewriting Code. Streamline Code Reuse](https://about.sourcegraph.com/use-cases/?utm_campaign=use-cases-ddg-tofu-fy23-q1&utm_medium=newsletter&utm_source=postgres-weekly#streamline-code-reuse) — With Sourcegraph, you can find existing code libraries for reuse and avoid spending time on problems you know a teammate already solved. This means a more secure and coherent codebase and more time for you to spend on more interesting work. Sourcegraph sponsor [pgwatch2 v1.9 Beta Released](https://www.cybertec-postgresql.com/en/pgwatch2-v1-9-beta-released/) — [pgwatch2](https://pgwatch2.readthedocs.io/en/latest/README.html) is a popular Postgres monitoring and dashboard system. v1.9 brings a new maintainer, improved development process, improved performance, and better connection pooling. It’s ready for you to test now. Pavlo Golub **In brief:** - 📆 The [schedule for CitusCon](https://www.citusdata.com/cituscon/2022/schedule/), a Postgres-flavored event on April 12-13, is now live. There are live sessions at times suitable for everyone around the globe, plus a variety of [on-demand sessions.](https://www.citusdata.com/cituscon/2022/schedule/#ondemand) - Hacker News had [a brief discussion about MongoDB's relevance](https://news.ycombinator.com/item?id=30464075) now that Postgres has solid JSON types and functionality. - Amazon Aurora [now supports](https://aws.amazon.com/about-aws/whats-new/2022/02/amazon-aurora-supports-additional-postgresql-versions/) Postgres 13.5, 12.9, 11.4, and 10.19. - Azure Database for PostgreSQL now [supports creating an allowlist of extensions](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/introducing-ability-to-allow-list-extensions-in-postgresql/ba-p/3219124) so newly created Flexible servers can use preferred extensions quickly. [String Processing in SQL, The Hard Way](https://www.endpointdev.com/blog/2022/02/sql-the-hard-way/) — I don’t think I’ve ever seen string manipulation compared to cliff climbing before, but Josh shows us some similarly dicey terrain when it comes to accurately splitting and working with strings with SQL, `regexp_split_to_table`, and `concat_ws`. Josh Tolley [Migra: Like `diff` But for Postgres Schemas](https://databaseci.com/docs/migra) — Sure, you can take two SQL files and run `diff` between them, but Migra takes things to the next level and ‘magically’ figures out the SQL required to get from A to B which might be useful. [GitHub repo](https://github.com/djrobstep/migra). djrobstep [pg_back 2.1.0: A Simple and Thorough Backup Tool for Postgres](https://github.com/orgrim/pg_back) — A tool (written in Go) for dumping your databases to files, including roles, server parameters, and more, in the format of your choice. Uses `pg_dumpall` and `pg_dump` behind the scenes to get all the data you need. Nicolas Thauvin [Studio 3T Manages Your Data, While You Wrestle Your App into Shape](https://studio3t.com/download?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=postgresmar2) Studio 3T sponsor [Logical Replication/Decoding Improvements in Postgres 13 and 14](https://www.percona.com/blog/logical-replication-decoding-improvements-in-postgresql-13-and-14/) — The author suggests that users who abandoned logical replication in the past should reconsider as PG 13+ has introduced major improvements. Jobin Augustine [How to Migrate from SQL Server to Aurora PostgreSQL using SSIS and Babelfish](https://aws.amazon.com/blogs/database/migrate-from-sql-server-to-aurora-postgresql-using-ssis-and-babelfish/) — Babelfish is Amazon’s T-SQL to Postgres compatibility layer and this post demonstrates using it along with SQL Server Integration Services (SSIS) to migrate from SQL Server to AWS’s Aurora PostgreSQL offering if you have SQL Server workloads. Barot and Venkatraman (AWS) **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|*)