--- title: "Doing everything with Postgres" publication: "Postgres Weekly" issue: 541 published_at: "2024-02-07" canonical_url: "https://postgresweekly.com/issues/541" --- Plus '5mins of Postgres' turns 100, a new query plan visualization tool, and some more events news. | #​541 — February 7, 2024 [Web Version](https://postgresweekly.com/issues/541) Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://pganalyze.com/ebooks/tuning-postgres-autovacuum?utm_source=PostgresWeeklyPrimary02072024) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/yladwotimj1d9jqsoadf.jpg)](https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f06dbb) [Postgres is Enough: Doing Everything with Postgres?](https://gist.github.com/cpursley/c8fb81fe8a7e5df038158bdfe0f06dbb) — **It’s just a GitHub gist full of links,** but leans on the idea communicated in Stephan Schmidt’s [Just Use Postgres for Everything](https://www.amazingcto.com/postgres-for-everything/) to show off the various projects that _let_ you do everything, adding features like background jobs, mapping, audit logging, vector search, API serving, and more directly to our favorite database. Chase Pursley [![\](https://copm.s3.amazonaws.com/92ad5d55.png)](https://pganalyze.com/ebooks/tuning-postgres-autovacuum?utm_source=PostgresWeeklyPrimary02072024) [eBook: Tuning Autovacuum for Best Postgres Performance](https://pganalyze.com/ebooks/tuning-postgres-autovacuum?utm_source=PostgresWeeklyPrimary02072024) — Learn about tuning settings for scheduling and performance, reducing autovacuum overhead during business hours, the xmin horizon and how it blocks vacuums, why to avoid anti-wraparound vacuums and how to reduce bloat by tuning dead tuple thresholds. pganalyze sponsor [Implementing System-Versioned Tables in Postgres](https://hypirion.com/musings/implementing-system-versioned-tables-in-postgres) — There’s no official support for system-versioned tables in Postgres, though there is [the temporal_tables extension](https://github.com/arkhipov/temporal_tables), but what if you want to implement the idea yourself? Three triggers and an index to the rescue! Jean Niklas hyPiRion L'orange _IN BRIEF:_ - [Work on native UUID v7 support](https://commitfest.postgresql.org/47/4388/) in Postgres is coming along well and provoked [a fair bit of discussion](https://news.ycombinator.com/item?id=39260614) on _Hacker News_ this week. - 📺 Congratulations to Lukas Fittl and _pganalyze_ for [reaching 100 episodes of _'5mins of Postgres'_](https://pganalyze.com/blog/5mins-postgres-reducing-table-size), their series of handy bitesize Postgres videos ([full YouTube playlist here](https://www.youtube.com/playlist?list=PLhqxwIAgz78HZhWyu3UyKrCWNk7VWjVpj)). - DB-Engines called Postgres its [DBMS of the Year for 2023](https://db-engines.com/en/blog_post/106), and while Adrien Nayrat isn't worried about the future of _Postgres_ per se, he's concerned about [the future of DBAs and DBA skillsets.](https://blog.anayrat.info/en/2024/02/05/postgres-again-elected-dbms-of-the-year-in-2023-but-im-worried/) - 🇧🇪 [PGDay Belgium 2024](https://pgconf.be/) takes place in May and the [Call for Speakers](https://pgconf.be/#cfs) is now open if you want to speak there. - 🇨🇭 [Swiss PGDay 2024](https://www.postgresql.org/about/news/swiss-pgday-2024-announcement-and-cfs-2803/) has also been announced and takes place in June near Zurich. It, too, has [an open Call for Speakers.](https://www.pgday.ch/2024/#cfs) - Paul Ramsey has written a little [about building the program for the PGConf.dev conference](https://blog.cleverelephant.ca/2024/02/pgconf-program.html), taking place in Vancouver this May. [Benchmarking Vector Search Approaches: pgvector vs Lantern](https://tembo.io/blog/postgres-vector-search-pgvector-and-lantern) Binidxaba (Tembo) [Changing a Column from Integer to Boolean in One Transaction](https://fluca1978.github.io/2024/02/05/PostgreSQLChangeIntegerToBooleanColumn.html) Luca Ferrari 📰 Classifieds 🚀 Free [pgEdge](https://www.pgedge.com/get-started/cloud?utm_campaign=Cloud%20Developer%20Launch&utm_source=Postgres%20Weekly%20Sponsorship&utm_medium=Postgres%20Weekly&utm_term=Postgres%20Weekly&utm_content=Postgres%20Weekly) distributed Postgres DB with 3 node active-active cluster and one-click provisioning across 3 regions. [Free t-shirt to first 500](https://www.pgedge.com/get-started/cloud?utm_campaign=Cloud%20Developer%20Launch&utm_source=Postgres%20Weekly%20Sponsorship&utm_medium=Postgres%20Weekly&utm_term=Postgres%20Weekly&utm_content=Postgres%20Weekly). --- Read about PostgreSQL on [Redgate’s Simple Talk journal](https://www.red-gate.com/simple-talk/databases/postgresql/?utm_source=postgresweekly&utm_medium=email&utm_campaign=mc-202402-t2-sodl-xdb-ubi-gc-all&utm_content=simple-talk-series) – featuring a range of authors sharing their expertise on different technical topics. --- 🐲 [Dragonfly](https://www.dragonflydb.io/cloud?utm_campaign=cooperpress_ruby_jan24&utm_source=ppc&utm_medium=newsletter) is a modern Redis replacement, delivering better performance and simpler operations at a lower cost. [Start your free trial today](https://www.dragonflydb.io/cloud?utm_campaign=cooperpress_ruby_jan24&utm_source=ppc&utm_medium=newsletter). 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/ywozaca5gedryljgxsxe.jpg)](https://plansplainer.com/) [PlanSplainer: A New Way to Visualize Query Plans?](https://plansplainer.com/) — [explain.depesz.com](https://explain.depesz.com/) is perhaps the best known Web-based tool for this task, but this is an interesting alternative that presents the plan in a more visual way. _(The creator admits it is still ‘very experimental’ so your mileage may vary.)_ markmeeus 💡 If you ever need a random plan to play with, [explain.depesz.com's public history](https://explain.depesz.com/history) collection may be helpful! [IntegreSQL: API to Manage Isolated Postgres Databases for Testing](https://github.com/allaboutapps/integresql) — Provides a RESTful JSON API for managing Postgres templates and spinning up (and managing the pool of) databases for integration testing purposes. all about apps GmbH [PGTera: Extension to Render Tera HTML Templates](https://github.com/f-prime/pgtera?tab=readme-ov-file) — [Tera](https://keats.github.io/tera/) is a Jinja2-inspired template engine for Rust, and if you need to return complete, rendered HTML views from your database, it's another option. Frankie Primerano [pgenv: Postgres Binary Manager for the Shell](https://github.com/theory/pgenv) — Makes it simpler to build and run different Postgres releases and switching between them to test, etc. It's just gained [a `status` command](https://fluca1978.github.io/2024/02/06/pgenvStatusCommand.html) for getting the status of a specific instance. Ferrari, Wheeler, et al. [Ibis 8.0: A Dataframe Framework for Python](https://ibis-project.org/) — Provides a universal interface for data wrangling in Python with a focus on tabular data (using dataframes) and support for all the main database systems, including Postgres and SQLite. [GitHub repo.](https://github.com/ibis-project/ibis) Ibis Developers [Directus 10.9: Wrap an SQL Database with a Real-Time GraphQL and REST API](https://github.com/directus/directus) — A Node.js-based system that can act as a frontend to Postgres, SQLite, MySQL, Oracle, and other databases, providing a modern dashboard, client, and REST and GraphQL APIs. _(Note [the unusual license](https://github.com/directus/directus?tab=License-1-ov-file#readme) that limits production use to below a certain revenue level then reverts to GPL in three years.)_ Monospace, Inc. - [PgManage 1.0 RC 1](https://github.com/commandprompt/pgmanage?tab=readme-ov-file#pgmanage-10-rc-1) – Web-based tool for Postgres management. - [Goose 3.18](https://github.com/pressly/goose) – Database migration tool. Supports SQL _and_ Go functions. - [CloudNativePG 1.22.1](https://www.postgresql.org/about/news/cloudnativepg-1221-1213-and-1206-released-2805/) – Kubernetes operator for Postgres. - [data-diff 0.11](https://github.com/datafold/data-diff) – Compare tables within or across databases. - [pgBouncer 1.22.0](https://github.com/pgbouncer/pgbouncer/releases/tag/pgbouncer_1_22_0) – Popular connection pooler. - [PGXN Tools Docker image improvements.](https://blog.pgxn.org/post/741049567045468160/pgxn-tools-v4) **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|*).