SQLite Internals & PostgreSQL Multi-Master Replication Updates Today's Highlights This week's database highlights include critical technical discussions from the SQLite forum regarding optimizer behavior and trigger affinity changes, alongside the release of Spock 5.0.7, bringing enhanced logical multi-master replication to PostgreSQL. SQLite drops affinity from NEW/OLD columns in triggers (SQLite Forum) Source: https://sqlite.org/forum/info/819f2d6627c9b2019b4e8415b882bb45900e76045d5d13c4dfaf9c33b812f87c This post from the SQLite forum highlights a significant, albeit subtle, change in how SQLite handles data type affinity for NEW and OLD pseudo-columns within triggers. Previously, these columns inherited the affinity of their corresponding table columns. The recent change, possibly introduced to align with SQL standards or simplify internal logic, means that NEW and OLD columns now default to NUMERIC affinity, or a more generic affinity, rather than the specific type declared for the table column.…