--- title: "Postgres as an 'everything interface'" publication: "Postgres Weekly" issue: 488 published_at: "2023-01-11" canonical_url: "https://postgresweekly.com/issues/488" --- Plus the biggest commits to Postgres, 'rowalescence', and getting Haskell into Postgres. | #​488 — January 11, 2023 [Web Version](https://postgresweekly.com/issues/488) Together with [![Crunchydata\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_430,h_100/e_make_transparent/co_white,e_outline:7/xyflkz7n00elwtgja9ne.png)](https://crunchybridge.com/start?utm_source=cppg-prim-0111) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/v4kukgkknefuxhhxxqbq.jpg)](https://supabase.com/blog/postgres-foreign-data-wrappers-rust) [Supabase Wrappers: An FDW Framework Written in Rust](https://supabase.com/blog/postgres-foreign-data-wrappers-rust) — [Foreign data wrappers](https://wiki.postgresql.org/wiki/Foreign_data_wrappers) (FDWs) provide a mechanism within Postgres to access data on remote/external systems, whether other SQL databases or flat files. Supabase has built _Wrappers_ in an attempt to bring a myriad of FDWs under one roof (already including ones to integrate with Stripe, Firebase, and Airtable) and to make it easier to build more. **QUOTE:** _“The FDW interface also future-proofs Postgres. Instead of keeping up with the latest technological advances, Postgres can instead act as an interface whenever they develop. The recent advance in AI and ML is a great example of this: AI technology is developing faster than the time it would take to build a new 'AI database'. With a FDW, Postgres can become the interface to this technology and many other technological advances in the future.”_ [![\](https://copm.s3.amazonaws.com/a982abfd.png)](https://crunchybridge.com/start?utm_source=cppg-prim-0111) [❤️ Postgres](https://crunchybridge.com/start?utm_source=cppg-prim-0111) — You need a database provider that loves Postgres as much as you do. We'll take care of all the hassle - monitoring, backups, HA, disaster recovery so you don't have to. Want amazing support? We'll be there when you have questions. Crunchy Bridge sponsor [Faster PostgreSQL to BigQuery Transfers](https://tech.marksblogg.com/postgresql-to-bigquery.html) — The author, well known for his ‘1.1 Billion Taxi Rides’ database benchmarks, demonstrates how using ClickHouse to export Postgres tables to Parquet for importing into BigQuery is quicker than using compressed CSVs. A beautifully practical post and of obvious interest to anyone doing GIS work in particular. Mark Litwintschik [A Short Summary of 2022 in the Postgres World](https://www.migops.com/blog/a-short-summary-of-the-year-2022-in-the-postgresql-world/) — Back in December, we did a [best of Postgres Weekly in 2022 issue](https://postgresweekly.com/issues/486) but Avinash takes a more news-oriented look at what happened to Postgres last year, including its DB Engines ranking, releases, brand new extensions, and security vulnerabilities. Avinash Vallarapu **IN BRIEF:** - 📅 🇫🇷 [pgDay Paris 2023 is back this March](https://www.postgresql.org/about/news/pgday-paris-2023-call-for-sponsors-and-registrations-2567/) with [registration](https://2023.pgday.paris/registration/) now open, plus a last minute call for new sponsors. - While doing some 'poking around' the Postgres git repository, Peter Eisentraut decided to [find out what the _biggest commits_ were.](http://peter.eisentraut.org/blog/2023/01/11/postgresql-largest-commits) How he does it may be even more interesting than the end results. [Looking at Index Types in Postgres](https://www.red-gate.com/simple-talk/databases/postgresql/index-types-in-postgresql-learning-postgresql-with-grant/) — A straightforward primer introducing common types of indexes used by Postgres including B-Trees, GIST, GIN and BRIN indexes. Grant Fritchey [Generate Excel Workbooks from Postgres on AWS](https://aws.amazon.com/blogs/database/generate-excel-workbooks-from-amazon-rds-for-postgresql-or-amazon-aurora-postgresql/) — A distinctly AWS-flavored recipe for extracting data from Postgres (both RDS and Aurora) into Excel workbooks by way of AWS Lambda and S3. Shaik, Chintha, and Agarwal (AWS) [Free eBook Download: Understanding Kubernetes (Updated Edition)](https://www.linode.com/content/kubernetes-guide/?utm_source=postgres_weekly&utm_medium=newsletter_sponsorship&utm_campaign=newsletter_sponsorship-postgres_weekly-kubernetes&utm_content=&utm_term=) Linode sponsor [`SUBSTR` Functionality Differences Between Oracle and Postgres](https://databaserookies.wordpress.com/2023/01/09/substr-functionality-differences-between-oracle-and-postgresql-what-you-need-to-know/) — Valuable if you’re involved in a migration.. Deepak Mahto [How Postgres 15 Speeds Up WAL Archiving](https://www.percona.com/blog/speed-up-of-the-wal-archiving-in-postgresql-15/) Jobin Augustine [Using the `row_number` Window Function to Remove Duplicates](https://medium.com/@walttonm/using-the-window-function-row-number-to-remove-duplicates-in-postgresql-5aef1edfb78c) Waltton Morais 🛠 Code and Tools [`pg_rowalesce`: Coalescence for Rows](https://github.com/bigsmoke/pg_rowalesce) — `rowalesce()` is like `coalesce()`, but for rows and other composite types. Rowan Rodrik van der Molen [PL/Haskell 1.1: Use Haskell from within SQL Functions](https://github.com/ed-o-saurus/PLHaskell) — Procedural, meet functional. Ed Behn [sqld: A 'Server Mode' for libSQL/SQLite](https://github.com/libsql/sqld) — This is a bit of an unusual one. Rather than using Postgres’s wire protocol in front of another database, this is essentially SQLite in front of the Postgres wire protocol (the idea being apps that use SQLite - or the libSQL fork of it, anyway - can continue to act as they already do, but are actually using Postgres behind the scenes). libSQL [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/lxhrzh8mtvuog830lsqg.jpg)](https://github.com/ankane/pghero) - [PgHero 3.1](https://github.com/ankane/pghero) ↳ A performance dashboard for Postgres. - [knex.js 2.4](https://github.com/knex/knex) ↳ Node.js SQL query builder. - [pg-boss 8.3](https://github.com/timgit/pg-boss) ↳ Node.js job queue based on Postgres. - [DenoDB 1.2](https://github.com/eveningkid/denodb) ↳ Postgres, MySQL, SQLite, and MongoDB ORM for Deno. **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|*)