» Tag
sqlite
24 postsUsing 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.
Executable as a SQLite Database
The SELF file format allows executables as SQLite databases, simplifying ELF complexities.
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.comUsing SQLite as a Document Database
SQLite now supports document database functionality with generated columns for JSON data extraction and indexing.
Why I Developed Local-First Agent Memory
LoreConvo introduces a local-first memory layer using SQLite and FTS5, offering an alternative to traditional vector embedding methods.
We Built a Local SQL Engine for DynamoDB
DynoTable's local SQL engine enhances DynamoDB with essential SQL functionalities.
Database Comparison: SQLite, DuckDB, PostgreSQL, and More
Explore features of SQLite, DuckDB, PostgreSQL, MariaDB, ClickHouse, and MongoDB. Essential insights for engineers.
Building a Video Watch-Time Heatmap: Interval Tracker and More
Create a video watch-time heatmap with zero dependencies. Analyze viewer behavior.
What happens when Cloudflare D1's free 500 MB wall hits
A hands-on probe of Cloudflare D1's free 500 MB storage wall via REST API reveals the exact byte ceiling, DELETE-based recovery, and how indexing a blob column silently doubles storage.
LatticeDB: SQLite-Like Solution for Graph Databases
LatticeDB offers an SQLite-like solution for graph databases. Query relational data with a single file.