--- title: "MERGEing into Postgres 15" publication: "Postgres Weekly" issue: 448 published_at: "2022-03-30" canonical_url: "https://postgresweekly.com/issues/448" --- Plus a pure JS Postgres library, and a way to keep your plans in check. | #​448 — March 30, 2022 [Web Version](https://postgresweekly.com/issues/448) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/xbcdz4ircyusbijt34qg.jpg)](https://www.postgresql.org/docs/devel/sql-merge.html) [`MERGE` Coming to Postgres 15](https://www.postgresql.org/docs/devel/sql-merge.html) — It’s always good to see a fresh new page in the Postgres docs – even if it's for a release due later this year. This one is for `MERGE` (a SQL statement you may have seen in SQL Server or Oracle) – the basic idea is data from a query or a source table is merged en masse into a target table under definable conditions. PostgreSQL Documentation [Citus 11 Now in Beta](https://www.citusdata.com/blog/2022/03/26/test-drive-citus-11-beta-for-postgres/) — Citus is an open source Postgres extension that _“transforms Postgres into a distributed database”_ and the big update in 11 is schema and metadata syncing so distributed tables can always be queried from any node in a cluster. Citus Data / Microsoft [![\](https://copm.s3.amazonaws.com/8d8eabb5.png)](https://studio3t.com/download?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=postgresmar30) [Studio 3T Manages Your Data, While You Wrestle Your App into Shape](https://studio3t.com/download?utm_source=cooperpress&utm_medium=newsletter&utm_campaign=postgresmar30) — Studio 3T's full suite of MongoDB tools lets you query quicker, develop with data even faster and turn queries into code automatically. Try it free for 30 days - no credit card needed. Studio 3T sponsor **In brief:** - 📅 [PGConf Belgium 2022](https://pgconf.be/) is taking place on May 19 and the [call for speakers](https://pgconf.be/#cfs) ends_today._ - 📅 Next week is the week you never realized you needed till now: [AWS Data Modernization Week](https://pages.awscloud.com/NAMER-event-OE-ModWeekData-2022-reg-event.html). Four days of talks spanning intermediate to expert folks looking to use AWS's various data services. [Ultimate Guide to Citus Con: An Event for Postgres](https://www.citusdata.com/blog/2022/03/29/ultimate-guide-to-citus-con-an-event-for-postgres/) — There are just under two weeks to go and the Citus / Microsoft team are really, really, really keen for you to enjoy their free event whether live or by watching the sessions on demand later. This post digs into what talks will be talking place. Citus Data [How to `DROP ROLE` or `DROP USER` Without Trouble](https://www.cybertec-postgresql.com/en/drop-role-or-drop-user-postgresql/) — More often than not, we set our databases up and rarely think about deleting the users and roles with power over them. However, it’s not as simple as you might think given the potential for problems with dependencies.. Laurenz Albe [Installing Crunchy Postgres Operator v5 on EKS](https://b-peng.blogspot.com/2022/03/pgo-v5-installation.html) Bo Peng **🔧 Code and Tools:** [Postgres.js 3.0: Fast, Full-Featured Postgres Client for Node and Deno](https://github.com/porsager/postgres) — Now for both Deno and Node.js, this high performance Postgres library offers realtime change subscription, dynamic query building via a special template literal, large objects, high availability via multi-host connection URLs, async cursors, and more. [Slonik](https://github.com/gajus/slonik) is another option to consider in this space too. Rasmus Porsager [pg_plan_guarantee: Keeps Your Plans in Place](https://github.com/gurjeet/pg_plan_guarantee) — Fine tuning queries to get the right execution plan out of Postgres’s planner is a common hobby around these parts, but what about when things change and suddenly Postgres’s planner decides to unilaterally change path? This extension’s promise is to _“set your execution plan in stone”_ which may, or may not, be a good idea given your use case. Note that this is a new project in _alpha_ and may have unintended consequences! Gurjeet Singh [How Lyft's Mobile Team Does Mobile CI at Scale](https://buildkite.com/blog/how-lyfts-mobile-team-does-mobile-ci-at-scale?utm_campaign=CPress&utm_source=ppc&utm_medium=CPress&utm_term=Lyfts-mobile-team-CICD&utm_content=CICD) Buildkite sponsor [PgBouncer 1.17.0 Released: The Lightweight Connection Pooler](https://www.pgbouncer.org/2022/03/pgbouncer-1-17-0) — New functionality and some fixes. Database definitions can now specify host lists. The maximum length of passwords has been increased. Support for OpenSSL 3 has been fixed. PgBouncer Authors [Quickgres 0.4.2: A Pure JavaScript Postgres Client Library](https://github.com/kig/quickgres) — It’s interesting to see a Postgres client library that talks the wire protocol directly with no external dependencies. It’s pretty much all in [a single JS file](https://github.com/kig/quickgres/blob/master/index.js) too if you want to see how it works. Ilmari Heikkinen [ETL Helper: A Python Library for Database to Database Transfers](https://github.com/BritishGeologicalSurvey/etlhelper) — One for the Pythonistas. Works with Postgres, SQLite, SQL Server and Oracle, and I just love that it comes from the [British Geological Survey](https://www.bgs.ac.uk/). British Geological Survey [usql 0.10.0: A Universal CLI Tool for Databases](https://github.com/xo/usql) — It’s inspired by `psql`, but adds some more features and supports tons of databases, both relational and NoSQL. Kenneth Shaw **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|*)