SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm

Today's Highlights

This week, we dive into a critical SQLite predicate evaluation bug, explore a new tool for preventing dangerous PostgreSQL migrations, and consider a novel approach to database interaction using the filesystem as an API.

SQLITE: LIMIT -1 OFFSET 0 causes incorrect predicate evaluation in subquery (SQLite Forum)

Source: https://sqlite.org/forum/info/bc400a040d74ca621d0fb4e6940db2bcc8b1b8f2a02cf5136eff7739c8d0e0ce