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, PostgreSQL, SQLite, #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-toolsIronclaw — AI CRM, hosted locally on your MacDenchClaw is an open-source AI CRM and workflow automation tool that runs locally on a Mac, using a Chrome profile to automate tasks like database queries, lead enrichment, and outreach.also on DuckDB, #open-source, #developer-toolstinbase — the Supabase-compatible backend that fits in a tintinbase offers a single‑process, Docker‑free Supabase‑compatible backend with real Postgres, RLS, Auth, Storage, and Realtime that runs in Node or the browser.also on PostgreSQL, #open-source, #developer-tools
SQLite JSON at full index speed using generated columns