Tag
Notion shares how it scaled its vector search infrastructure by 10x while reducing costs by 90% over two years, detailing their architecture evolution from launch to handling millions of workspaces.
FluentDB is an AI-powered database client for Mac, offering integrated AI features to assist with database queries and management.
Valv is a product that provides a safe database interface for AI agents to query, as featured on ProductHunt.
A tweet by Gergely Orosz highlights that Simon Eskildsen, founder of turbopuffer, kept a blog from 2010–2014, and shares a comprehensive list of recent talks and podcasts about turbopuffer and vector search.
PostgreSQL 19 plans to change the default TOAST compression algorithm from pglz to LZ4, offering better performance and efficiency. The article explains the history of Postgres compression and the reasons for the switch.
A technical blog post from Data Intellect argues that real-time databases (rdbs) should not be the default in kdb+ systems, presenting benchmarks comparing in-memory and on-disk query performance.
This blog post discusses extending Multi-Version Concurrency Control (MVCC) to achieve serializable isolation using TLA+ formal modeling, building on previous work and referencing research by Cahill, Röhm, and Fekete.
Turso announces a project to build a modern, Rust-based version of Postgres using its core database engine, positioning itself as the LLVM of databases with features like self-updating materialized views.
The author details building Homescale, a tool that creates writable database instances and point-in-time branches from immutable snapshots without full data copies, using a Docker-like image and container model for databases.
Oracle introduces Agent Memory, a database-native memory substrate for long-horizon AI agents, achieving 93.8% accuracy with 10.7x fewer tokens compared to flat-history baselines.
This article demonstrates how to detect full table scans in SQLite using its statement statistics API, and suggests integrating this into Rails to warn or raise in test/development environments.
SQLite allows NUL characters in strings but this can cause unexpected behavior in string functions and CLI output; the page explains how to detect and remove embedded NULs.
The article argues that SQLite's defaults for foreign key constraints and type enforcement are problematic and suggests adopting Rust-style editions to allow users to opt into safer defaults.
The article explains the undefined default ordering behavior in SQL queries without ORDER BY, using PostgreSQL examples to show how insertion order, updates, and deletions can change results, and warns against relying on default order for paging.
A blog post defending the necessity of keys and normalization in the relational model, arguing that they reflect ontological requirements for coherent discourse about reality, countering criticisms about practical difficulties in defining keys and domains.
GreptimeDB v1.1 introduces online repartitioning for existing tables via a single ALTER TABLE statement, eliminating the need for data migration, dual-writes, or application changes. It leverages shared object storage and logical shards to update manifests and routing without moving data between nodes.
sqlite-utils 4.1.1 fixes a TransactionError edge case when transforming tables with foreign keys and improves documentation cross-references between CLI and Python API.
SQLite's strict tables enforce rigid typing to prevent common datatype mistakes. The article explains how to use them and their pros and cons.
Ship That Code is a learning platform offering over 80 build-from-scratch courses to teach real systems like Redis, Git, and databases, with structured career paths and multiple languages.
A ground-up reimplementation of PostgreSQL in Rust passes 100% of official tests, is disk-compatible, and claims significant performance improvements (50% faster transactional, ~300x faster analytical) in a WIP version.