This is an extremely interesting article looking at the tradeoffs of using #pgvector for #Postgres in production, including the different vector indexing algorithms, metadata filtering, and hybrid search. I'm not sure about its conclusions yet, but definitely food for thought! https://alex-jacobs.com/posts/the-case-against-pgvector/

A fun looking project 🤩 SSE for Django using Postgres pub/sub as the messaging layer

Yet another great example of async Django. Long lived ASGI connections that just aren’t feasible with WSGI’s worker-per-connection model.

I’m looking forward to giving it a play.

https://github.com/usmanhalalit/DjangoRealtime #django #sse #postgres #async

PGlite – Embeddable Postgres

https://pglite.dev/

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

A fun looking project 🤩 SSE for Django using Postgres pub/sub as the messaging layer

Yet another great example of async Django. Long lived ASGI connections that just aren’t feasible with WSGI’s worker-per-connection model.

I’m looking forward to giving it a play.

https://github.com/usmanhalalit/DjangoRealtime #django #sse #postgres #async

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

DBOS Java – Postgres-Backed Durable Workflows

https://github.com/dbos-inc/dbos-transact-java

#HackerNews #DBOSJava #Postgres #Workflows #DurableTech #GitHub #Innovation

J'ai été ravie de présenter une keynote à PyCon FR 2025. Je partage ici les slides de ma conférence en forme de blog.

C'était mon premier #PyConFR et j'ai beaucoup apprécié cet événement acceuillant, bien organisé et avec des conférences hyper intéressantes et de trés bonne qualité.

J'espère revenir l'anné prochaine !

https://karenjex.blogspot.com/2025/11/le-reve-de-tout-enfant-devenir-dba.html

#Python #Postgres #PostgreSQL

J'ai été ravie de présenter une keynote à PyCon FR 2025. Je partage ici les slides de ma conférence en forme de blog.

C'était mon premier #PyConFR et j'ai beaucoup apprécié cet événement acceuillant, bien organisé et avec des conférences hyper intéressantes et de trés bonne qualité.

J'espère revenir l'anné prochaine !

https://karenjex.blogspot.com/2025/11/le-reve-de-tout-enfant-devenir-dba.html

#Python #Postgres #PostgreSQL

Wrote a CLI for formatting SQL within sqlx macros like query_as!

It includes a GitHub CI Action for format checks and uses the sqruff formatter under the hood.

https://github.com/jflessau/sqlx-fmt

#rust #sql #postgres #ci #github

Wrote a CLI for formatting SQL within sqlx macros like query_as!

It includes a GitHub CI Action for format checks and uses the sqruff formatter under the hood.

https://github.com/jflessau/sqlx-fmt

#rust #sql #postgres #ci #github

Pg_lake: Postgres with Iceberg and data lake access

https://github.com/Snowflake-Labs/pg_lake

#HackerNews #Pg_lake #Postgres #Iceberg #DataLake #Snowflake

This is an extremely interesting article looking at the tradeoffs of using #pgvector for #Postgres in production, including the different vector indexing algorithms, metadata filtering, and hybrid search. I'm not sure about its conclusions yet, but definitely food for thought! https://alex-jacobs.com/posts/the-case-against-pgvector/

Kafka is Fast – I'll use Postgres

https://topicpartition.io/blog/postgres-pubsub-queue-benchmarks

#HackerNews #Kafka #Postgres #Benchmarks #PubSub #Performance #TechNews

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/

anybody wanna recommend me a favorite way of remotely managing a #Postgres server (you know, create/delete databases, database users etc) which doesn't involve me vastly increasing the attack surface of said server?

major bonus points if it has any awareness / ability to deal with #PgBouncer.

anybody wanna recommend me a favorite way of remotely managing a #Postgres server (you know, create/delete databases, database users etc) which doesn't involve me vastly increasing the attack surface of said server?

major bonus points if it has any awareness / ability to deal with #PgBouncer.

Spent the last couple days brushing up on web dev, specifically data back and forth / forms.

3 nodes (db, backend, frontend) -> 2 edges = double edge case.

Piping data back and forth, with 1 node being unknowable + error communication is damn complex!

#svelte #sveltekit #valibot #prisma #postgres

I'm a Senior #Software Engineer with 20+ years of professional experience.

I have primarily worked with web technologies such as #JavsScript, #HTML, #CSS, #nodejs, and #typescript.

My last job was as a Senior #React Engineer.

I've worked with #Postgres, #MySQL, and #MSSQL databases.

Backend tech includes C#, Go, PHP, and ASP.

Countless projects ranging from SPAs to $100 million ecommerce sites to enterprise level software.

#getfedihired

I'm a Senior #Software Engineer with 20+ years of professional experience.

I have primarily worked with web technologies such as #JavsScript, #HTML, #CSS, #nodejs, and #typescript.

My last job was as a Senior #React Engineer.

I've worked with #Postgres, #MySQL, and #MSSQL databases.

Backend tech includes C#, Go, PHP, and ASP.

Countless projects ranging from SPAs to $100 million ecommerce sites to enterprise level software.

#getfedihired