Thread:Manual talk:SQLite/SQLite and extension installation issues

The page says: Several extensions are known to have database update or installation issues with SQLite: AbuseFilter, Echo, Flagged Revisions and LiquidThreads

On a test installation using SQLite, I tried installing Echo and Flagged Revisions. And they seemingly work successfully. So, what are the specific issues that we face? Is it something that surfaces after a while?