Extensions

The annual PostgreSQL developer conference will be held in Montreal in May. Like the first PG Con.Dev, there’s also an additional dedicated event - Postgres Extensions Day

ParadeDB aims to be an Elasticsearch alternative: “Modern Elasticsearch Alternative built on Postgres” — PostgreSQL for search and analytics.

Vector-based features will become key elements in building applications, just like JSON in history. PostgreSQL once again stands at the forefront of the times leading database trends, securing high growth in the AI era with vector extension support.

This article focuses on vector databases hyped by AI, introduces the basic principles of AI embeddings and vector storage/retrieval, and demonstrates the functionality, performance, acquisition, and application of the vector database extension PGVECTOR through a concrete knowledge base retrieval case study.

Today encountered an interesting case where a customer reported database connection issues caused by extensions.

TimescaleDB is a PostgreSQL extension plugin that provides time-series database functionality.

A common requirement in application development is GeoIP conversion - converting source IP addresses to geographic coordinates or administrative divisions (country-state-city-county-town-village)

PostGIS is PostgreSQL’s killer extension, but compiling and installing it isn’t easy.