SQLite JSON at full index speed using generated columnskept by eddie • dec 19, 25SQLite can index JSON fields at full B-tree speed by creating virtual generated columns with json_extract and indexing them.AboutDuckDB · PostgreSQL · SQLiteFiled#databases#developer-tools#open-sourceRelatedDeep dive into Turso, the “SQLite rewrite in Rust”Turso rewrites SQLite in Rust to enable a new database engine compatible with SQLite's file format while addressing C's memory safety issues and adding support for concurrent writes.also on #databases, SQLite, PostgreSQL, #open-source, #developer-toolsAn interactive visualization that follows a single HTTP request through its entire ~200ms life — DNS, TCP, TLS, the kernel, Node's event loop, Postgres, and backThe visualization walks through a single HTTP request's ~211 ms journey, showing DNS, TCP, TLS, kernel, Node event loop, Postgres, and rendering.also on #databases, #developer-toolsGitHub - posit-dev/ggsql: A SQL extension for declarative data visualisation based on the Grammar of Graphics.ggsql is a SQL extension that enables declarative data visualization within SQL queries using the Grammar of Graphics, currently supporting DuckDB and SQLite.also on DuckDB, SQLite, #open-source, #developer-toolsPandas Should Go ExtinctPandas becomes inefficient beyond tens of gigabytes, but most analytics workloads stay under 100 GB and are better served by single‑machine tools like Polars or DuckDB.also on DuckDB, #open-source, #developer-tools
SQLite JSON at full index speed using generated columns