--- title: "A package manager for Postgres?" publication: "Postgres Weekly" issue: 502 published_at: "2023-04-19" canonical_url: "https://postgresweekly.com/issues/502" --- Plus what parts of SQL 2023 does Postgres support, who's contributing to Postgres, and Postgres 16's shuffling abilities. | #​502 — April 19, 2023 [Web Version](https://postgresweekly.com/issues/502) 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://www.crunchydata.com/case-studies/carerev?utm_source=cp-prim-0414) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/gupxcr51xne0vpr44hw3.jpg)](https://supabase.com/blog/dbdev) [dbdev: A Postgres Package Manager](https://supabase.com/blog/dbdev) — The folks at Supabase have put [database.dev](https://database.dev/) into preview, a site containing numerous _trusted language extensions_ for Postgres, building upon [an idea begun by AWS last year.](https://aws.amazon.com/blogs/aws/new-trusted-language-extensions-for-postgresql-on-amazon-aurora-and-amazon-rds/) Think of `dbdev` as a sort of Postgres equivalent of `npm` or `pip`. **It’s still early days,** but the general idea is to make installing extensions into Postgres environments, including on the cloud, easier. Supabase [Postgres and SQL:2023: What's Supported?](http://peter.eisentraut.org/blog/2023/04/18/postgresql-and-sql-2023) — Peter recently [posted about the progress of SQL:2023](http://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new), but now he takes a quick look at what parts are actually supported in Postgres. Peter Eisentraut [![\](https://copm.s3.amazonaws.com/1077caa8.jpg)](https://www.crunchydata.com/case-studies/carerev?utm_source=cp-prim-0414) [The Postgres Provider You Always Wanted](https://www.crunchydata.com/case-studies/carerev?utm_source=cp-prim-0414) — "What a different support experience Crunchy is. Every support ticket is valuable. We’re encouraged to ask questions. We’re able to do so much more working with a partner who cares as much about data as we do." Rob Sullivan, CareRev. Crunchy Bridge sponsor **IN BRIEF:** - Robert Haas has done his [annual look at who contributed to Postgres](http://rhaas.blogspot.com/2023/04/who-contributed-to-postgresql.html) over the past year. Tom Lane, Andres Freund and Peter Eisentraut take the top three spots in terms of commits. - 📅 [Postgres Ibiza is back for 2023](https://postgresql.fund/blog/postgresql-ibiza-2023-postgres-and-ecosystem/) taking place this August 29-31 on the sunny Balearic island famous for its party scene. The CFP opens soon. - [Crunchy Data's David Christensen](https://postgresql.life/post/david_christensen/) is this week's _PostgreSQL Person of the Week._ - ▶️ [Citus Con has taken place](https://www.citusdata.com/cituscon/2023/schedule/) over the past couple of days and the [raw](https://www.youtube.com/watch?v=LiFkgckp8fY) [livestreams](https://www.youtube.com/watch?v=aw3XyToRXMc) are watchable. We're picking through them now but also expect individual talks will be released soon. [Can There Be Too Many Partitions?](https://kmoppel.github.io/2023-04-18-can-there-be-too-many-partitions/) — Kaarel ran some benchmarks (taking 56 hours in total) to see the performance effects of having between zero and 4096(!) partitions. Ultimately, not a lot: _“Postgres seems to handle a “normal” amount of partitions very well - planning time seems to increase steadily in percentage wise, but in real numbers wasn’t noteworthy.”_ Kaarel Moppel [Postgres 16 Array Sampling and Shuffling Functions](https://www.depesz.com/2023/04/18/waiting-for-postgresql-16-add-array_sample-and-array_shuffle-functions/) — Yet more bits and pieces coming to Postgres 16 (final release expected later this year) in the shape of `array_sample` and `array_shuffle` functions to get random elements from an array or to randomize an entire array. Hubert depesz Lubaczewski [Underscores in Numeric Constants in Postgres 16](https://www.cybertec-postgresql.com/en/underscores-in-numeric-constants-in-postgresql-16/) — It’s a relatively small quality of life improvement, but Postgres 16 will let you write long numbers in such a fashion: `1_500_000_000` or even a less obvious construction like`3.14159_26535_89793` Pavlo Golub [Working with Postgres from PowerShell with ODBC](https://www.migops.com/blog/powershell-with-odbc-to-interact-with-postgresql-linux-and-windows/) Michael Suman [Writing Data from Postgres to MongoDB](https://www.crunchydata.com/blog/writing-data-from-postgres-to-mongodb) Christopher Winslett Code and Tools [PostgREST 11.0: Serve a RESTful API from a Postgres Database](https://postgrest.org/en/stable/) — [v11](https://github.com/PostgREST/postgrest/releases/tag/v11.0.0) of this popular Haskell-based system adds a lot of little niceties. Nelson and Chavez - [pg-boss 9.0](https://github.com/timgit/pg-boss) ↳ Postgres-based job queuer for Node.js. - [Slonik 33.3](https://github.com/gajus/slonik) ↳ Type-safe Postgres client for Node.js. - [data-diff 0.7.2](https://github.com/datafold/data-diff) ↳ Compare tables within or across databases. - [usql 0.14.3](https://github.com/xo/usql) – Universal CLI app for SQL databases. - [Jet 2.10](https://github.com/go-jet/jet) – Type safe SQL builder for Go. - [Dexter 0.5](https://github.com/ankane/dexter) – Automatic indexer for 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|*)