Topic · 14 stories
14 stories tagged databases on AI Tamer, newest first.
pgrust v0.4-beta adds the Gravity JIT engine and opens daily development, a month after ClickBench removed it. Dan Luu cites its Postgres bug reports.
DuckDB 2.0.0 is out with Quack client-server, async I/O for S3, VARIANT, agent mode and triggers. Support runs to October 2027. Test before you upgrade.
PingCAP says stolen service-account credentials let an attacker copy TiDB Cloud records and source code from 9 Sep to 7 Oct. Rotate management API keys now.
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.
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.
Stored and virtual generated columns calculate the same kind of value at different times. A usage total shows how to choose between them.
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.
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.
AWS S3 Vectors (Sep 30, 2026) adds ENHANCED index mode that filters metadata before similarity search, plus $startsWith. AWS claims up to 5× more matching vectors on highly selective filters—vendor figure, not house-verified. No extra cost; CLASSIC until you upgrade.
