--- title: "A new Postgres platform opens its source" publication: "Postgres Weekly" issue: 457 published_at: "2022-06-01" canonical_url: "https://postgresweekly.com/issues/457" --- Plus Aurora + triggers == real time notifications on AWS, and how to query Postgres from DuckDB. | #​457 — June 1, 2022 [Web Version](https://postgresweekly.com/issues/457) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/zusgmvmazvtcrp1lw9bx.jpg)](https://github.com/neondatabase/neon) [Neon: An Open Source Serverless Alternative to AWS Aurora Postgres?](https://github.com/neondatabase/neon) — This is the codebase behind [an eponymously named company](https://neon.tech/) (founded by Nikita Shamgunov who co-founded MemSQL) building a multi-cloud serverless Postgres platform and giving us strong [PlanetScale](https://planetscale.com/) vibes right now, but with extra source. Neon [On View Permissions and Row-Level Security](https://www.cybertec-postgresql.com/en/view-permissions-and-row-level-security-in-postgresql/) — [Views](https://www.postgresql.org/docs/9.2/sql-createview.html) provide a handy way to give access to a predefined SQL query and they can also be used as an extra layer of security by restricting access to a view’s underlying table while still allowing use of the view. This post covers the basics while also looking at Postgres 15’s forthcoming `security_invoker` option. Laurenz Albe [![\](https://copm.s3.amazonaws.com/1416a7a6.jpg)](https://www.cockroachlabs.com/compare/cockroachdb-vs-postgresql/?utm_source=cooperpress&utm_medium=sponsor&utm_campaign=brand-pipe-postgres-compete&utm_content=lp-postgres-learn-how-learn-more-newsletter-0601&utm_term=prosp-postgres-weekly-email-primary) [Postgres Possibilities with Elastic Scale? That’s CockroachDB](https://www.cockroachlabs.com/compare/cockroachdb-vs-postgresql/?utm_source=cooperpress&utm_medium=sponsor&utm_campaign=brand-pipe-postgres-compete&utm_content=lp-postgres-learn-how-learn-more-newsletter-0601&utm_term=prosp-postgres-weekly-email-primary) — Unlike Postgres managed services from AWS and GCP, auto-scaling CockroachDB lets you build fast with familiar syntax, minimize operations, and pay as you go. Plus the cloud freedom to deploy your workloads wherever and however you like. Cockroach Labs sponsor [Looking Under the Hood at AlloyDB's Columnar Engine](https://cloud.google.com/blog/products/databases/alloydb-for-postgresql-columnar-engine) — Two weeks ago, we mentioned Google’s release of [AlloyDB](https://cloud.google.com/blog/products/databases/introducing-alloydb-for-postgresql), its Aurora-a-like Postgres-compatible scalable managed database. This post digs a little more into its unique features and how a columnar engine enables (significantly) faster performance on certain types of query. Sheshadri Ranganath (Google Cloud) [Near Real-Time Notifications from Aurora PostgreSQL with Triggers, Lambda, and SNS](https://aws.amazon.com/blogs/database/enable-near-real-time-notifications-from-amazon-aurora-postgresql-by-using-database-triggers-aws-lambda-and-amazon-sns/) — This is the sort of plumbing work that AWS is very well suited for. This tutorial covers the process of enabling notifications of data changes on a Postgres-compatible Aurora database to be sent through a serverless function and then on to other places via SNS. Just be careful not to send yourself an email every time a table gets a new row added.. ;-) Wajid Ali Mir and Anjan Mukherjee [The Architecture of pgAdmin 4](https://www.enterprisedb.com/blog/pgadmin-4-architecture) — [pgAdmin](https://www.pgadmin.org/) is a popular browser-based Postgres dashboard and management tool and if you’ve wondered what moving parts it has, these diagrams are for you. Did you realize pgAdmin has a database that _isn’t_ Postgres at the heart of it…? Yogesh Mahajan (EDB) [Compose Transporter 1.1: Sync Data Between Persistence Engines](https://github.com/compose/transporter) — I love how it bills itself _“like ETL only not stodgy”._ This Go-powered tool lets you connect together various databases (MongoDB, Postgres, MySQL, Elasticsearch, and more), files, and other resources, run some basic transformations (optionally) and then send the data off elsewhere. So, yes, ETL basically. Compose [How to Backup and Restore Data with `pg_rman`](https://www.highgo.ca/2022/05/27/how-to-do-backup-and-restore-for-postgresql-using-pg_rman/) — [pg_rman](https://github.com/ossc-db/pg_rman) is a Postgres backup and restore tool we’ve not mentioned before, but it’s been around many years and supports right up to Postgres 15 beta. Its goal is to be as easy to use as `pg_dump` but work for online backups. David Zhang [Querying SQLite and Postgres Data from DuckDB](https://pradeepchhetri.xyz/til/duckdbexternal/) — [PostgresScanner](https://github.com/duckdblabs/postgresscanner) provides an FDW-style integration between [DuckDB](https://duckdb.org/), a popular in-process SQL OLAP DBMS (imagine SQLite but for OLAP), and Postgres. Cupper [Keep Up with the Latest in Startups, Tech, & Programming in Just 5 Min](https://tldr.tech/signup?utm_source=pw0601) TLDR Newsletter sponsor [Exporter2Perfdata: Connecting Postgres Monitoring Tools](https://www.crunchydata.com/blog/exporter2perfdata-connecting-postgres-monitoring-tools) — [exporter2perfdata](https://github.com/CrunchyData/exporter2perfdata/) is a new open source tool (written in Go) that collects metrics from Prometheus exporters and converts it to perfdata format for Icinga 2 / Nagios. Crunchy Data [A Guide to Managed PostgreSQL Services](https://piccolo-orm.com/blog/a-guide-to-managed-postgre-sql-services/) — A basic but useful list and series of considerations. Dan Townsend [How to Cancel a Hanging Postgres Query](https://www.cybertec-postgresql.com/en/cancel-hanging-postgresql-query/) Laurenz Albe **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|*)