--- title: "PostgREST 12, Supavisor 1.0, and pg_graphql 1.4" publication: "Postgres Weekly" issue: 534 published_at: "2023-12-13" canonical_url: "https://postgresweekly.com/issues/534" --- Plus the Postgres trademark dispute is finally over. | #​534 — December 13, 2023 [Web Version](https://postgresweekly.com/issues/534) Together with [![Bosch\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_1280,h_443/e_make_transparent/co_white,e_outline:17/udmp5biufp3th3c4xz0n.png)](https://www.bosch.com/careers/?utm_campaignid=postgres&utm_source=cooperpress&utm_medium=cpc&utm_campaign=wlab&utm_term=primary&utm_content=recognition) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/l6mvpevlvafms8zr7pyh.jpg)](https://www.timescale.com/blog/a-sneak-peek-into-the-state-of-postgresql-2023/) [A Sneak Peek Into the _State of PostgreSQL 2023_](https://www.timescale.com/blog/a-sneak-peek-into-the-state-of-postgresql-2023/) — Timescale teases us with an initial look at some of the results from the recent _State of PostgreSQL_ survey (full report to follow soon). 888 folks took the survey and shared information about their favorite extensions, opinions on AI, and third party tools they use. Savoia and Tavares (Timescale) [PostgREST 12.0: Serve a RESTful API from a Postgres Database](https://supabase.com/blog/postgrest-12) — An interesting addition to this popular project is that you can handle custom media types and override the built-in ones meaning you can serve up HTML, JavaScript, and more direct from your database. [Project homepage.](https://postgrest.org/en/stable/) Nelson and Chavez [![\](https://copm.s3.amazonaws.com/b88b4316.png)](https://www.bosch.com/careers/?utm_campaignid=postgres&utm_source=cooperpress&utm_medium=cpc&utm_campaign=wlab&utm_term=primary&utm_content=recognition) [Feel the Power of More Than 420,000 Teammates and Work #LikeABosch](https://www.bosch.com/careers/?utm_campaignid=postgres&utm_source=cooperpress&utm_medium=cpc&utm_campaign=wlab&utm_term=primary&utm_content=recognition) — At Bosch, we shape the future with high-quality technologies and services to inspire people and improve their lives. And it’s our people who make us remarkable. Our success is your success. Let’s celebrate together. [Learn more](https://www.bosch.com/careers/?utm_campaignid=postgres&utm_source=cooperpress&utm_medium=cpc&utm_campaign=wlab&utm_term=primary&utm_content=recognition). Bosch sponsor [How pg_graphql Now Supports Postgres Functions](https://supabase.com/blog/pg-graphql-postgres-functions) — [pg_graphql](https://github.com/supabase/pg_graphql) is an extension that adds GraphQL support for querying your database. v1.4 introduced support for exposing user defined functions over GraphQL too. Oliver Rice (Supabase) **IN BRIEF:** - 🥰 After months of back and forth in a dispute over the _PostgreSQL_ trademark, we're delighted to hear that the _PostgreSQL Community Association_ and _Fundación PostgreSQL_ [have reached an amicable resolution.](https://www.postgresql.org/about/news/updates-on-trademark-actions-against-the-postgresql-community-2762/) - 📅 [PG Day Chicago 2024](https://hdombrovskaya.wordpress.com/2023/12/12/pg-day-chicago-2024/) is taking place on April 26. - 🎉 PGConf Europe is taking place _right now_ and there's a [record 720 attendees!](https://twitter.com/pgconfeu/status/1734860251390750980) Hope you're having fun if you're there. - Supabase shares some details on [implementing the parser in the _Postgres Language Server_](https://supabase.com/blog/postgres-language-server-implementing-parser) they're working on. - 📈 An attempt to [benchmark using UUIDv4 vs UUIDv7 primary keys.](https://mblum.me/posts/pg-uuidv7-benchmark/) - The _Ampt_ serverless JavaScript platform has [unveiled Ampt SQL](https://www.getampt.com/blog/introducing-ampt-sql/), a fully managed serverless Postgres database service powered by [Neon.](https://neon.tech/) [Zero Downtime Postgres Upgrades](https://knock.app/blog/zero-downtime-postgres-upgrades) — An engineer shares the tale of how his company upgraded from Postgres 11.9 to 15.3 with zero downtime. [pg_easy_replicate](https://github.com/shayonj/pg_easy_replicate) is a tool we’ve linked to before that automates much of this approach. Brent Anderson (Knock) ['Yeeting' Over 30k Messages/Sec on Postgres with Tembo MQ](https://tembo.io/blog/mq-stack-benchmarking/) — Using the [PGMQ](https://github.com/tembo-io/pgmq) message queue system. Ankenman and Hendel (Tembo) [Storage Strategies for Postgres on Kubernetes](https://www.percona.com/blog/storage-strategies-for-postgresql-on-kubernetes/) Sergey Pronin (Percona) Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/itfv22lzfkcblfqx159h.jpg)](https://github.com/supabase/supavisor) [Supavisor 1.0: A Postgres Connection Pooler from Supabase](https://github.com/supabase/supavisor) — A connection pooler built with Elixir (an Erlang VM/BEAM language) and specifically designed for multi-tenancy. It can be run as a cluster or as a single node. v1.0 adds support for named prepared statements, read replicas and query load balancing, and more besides. Supabase [Postgres Performance at Any Scale, with Intelligent Tuning Advisors](https://pganalyze.com/?utm_source=PostgresWeeklySecondary12132023) pganalyze sponsor [IvorySQL: Open Source Oracle-Compatible PostgreSQL](https://www.ivorysql.org/) — [Orafce](https://github.com/orafce/orafce) is a popular suite of Oracle compatibility functions and packages and IvorySQL uses it behind the scenes of its broader compatibility layer. HighGo - [Pgpool-II 4.5.0](https://www.postgresql.org/about/news/pgpool-ii-450-is-now-released-2763/) – Postgres connection pooler. - [pgwire 0.17](https://github.com/sunng87/pgwire) – Postgres wire protocol Rust library. - [DoltgreSQL 0.2](https://github.com/dolthub/doltgresql) – Version-controlled Postgres. **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|*).