Tag
This article from SQLite's official documentation explains the various ways an SQLite database can become corrupted, such as file overwrites by rogue processes, misuse of file descriptors, and unsafe backup procedures, along with mitigation strategies.
This article demonstrates that pre-sorting random data before inserting into SQLite can improve insert performance by 2-3x, by leveraging the B+ Tree's ordered nature and reducing page splits.
A detailed technical guide explaining how PgBouncer works as a PostgreSQL connection pooler, covering its pooling modes, production deployment, and common pitfalls.
A detailed guide on using PostgreSQL as a single database to handle all aspects of a financial application, including schema design, state machines, triggers, and performance optimization.
QuestDB introduces a dedicated WINDOW JOIN operator that is parallelized and vectorized, achieving up to 25x speedup over alternative databases for time-series aggregations around event timestamps.
Cross Canon offers a Bible as a RAG database, allowing users to query scripture using retrieval-augmented generation techniques.
Simon Willison created a tool to convert Mozilla's browser compatibility data into a downloadable SQLite database, hosted with open CORS headers for easy exploration via Datasette Lite.
WebBase-III is a full recreation of dBASE III that runs in the browser, featuring its own W3Script interpreter, BROWSE grid, form engine, indexing, and persistent storage via SQLite.
The paper presents simdjson, the first validating JSON parser capable of processing gigabytes per second on a single core using SIMD instructions, achieving substantial speedups over existing parsers like RapidJSON.
Fluree DB is an open-source, temporal graph database with git-like branching, integrated vector/text/geo search, fine-grained access control, and support for SPARQL, JSON-LD, and Open Cypher. It is optimized for AI agent memory and achieves high performance on billion-scale graphs.
Datasette 1.0a35 alpha release introduces a new create table interface and alter table JSON API, along with stable template context documentation.
Discusses how British Columbia's permanent switch to Pacific Daylight Time in 2026 affects PostgreSQL timestamp storage, and provides best practices to avoid time zone shift errors using a dual-column pattern.
ChartDB is a free and open-source tool that allows you to export the entire database structure by running a single SQL command, automatically generating an ER diagram. It supports multiple databases and has built-in AI natural language query functionality to help developers quickly understand database table relationships.
LinkedRecords is a NoSQL database that enables developers to build SaaS apps where users control where their data is stored, connecting directly from single-page applications without requiring backend code.
Infinite is an open-source runtime that unifies Google Analytics 4, PostHog, and Stripe data into a local database, providing a unified view for analytics and payment data.
GreptimeDB v1.1 introduces online repartitioning for existing tables, incremental Flow reads, a semantic layer for LLMs, and stability improvements.
Cleo is a finetuned version of Qwen3.5-2B-Base designed for text-to-SQL tasks, using a unified harness for training and inference that supports live execution evidence and safety checks. All code, model, and datasets are open-source.
This article explains how TimescaleDB's hypercore engine achieves up to 98% compression for time-series data using columnar storage and specialized algorithms like delta encoding and Gorilla XOR, and contrasts it with PostgreSQL's TOAST.
GreptimeDB v1.1.0 is released, offering up to 97% faster PromQL queries, 20-40% lower overall query times, and up to 4.5x improvement on TSBS scan-heavy queries, along with online repartitioning for existing tables.
LangChain announces SmithDB, a purpose-built distributed database for agent observability that powers LangSmith, offering up to 12x performance improvements and support for complex agent trace queries.