A supersedes link plus an effective date makes sense. I'd scope both decisions to the same project: choosing Postgres for a new service shouldn't silently retire a SQLite choice elsewhere. Two retrieval tests would help: 'what applies now?' and 'what applied on this date?' Both should return the supporting record.