~postgresweekly | Issue 567 - Functions, functions, everywhere? (8)

Six Degrees of Kevin Bacon - Postgres Style — Given two random actors, could you join those actors within six steps through other actors that have co-starred in movies together? That’s the game of Six Degrees of Kevin Bacon and Paul sets out to see if Postgres can tackle the task of finding such connections.

Why I Always Use Postgres Functions For Everything — There are numerous schools of thought on the roles of functions in production databases, so many of you may disagree with the author. Nonetheless, he explains why he appreciates the encapsulation and abstraction that user defined functions provide.

Free Guide: Boost Postgres Performance by 3x — Drawing from proven practices honed tuning thousands of databases, we walk you through the process to achieve a 3x performance boost in your Postgres databases while reducing disk data load by 500x.

How to Create a Postgres FDW with WebAssembly — Foreign data wrappers (FDWs) provide a way to give Postgres powers to query external data sources as if they were local tables. Using the Rust-based Wrappers FDW framework, you can create WebAssembly powered FDWs which can be dynamically deployed at runtime.

Postgres Webhooks with pgstream — A look at a use case for the pgstream change data capture tool: calling webhooks based upon Postgres data and schema changes.

Understanding pgvector's HNSW Index Storage — pgvector is widely used for implementing vector similarity search features in Postgres, but how are its indexes stored under the hood?

Prisma 5.19.0: The JS ORM Now with 'Typed SQL' — Prisma is a popular declaratively-driven ORM in the Node.js / TypeScript world and its new version makes it possible to write raw SQL queries in a type-safe way.

pgMonitor: An Open Source Monitoring Extension — pgMonitor is the name of a Postgres metrics tracking tool Crunchy Data has maintained for years, but it’s now available as an open source extension too.