Topic · 19 stories
19 stories tagged sqlite on AI Tamer, newest first.
Rivet's open-source Durable Objects alternative now has a GA Rust SDK (rivetkit) with SQLite, WebSockets, cron, hibernation and a test harness.
A NOT IN query can lose every candidate when its exclusion set contains NULL. A small SQLite example shows why and how a correlated NOT EXISTS changes the result.
A plain file copy of a SQLite database that a program is still using can be inconsistent or miss recent writes. What SQLite's own documentation says goes wrong, and three supported ways to take a safe copy.
ALTER TABLE ADD COLUMN in SQLite edits the stored schema text and leaves the rows alone, so it takes the same time on one row or ten million. The same design explains the limits on what kind of column you can add.
Marco Bambini's sqlite-multiwriter, a VFS extension created 8 October 2026, claims concurrent writers on one SQLite file. The 5.7x and 3.0x figures are the project's own runs.
SQLite 3.54.0 is dated 9 October 2026, ahead of the 15 October date still on its draft changelog. The release overhauls the shell, drops Windows XP, and adds limits for untrusted SQL.
A transaction can update two attached SQLite databases, but crash atomicity across both files depends on the main database and journal mode. Here is the boundary to check before relying on it.
SQLite busy timeout can wait for a lock to clear, but it may return SQLITE_BUSY immediately when waiting would preserve a transaction deadlock. Design retries around the whole transaction.
A foreign key declaration does not guarantee enforcement on every SQLite connection. Enable it when each connection opens, verify the setting, and check older data for violations.
An open read transaction can keep SQLite’s write-ahead log growing even while automatic checkpoints run. Here is why, and how to find the cause.
A STRICT table can keep unexpected types out of local state. Older SQLite versions need attention before you adopt it.
An error identifier deserves a literal search path. SQLite FTS5 can find token and prefix matches, rank the results, and leave strict spelling checks to the stored field.
SQLite and PostgreSQL use the same name for incompatible binary JSON formats. Transfer JSON as text and let the receiving database build its own representation.
SQLite savepoints let you undo later work while keeping the surrounding transaction open. Here is how to use one and decide what to commit.
Most small AI tools are better served by one database file than by a database server. Where SQLite fits, where its own documentation says to pick something else, and four settings worth turning on from day one.
Supabase (Oct 2, 2026) is acquiring Turso. Supabase continues Postgres; Turso continues SQLite. Glauber Costa joins with Pekka Enberg and the Turso team to lead agentic infrastructure. No deal price is disclosed.
A backup file you have never restored is a hope, not a backup. A short restore drill for small servers, and the two database mistakes it catches most often.
SQLite puts application data, full-text search and, with an extension, vector search in a local database file. Here is where that fits and when PostgreSQL fits better.
MySQL and MariaDB now document native vector features, PostgreSQL can use pgvector, and SQLite can add search through extensions. Here is how to choose by deployment shape and retrieval needs.
