--- title: "Saying hello to the SQL Server users" publication: "Postgres Weekly" issue: 384 published_at: "2020-12-02" canonical_url: "https://postgresweekly.com/issues/384" --- Plus fun with PostGIS, triggers, Java, and even .NET | #384 — December 2, 2020 [Web Version](https://postgresweekly.com/issues/384) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/zbxlsu73r0be4ghuyjpc.jpg)](https://aws.amazon.com/blogs/opensource/want-more-postgresql-you-just-might-like-babelfish/) [Amazon Unveils 'Babelfish', a SQL Server to Postgres Translation Layer](https://aws.amazon.com/blogs/opensource/want-more-postgresql-you-just-might-like-babelfish/) — When you’ve spent years building data systems on top of SQL Server or Oracle, migrating to something like Postgres could seem like a pipedream. AWS has unveiled _Babelfish_ to help in future – it’s designed to let Postgres work with apps built solely for SQL Server. It’s going to be open sourced in 2021, but is in preview specifically for _Aurora_ now. Matt Asay (AWS) [PostGIS Trajectory Tricks: Playing with Space and Time](https://blog.rustprooflabs.com/2020/11/postgis-trajectory-intro) — A fun, yet practical, post demonstrating how Postgres and PostGIS can be used for routing and calculating travel times and progress. Ryan Lambert [![\](https://copm.s3.amazonaws.com/418671b9.png)](https://www.postgresbuild.com/registration?SQF_SOURCE=Postgres-Weekly) [Postgres Build 2020 - PostgreSQL Online Conference [Free\]](https://www.postgresbuild.com/registration?SQF_SOURCE=Postgres-Weekly) — Listen to 25+ talks on the latest in PostgreSQL and on how PostgreSQL helps businesses. This conference will also provide wellness sessions to promote health and revitalize. Join us from December 8 - 9. [Register now](https://www.postgresbuild.com/registration?SQF_SOURCE=Postgres-Weekly). EDB sponsor [Running PgBouncer on AWS Elastic Container Service](https://www.revenuecat.com/blog/pgbouncer-on-aws-ecs) — RevenueCat has an Aurora-based database, wanted a connection pooler, and RDS Proxy didn’t fit the bill. Tony Cosentini (RevenueCat) [How pgBackRest is Addressing Slow WAL Archiving](https://www.percona.com/blog/2020/12/01/how-pgbackrest-is-addressing-slow-postgresql-wal-archiving-using-asynchronous-feature/) — [pgBackRest](https://pgbackrest.org/) is a backup and restore tool. This post digs into one way it’s becoming faster with _asynchronous_ archiving. Jobin Augustine [Postgres Configuration Changes to Make Post-Installation](https://www.percona.com/blog/2020/09/29/postgresql-configuration-changes-you-need-to-make-post-installation/) — So you’ve installed Postgres onto your machine, and you want to start working with it. What’s next? Configuration changes! Robert Bernier (Percona) [How a Postgres Extension Shellcode Execution Exploit Works](https://www.phrozen.io/resources/paper/41df297b-cfe3-43ec-88e8-0686e5548dd5) — This would take a little work to pull off, as it requires a user be able to execute queries as a privileged user and also to place a specially crafted DLL on the server, but it’s useful to be aware of vectors like this. Phrozen [Building a Modern Backend with TypeScript, PostgreSQL and Prisma](https://www.prisma.io/blog/series/modern-backend-bdes2ps5kibb) — A four part written/video series focused on the role of the database in every aspect of backend development. Prisma sponsor [How to Write a Trigger for Checking a Given Value Before `INSERT` or `UPDATE`](https://stackoverflow.com/q/22746741/3951) — Seen via [Vlad Mihalcea.](https://twitter.com/vlad_mihalcea/status/1333844692337913859) Stack Overflow [Calling a Postgres Stored Procedure from Java (and Current Limitations)](https://www.highgo.ca/2020/11/25/calling-a-stored-procedure-in-postgrsql-from-java-and-its-current-limitations/) Ahsan Hadi [Deploy Pgpool-II on Kubernetes to Achieve Query Load Balancing and Monitoring](https://b-peng.blogspot.com/2020/11/gpool2-on-k8s.html) Bo Peng 🔧**Tools and Code** [Marten: A Postgres-Based Document Database and Event Store for .NET](https://martendb.io/) — Essentially a library that lets .NET developers work with Postgres’s powerful JSON indexing and querying features in an abstracted way. There’s a new _.NET Core Podcast_ episode featuring [an interview with Marten developer Jeremy Miller](https://dotnetcore.show/episode-65-marten-db-with-jeremy-miller/) that you might find useful to get the bigger picture. .NET Foundation [Serverless-Postgres: Manage Postgres Connections at Serverless Scale in Node.js](https://github.com/MatteoGioioso/serverless-pg) — [RDS Proxy](https://aws.amazon.com/rds/proxy/) is one way to handle lots of simultaneous database connections but.. costs money. This doesn’t, and if you’re using a library built on top of `node-pg`, you might find it useful. Matteo Gioioso [check_pgactivity 2.5: A Postgres Plugin for Nagios](https://github.com/OPMDG/check_pgactivity) — Use Nagios for monitoring? Use this to have it monitor Postgres too. v2.5 improves Postgres 12 and 13 support amongst [other things.](https://github.com/OPMDG/check_pgactivity/releases/tag/REL2_5) OPM Development Group **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! --- **Want to sponsor?** Email `[kristina@cooperpress.com](mailto:kristina@cooperpress.com)` for details. --- **Want more?** You might like [DB Weekly](https://dbweekly.com/?utm_source=pg&utm_medium=email&utm_campaign=footer-promo), our more general database newsletter covering data storage trends, new database types, and more. --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)