DEV Community

# sqlite

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
DuckDB-Iceberg v1.5.3 Features, SQLite R-Tree -0.0 Bug, and pg_kpart for PostgreSQL Partitioning

DuckDB-Iceberg v1.5.3 Features, SQLite R-Tree -0.0 Bug, and pg_kpart for PostgreSQL Partitioning

Comments
3 min read
DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data

DuckDB Data Inlining, SQLite Fossildelta OOB, Postgres 19 Temporal Data

Comments
3 min read
I built a "boring" RAG demo over World Cup data — SQLite, sqlite-vec, and no framework

I built a "boring" RAG demo over World Cup data — SQLite, sqlite-vec, and no framework

Comments
4 min read
SQLite Ecosystem: RTree/JSON Bugs, ON CONFLICT DO SELECT & PG Query Planning

SQLite Ecosystem: RTree/JSON Bugs, ON CONFLICT DO SELECT & PG Query Planning

Comments
3 min read
SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug

SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug

Comments
3 min read
DuckDB Delta Lake Writes, Cross-DB Query Planning, and Pterocos SQLite/DuckDB Editor

DuckDB Delta Lake Writes, Cross-DB Query Planning, and Pterocos SQLite/DuckDB Editor

Comments
3 min read
Why SQLite FTS5's default tokenizer drops your Japanese substrings (and the one-line fix)

Why SQLite FTS5's default tokenizer drops your Japanese substrings (and the one-line fix)

Comments
7 min read
DuckDB vs SQLite: Two Tiny Databases That Don't Actually Compete

DuckDB vs SQLite: Two Tiny Databases That Don't Actually Compete

Comments
6 min read
Agent Retrieval Above the Crossover: A First-Principles Read of CodeGraph

Agent Retrieval Above the Crossover: A First-Principles Read of CodeGraph

Comments
20 min read
DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

DuckLake Spec, pg_background 2.0, and pgsql_tweaks 1.0.3 Enhance Database Ecosystem

Comments
4 min read
Your CLAUDE.md should encode invariants, not a map of where files live

Your CLAUDE.md should encode invariants, not a map of where files live

Comments
3 min read
DuckDB 1.5.2 & DuckLake v1.0 Debut, Plus Embedded SQLite in Scripting Engines

DuckDB 1.5.2 & DuckLake v1.0 Debut, Plus Embedded SQLite in Scripting Engines

Comments
3 min read
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning

DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning

Comments
3 min read
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s

DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s

Comments
3 min read
I Built a Python Probe That Scrapes Zenn's Hidden Stats API and Commits PV Numbers to SQLite Every Hour (and Crashes on Purpose)

I Built a Python Probe That Scrapes Zenn's Hidden Stats API and Commits PV Numbers to SQLite Every Hour (and Crashes on Purpose)

Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.