Receive the latest technical articles and release notes in your inbox.
searchgres.js composes BM25, semantic ranking, and filters for hierarchy, metadata, and time in a single Postgres query. Open-source TypeScript, Apache-2.0.
By John Pruitt
October 20th, 2026
No fact extraction, no graphs, no memory manager. One Postgres table and three search tools scored F1 0.665 on LoCoMo.
By Matvey Arye
September 29th, 2026
41 experiments in 6 days took LoCoMo memory from F1 0.392 to 0.666. Claude wrote the code; the human caught the metrics that were lying.
By Matvey Arye
September 28th, 2026
A 20-byte sensor reading costs 95.6 on disk. Measure bytes per row, project 631 billion rows, and test your ingest ceiling before the schema review.
By John Shi
September 25th, 2026
Built for industrial, energy, and robotics systems. Run high-ingest telemetry and real-time analytics on the Postgres you already know.
Composite indexes charge every insert and pay back only some queries. Four steps to price both sides and audit the indexes you already run.
By John Shi
September 18th, 2026
Meshtastic Metrics Exporter reduced 500K+ Prometheus metric series to one Postgres database: consolidated eight queries into one with Tiger Data for 10,000 mesh radio nodes.
By Andrew Stebbins
September 16th, 2026
PostgreSQL write amplification explained: why indexes multiply WAL volume, how to measure it on your tables, and four ways to reduce it without schema changes.
By John Shi
September 11th, 2026
Giving an AI agent unrestricted database access isn't safe. Scoped, read-only, database-enforced access can be. See the framework and guardrails.
By Nicole Ghalwash
September 8th, 2026
Tiger Cloud on Azure vs self-hosting TimescaleDB: skip-scan, compression, continuous aggregates, tiered storage, private endpoints, and cross-region backups—fully managed.
By Nicole Ghalwash
September 3rd, 2026
PostgreSQL table bloat: detect it before it kills performance. Measure heap and index density, set autovacuum thresholds, and alert on dead tuple ratios and vacuum lag.
By John Shi
September 2nd, 2026
