Tag
Ardent is a Y Combinator-backed tool that clones any PostgreSQL database in under 6 seconds at TB scale, enabling coding agents and developers to test code on production-like clones without risking downtime. The tool is already being used by companies like Supermemory and Surface Labs.
GETadb.com offers an instant backend with a relational database, sync engine, and auth, accessible via a simple GET request without sign-up, allowing AI agents like Claude or Codex to build full-stack apps seamlessly.
A developer reports a real UUID v4 collision in a database with only 15,000 records, raising questions about the randomness of the uuid npm package.
Bitfield is a database claiming to be the fastest in the world with read speeds of 0.69ns and write speeds of 0.58ns.
GreptimeDB's flat-format queries now support prefiltering on any column (tags, fields, timestamps), not just primary keys, delivering up to 4.5x faster performance. Additionally, the mito2 storage engine removed its legacy scan path, cleaning up about 1,800 lines of code.
FractalBits introduces a specialized single-node KV storage engine that eliminates fsync calls to achieve significantly higher write throughput on NVMe SSDs by managing durability directly at the hardware level.
A tutorial on optimizing MongoDB query performance using indexes, demonstrating how to identify slow queries, apply compound indexes, and manage them visually using the VisuaLeaf tool. The workflow covers query profiling, index recommendations, and common indexing mistakes.
A new array data type is being added to Redis via a PR, and an interactive WASM-based playground has been built to experiment with the new commands.
Frappe Cloud investigated recurring database freezes affecting thousands of hosted sites by using eBPF tracing to monitor disk I/O at the kernel level, discovering a suspicious query pattern that triggered the incidents.
Ben Dicken emphasizes that sharding is essential for building scalable databases and architecting data-intensive applications.
SQLite prefixes temporary files with 'etilqs_' (sqlite backwards) instead of 'sqlite_' to avoid user complaints after McAfee's antivirus product created confusion with temp files in Windows.
A technical deep-dive into implementing zero-copy page handling in Rust for a database engine, exploring how Rust's lifetime system enables safe zero-copy semantics between the buffer pool and upper database layers while using Direct I/O to bypass the OS page cache.
datasette-export-database version 0.3a1 released, providing database export functionality as part of the Datasette ecosystem.
SQLite 3.53.0 releases with significant accumulated improvements including ALTER TABLE constraint modifications, new JSON functions (json_array_insert), and major CLI mode enhancements via a new Query Results Formatter library.
OpenAI shares technical insights on scaling PostgreSQL to support 800 million ChatGPT users and millions of queries per second, using a single-primary architecture with 50 read replicas while managing challenges from write-heavy workloads through sharding and optimization strategies.