» Tag
sqlite
16 postsDuckDB vs SQLite: 100x more rows on the same $16.49 server
On the same $16.49/month server, DuckDB writes 4x-15x faster than SQLite and serves dashboards at 100x the row count. Full Traceway benchmark results.
NMEMORY: An AI Agent Memory That Refuses to Guess
NMEMORY is a local, network-isolated AI agent memory over MCP that abstains instead of fabricating answers. Rust, SQLite, 21 MCP tools, verifiable guarantees.
Engrava: A Deterministic Memory Library for AI Agents Built on SQLite
Engrava is an MIT-licensed Python library storing agent memory as a typed graph in SQLite, with deterministic consolidation instead of LLM rewrites.
CommitBrief — AI code reviews, right in your terminal
A provider-agnostic, local-first CLI that reviews your staged changes, a historic range, or a whole GitHub pull request. Zero telemetry, no server. Free and open source.
commitbrief.comMinisqlite: A Pure-Rust Reimplementation of SQLite
Minisqlite is a pure-Rust reimplementation of SQLite, byte-compatible with its on-disk format, spanning 200K lines and 5,650 tests, no unsafe code.
Per-Row Reservation Pattern for Billing Bulk API Batches
A bulk GSTIN verification endpoint reveals why single balance-check billing fails when some rows are free, and how per-row atomic reservation fixes overselling and race conditions.
DOOMQL: A Doom-like FPS Where SQL Renders Every Pixel
DOOMQL is a terminal-based Doom-like FPS where SQL queries handle all game logic and pixel rendering, with a live SQL audit tool included.
Tailscale Traces 16-Year-Old SQLite WAL-Reset Bug
Tailscale resolved a 16-year-old SQLite bug, improving service reliability.
Using STRICT Tables in SQLite: A New Approach to Error Management
With SQLite 3.37, STRICT tables prevent data type errors, offering developers a more secure data management approach.
Using SQLite in Production: Optimizing WAL Mode and Concurrency
Learn how to optimize SQLite for production environments with WAL mode and concurrency strategies.
SQLite Needs Rust-Style Editions for Better Defaults
SQLite's default settings risk data integrity. Solutions for developers include enabling foreign keys and using strict types.