Rad reimagines how relational databases integrate with application code. It eliminates the friction between schema definitions...
This article addresses a common PostgreSQL optimization challenge: partition pruning normally only works when filtering by the...
Research paper from the VLDB Endowment proceedings. VLDB (Very Large Data Bases) publishes peer-reviewed research in data management and systems.
Technical essay exploring how functional programming concepts and modern language design could improve relational database query languages, featuring practical examples of pattern matching, sum types, and discriminated unions for SQL.
Comprehensive technical article examining how PostgreSQL can replace specialized systems like Kafka, Redis, Elasticsearch, and ClickHouse for most production use cases, emphasizing simplicity and operational efficiency.
An educational puzzle game that teaches SQL querying through solving fictional crimes. A creative approach to learning database fundamentals through gameplay.
ClickHouse is an open-source analytical database that reached its 10-year milestone in June 2026. The project has grown to...
A curated reference of vector-search systems, embedded vector indexes, and object-storage-native database architectures.This...
ManyVector provides vector and full-text search built on object storage, positioned around fast, cost-efficient, scalable search...
Amazon S3 Vectors introduces vector buckets, a purpose-built S3 bucket type for storing and querying vectors.Evaluation note...
The AWS documentation entry point for understanding and using S3 Vectors.Read the S3 Vectors User Guide
The Turbopuffer documentation and API reference.Evaluation note: Prioritise this alongside vecgo and LanceDB when comparing...
Turbopuffer provides vector and full-text search built on object storage, with a focus on speed, lower cost, and scale...
LanceDB is a multimodal lakehouse for AI and an open-source embedded retrieval library for multimodal applications.Evaluation...
The source repository for LanceDB, useful for inspecting its implementation and architecture.Open the LanceDB repository
vec is an embedded vector database in pure Go that aims to feel like SQLite: one database file, SIMD distance kernels, pluggable...
coder/hnsw is an in-memory vector index for Go.Open the coder/hnsw repository
The Go bindings or Go implementation associated with LanceDB.Open the LanceDB Go repository
Vecgo is a pure Go, embeddable hybrid vector database for production workloads, combining commit-oriented durability with HNSW...
govector is a “SQLite for Vectors” in pure Go, with embedded operation, HNSW indexing, no CGO, and a Qdrant-compatible API.Open...
Technical deep-dive from Pinterest Engineering on partition finalization in their next-generation database ingestion framework, covering data pipeline architecture and stream processing.