The perils of UUID primary keys in SQLite

This article discusses the performance implications of using UUID primary keys in SQLite databases, specifically the extra paging caused by unordered UUIDs and how to mitigate it using time-ordered UUIDs.