Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

Loading The Titanic Passenger Data Into #PostgreSQL With DBeaver Part 2 https://stokerpostgresql.blogspot.com/2025/10/loading-titanic-passenger-data-into_22.html

PGlite – Embeddable Postgres

https://pglite.dev/

#HackerNews #PGlite #Embeddable #Postgres #PostgreSQL #Database #Development

Even though I mostly use #Datalog databases these days (mostly #Datomic), many #PostgreSQL tidbits make me (unreasonably?) happy. Like this one: “Aggregate first - join later”

https://www.cybertec-postgresql.com/en/super-fast-aggregations-in-postgresql-19/

Loading The Titanic Passenger Data Into #PostgreSQL With DBeaver Part 2 https://stokerpostgresql.blogspot.com/2025/10/loading-titanic-passenger-data-into_22.html

Even though I mostly use #Datalog databases these days (mostly #Datomic), many #PostgreSQL tidbits make me (unreasonably?) happy. Like this one: “Aggregate first - join later”

https://www.cybertec-postgresql.com/en/super-fast-aggregations-in-postgresql-19/

Listen to Database Changes Through the Postgres WAL

https://peterullrich.com/listen-to-database-changes-through-the-postgres-wal

#HackerNews #Listen #to #Database #Changes #Through #the #Postgres #WAL #PostgreSQL #Database #Changes #WAL #Streaming #Database #Development #Data #Engineering

PostgreSQL Conference Germany 2026

https://2026.pgconf.de/registration/

#postgresql

Just published a new article on how to use UUIDv7 today with Python 3.14, Django 5.2 and PostgreSQL 18 🐍

I walk through Python generation, Django models, db_default, PostgreSQL functions, GeneratedField and even UUIDv47 for safer public IDs 🤖

Hope it's useful! 🙂

👉 https://www.paulox.net/2025/11/14/how-to-use-uuidv7-in-python-django-and-postgresql/

#Python #Django #PostgreSQL #UUIDv7 #UUIDv47 #Python314 #Django52 #Postgres18

RegreSQL: Regression Testing for PostgreSQL Queries

https://boringsql.com/posts/regresql-testing-queries/

#HackerNews #RegreSQL #PostgreSQL #RegressionTesting #DatabaseTesting #SoftwareDevelopment

A question for the #MastoAdmin community:

What's your PostgreSQL backup strategy?

How much data would you expect to lose if your primary DB died suddenly?

Seconds? Hours? Days?

#Mastodon #PostgreSQL

PostgreSQL Conference Germany 2026

https://2026.pgconf.de/registration/

#postgresql

News includes ReqLLM 1.0 with standardized LLM APIs, Codicil bringing semantic code understanding to #AI assistants, Tidewave Web expanding to #Python and more, playwright browser pooling, and #PostgreSQL WAL for DB notifications! @elixirlang #ElixirLang https://www.youtube.com/watch?v=tXp8hchfuh0

News includes ReqLLM 1.0 with standardized LLM APIs, Codicil bringing semantic code understanding to #AI assistants, Tidewave Web expanding to #Python and more, playwright browser pooling, and #PostgreSQL WAL for DB notifications! @elixirlang #ElixirLang https://www.youtube.com/watch?v=tXp8hchfuh0

#PostgreSQL 8.1 was released 20 years ago.

New features include: 2 phase commit (comes in handy for distributed and sharded databases), the role system (previously users and groups) and finally Autovacuum became part of the server.

And hopefully no version 8.1 is out there still in production!

The Case Against PGVector

https://alex-jacobs.com/posts/the-case-against-pgvector/

#HackerNews #The #Case #Against #PGVector #PGVector #HackerNews #DataStorage #TechDebate #PostgreSQL

Tried to upgrade #postgresql for my oldfriends.live #Mastodon ( @paul ) instance from 13 to 18 and got incompatible_polymorphics errors following @michael guide. Can anyone offer advice?

The error is:

In database: postgres
aggregate: repack.array_accum(anyelement)
In database: mastodon_production
aggregate: repack.array_accum(anyelement)

@ruud #MastoAdmin

Andres Freund getting ready to tell us everything we need to know to use asynchronous I/O (AIO) with PostgreSQL 18 and beyond

#pgconfeu #postgresql #database #riga

We are excited to welcome LOXODATA as a Partner sponsor of pgDay Paris 2026! We could not run this event without our sponsors.

#postgres #postgresql #pgdayparis

https://2026.pgday.paris/sponsors/

We are excited to welcome LOXODATA as a Partner sponsor of pgDay Paris 2026! We could not run this event without our sponsors.

#postgres #postgresql #pgdayparis

https://2026.pgday.paris/sponsors/