Comment by mpcjanssen

In the article it describes the N+1 problem with an example of the fossil timeline. In a system using Postgres, you would select all the timeline entries and then generate one big query to get the details of all the timeline items in one sql request. With sqlite you can just iterate over the items and do the queries separately. This makes handling this scenario much simpler.