Tag
SQLite's WAL mode can cause 'database is locked' errors for short-lived read-only connections due to internal locking of the WAL index file; a busy timeout or switching to DELETE mode can resolve the issue.
Release of sqlite-utils 3.39.1, a Python utility for manipulating SQLite databases.
This blog post debunks the myth that Postgres LISTEN/NOTIFY does not scale, showing how to optimize it for 60K writes per second with millisecond latency.
GoodfireAI used interpretability to predict which genetic variants cause disease, validated predictions with real-world data, and released an open-source database for all variants in the NIH's ClinVar database.
A comprehensive guide for startups running PostgreSQL in production, covering schema design, query optimization, indexes, migrations, connection management, and advanced topics like query planning and partitioning.
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.