When I first began exploring how to get involved in the PostgreSQL community, the first event I heard of was PGCon.
A question I often hear, and also ask myself, is “where is PostgreSQL going?
It’s here! pgvector 0.5.0 is released and has some incredible new features.
(Disclosure: I have been contributing to pgvector, though I did not work on the HNSW implementation outside of testing).
Vectors are the new JSON. That in itself is an interesting statement, given vectors are a well-studied mathematical structure, and JSON is a data interchange format.
The last release of PostgreSQL 10 took place on Nov 10, 2022.
Around this time of year, I am reading through the upcoming PostgreSQL release notes (hello PostgreSQL 15), reading mailing lists, and talking to PostgreSQL users to understand what are the impactful features.
On May 12, 2022, the PostgreSQL Global Development Group released its regular quarterly update for all of its supported versions (10-14) containing bug fixes and a security fix for CVE-2022-1552.
Typically when discussing having “read-only” connections to a PostgreSQL database, it is in the context of connecting to a replica.