PostgreSQL

I came across this blog and thought it was a nice demonstration of the backup, recovery and migration options in CNPG, and the cloud-native way of working in a tough situation: treat your servers as cattle, not as pets. Spin up a new container and kill the problematic old one.

I'm doing an extension that creates a pool of named background workers. Happy to hear any feedback on this.

Via fosstodon.org/@hunleyd/113205392466307810

Via fosstodon.org/@hunleyd/113080821469886930

Via https://mastodon.social/@stevenan/112899205276153700

Via https://mastodon.social/@hunleyd@fosstodon.org/112220150255942506

Prolog language for PostgreSQL

PostgreSQL maintainer Simon Riggs has died in a small airplane crash, on Tuesday.

Lemmy currently uses distinct tables like post_like: (post_id, person_id, score) and post_saved. Unfortunately this causes performance issues when we have to join many of these tables to create views.

We walk through the incremental backup feature committed to the Postgres 17 development branch by Robert Haas. We show an example on our local machine.

Via https://mstdn.social/@michristofides/111738621686733546

via https://fosstodon.org/@adamchainz/111694569833742858

Via https://botsin.space/@planetpostgresql/111602978945432365

PGDay Chicago is a non–profit, community–run conference series in the United States focused on PostgreSQL, the world’s leading open source database. Our conference delivers one day packed with presentations about PostgreSQL and related technologies and the usual hallway and social track. Our conference will be held April 26th, 2024, in Chicago, IL.

A managed Postgres offering developed by Supabase and Fly.io

Example flow is on the image. Here I want to accomplish if playlist removed, make it delete image too.