Tech News
← Home  ·  All topics

Database

66 GoKawiil briefs on this topic · RSS for database

MySQL replica upgrade exposes AUTO_INCREMENT replication bug, corrupting foreign keys

An engineer upgrading a MySQL database via a replica discovered that a table's auto-incrementing primary key was assigned in a different row order on the replica than on the source. Because six related tables had been migrated to reference these new IDs, one of them ended up pointing to completely wrong rows after the switchover, while the other five happened to remain correct.

Meta and UIUC unveil EvoHarness-RL, matching Claude Opus 4.5 with an 8B model

Researchers from Meta AI and the University of Illinois Urbana-Champaign built EvoHarness-RL, a training framework that teaches a small 8-billion-parameter model to decide when to read, update, or consolidate information it gathers from its execution environment during long, multi-step tasks. Rather than following rigid, human-written scripts for tool use, the model learns to manage its own memory and error recovery, reportedly reaching performance comparable to Claude Opus 4.5 on complex agentic workflows.

New open-source project introduces stateless, typed memory database for AI agents

A developer has released a lightweight database designed specifically for AI agent memory, built on a typed schema with supersession rules instead of relying on semantic text retrieval. The system aims to run cold-first at the edge, avoiding the cost and complexity of maintaining hot vector indexes in RAM or SSDs for smaller, resource-constrained deployments. The project was shared as a Show HN post on Hacker News.

Developer builds self-httpd, a web server that stores itself and its data in one SQLite file

Following up on his earlier SELF executable format that stores a program as a SQLite database, the author released self-httpd, a proof-of-concept web server whose code, website, routes, and visitor logs all live in a single SQLite file. The program reads its own instructions and writes new state, such as button-press logs, back into that same file transactionally, eliminating the need for separate folders like /var, /tmp, or /home.

Developer builds free rollback tool for Flyway's Community Edition using Python

A developer created a workaround that adds rollback functionality to Flyway's free Community Edition, which normally reserves database migration undo capability for paying Teams subscribers. The trick treats every rollback as a forward migration: instead of reversing an applied migration, the tool writes a new, higher-numbered migration containing the reverse SQL, then cleans up Flyway's schema history table so the recorded state matches the database and files on disk. The implementation relies entirely on standard Flyway commands rather than direct SQL execution against the database.

New embedded database LatticeDB combines graph, vector and text search in one file

LatticeDB is a new single-file, embedded property-graph database that supports graph traversal, HNSW-based vector similarity search, and BM25 full-text search through one unified query language. It requires no server or configuration, targets single-machine relationship-heavy workloads, and shares its transaction log across graph writes and event streams for durability.